Increase in 'log file sync' waits while 'log file parallel write' remains unchanged
We have small 9.2.0.8 database on AIX, from time to time it
experiences waits
on 'log file sync'. I am unable to explain these waits:
- There is no increase in the number or size of transaction
- While average wait on 'log file sync' increases from 10ms to 124ms
average wait on 'log file parallel write' does not change much -
approx 0.05 ms.
NORMAL PERIOD:
Load Profile
~~~~~~~~~~~~ Per Second Per
Transaction
---------------
---------------
Redo size: 30,016.82
1,384.01
Logical reads: 10,273.75
473.70
Block changes: 179.17
8.26
Physical reads: 5.36
0.25
Physical writes: 6.98
0.32
User calls: 139.45
6.43
Parses: 152.69
7.04
Hard parses: 0.11
0.01
Sorts: 81.40
3.75
Logons: 0.01
0.00
Executes: 587.69
27.10
Transactions: 21.69
PERIOD WITH WAITS ON LOG FILE SYNC
Load Profile
~~~~~~~~~~~~ Per Second Per
Transaction
---------------
---------------
Redo size: 29,366.27
1,385.22
Logical reads: 10,382.59
489.75
Block changes: 173.57
8.19
Physical reads: 4.87
0.23
Physical writes: 6.98
0.33
User calls: 137.17
6.47
Parses: 154.54
7.29
Hard parses: 0.08
0.00
Sorts: 82.76
3.90
Logons: 0.01
0.00
Executes: 591.21
27.89
Transactions: 21.20
So we have approx 20 transactions per second with transaction size
1.3K.
Wait event section
NORMAL PERIOD:
Avg
Total Wait
wait Waits
Event Waits Timeouts Time (s)
(ms) /txn
---------------------------- ------------ ---------- ---------- ------
--------
log file sync 20,386 0 201
10 1.1
db file sequential read 4,784 0 49
10 0.2
db file parallel write 1,186 0 27
23 0.1
control file parallel write 301 0 3
9 0.0
SQL*Net more data to client 67,998 0 2
0 3.5
log file parallel write 19,753 0 1
0 1.0
control file sequential read 368 0 0
1 0.0
latch free 19 15 0
8 0.0
direct path read 11 0 0
4 0.0
direct path write 11 0 0
2 0.0
buffer busy waits 26 0 0
1 0.0
process startup 1 0 0
21 0.0
enqueue 16 0 0
0 0.0
PERIOD WITH WAITS ON LOG FILE SYNC
Avg
Total Wait
wait Waits
Event Waits Timeouts Time (s)
(ms) /txn
---------------------------- ------------ ---------- ---------- ------
--------
log file sync 22,546 2,478 2,803
124 1.2
db file sequential read 3,605 0 46
13 0.2
db file parallel write 1,161 0 26
22 0.1
control file parallel write 304 0 25
82 0.0
control file sequential read 336 0 14
40 0.0
enqueue 26 0 4
172 0.0
log file sequential read 106 0 4
35 0.0
SQL*Net more data to client 69,471 0 2
0 3.6
log file parallel write 18,958 0 1
0 1.0
db file scattered read 102 0 1
9 0.0
log file switch completion 2 0 0
70 0.0
latch free 19 13 0
7 0.0
async disk IO 193 0 0
1 0.0
buffer busy waits 28 0 0
2 0.0
vsevolod.afanassiev
comp.databases.oracle.server
22978 articles. 
1 followers.
7 Replies
1163 Views
On Sep 21, 6:52=A0pm, vsevolod afanassiev <vsevolod.afanass...@gmail.com> wrote: snip > We have small 9.2.0.8 database on AIX, from time to time it > experiences waits > on 'log file sync'. I am unable to explain these waits: > - There is no increase in the number or size of transaction > - While average wait on 'log file sync' increases from 10ms to 124ms > average wait on 'log file parallel write' does not change much - > approx 0.05 ms. Do you have available cpu time on this system when the log file waits shoot up? Unless you are showing some signs of severe cpu starvation ( that might have been missed possibly ) I think you gotta check out the IO subsystem. My databases get about .5 ms for log file sync ... 10 ms is ugly and 100 ms just ouch. Local storage or SAN? Can you get some iostat information during the bad times?
johnbhurley> Do you have available cpu time on this system when the log file waits > shoot up? This is LPAR on big AIX p595 frame, it has 32 CPU. > Unless you are showing some signs of severe cpu starvation ( that > might have been missed possibly ) I think you gotta check out the IO > subsystem. > My databases get about .5 ms for log file sync ... 10 ms is ugly and > 100 ms just ouch. 'log file sync' is wait experienced by foreground user process while 'log file parallel write' is wait event experienced by Log Writer. I thought that slow I/O will lead to increase in 'log file parallel write'. I checked db once agai, found that log_buffer is set to 1MB. If we unset it the default value will be 4 MB (128K * cpu_count), I don't think it will help. > Local storage or SAN? =A0Can you get some iostat information during the > bad times? Yes, this is EMC DMX-something (2000).
On Sep 21, 7:52=A0pm, vsevolod afanassiev <vsevolod.afanass...@gmail.com> wrote: snip > > Do you have available cpu time on this system when the log file waits > > shoot up? > > This is LPAR on big AIX p595 frame, it has 32 CPU. Does your LPAR have available cpu when the slow log file syncs occur? > > > Unless you are showing some signs of severe cpu starvation ( that > > might have been missed possibly ) I think you gotta check out the IO > > subsystem. > > My databases get about .5 ms for log file sync ... 10 ms is ugly and > > 100 ms just ouch. > > 'log file sync' is wait experienced by foreground user process while > 'log file parallel write' > is wait event experienced by Log Writer. I thought that slow I/O will > lead to increase > in 'log file parallel write'. Log file sync usually means transactions are in a commit. If you have bad log file sync ... it needs to be fixed. > I checked db once agai, found that log_buffer is set to 1MB. If we > unset it the > default value will be 4 MB (128K * cpu_count), I don't think it will > help. Most of my systems are at 128 MB ... why would you have a system with a 1 MB log buffer? > > Local storage or SAN? =A0Can you get some iostat information during the > > bad times? > > Yes, this is EMC DMX-something (2000). Hard to believe you are getting 10 ms average on a system like that ( even when your db is "good"). That doesn't make much sense to me. Do an iostat 10 10 when the log file syncs are spiking and post the results if you can.
On Sep 21, 8:02=A0pm, John Hurley <johnbhur...@sbcglobal.net> wrote: snip > Most of my systems are at 128 MB ... why would you have a system with > a 1 MB log buffer? Missed ... looks like my systems are at 10 MB log_buffer not sure why 128 jumped into my mind. The old advice for 1MB is afaik not relevant much anymore. Several metalink articles available if you search log_buffer ...
On Sep 21, 5:14=A0pm, John Hurley <johnbhur...@sbcglobal.net> wrote: > On Sep 21, 8:02=A0pm, John Hurley <johnbhur...@sbcglobal.net> wrote: > > snip > > > Most of my systems are at 128 MB ... why would you have a system with > > a 1 MB log buffer? > > Missed ... looks like my systems are at 10 MB log_buffer not sure why > 128 jumped into my mind. > > The old advice for 1MB is afaik not relevant much anymore. =A0Several > metalink articles available if you search log_buffer ... Pehaps you've forgotten that Oracle rounds up log buffer to fill up a granule on 10gR2 and up. Perhaps at some point you set a 65M log_buffer and found it at 128. Perhaps you're running apps and that's what was recommended before 10gR2. Here's a forum thread that explains some stuff, including that a too- big buffer may cause log syncs: http://forums.oracle.com/forums/thread.jsp= a?messageID=3D1940709� Of course, I don't expect that 1M is too big. I'd guess that something is happening on the OS side periodically that is pounding I/ O (or like you suggested, cpu starvation is preventing I/O from happening, but...). The waits aren't on parallel write perhaps because it's being written to a hardware cache, but the commit ack isn't coming back. Would there be snaps happening on the SAN? Why does this sound so familiar, like an async i/o problem? Which AIX is this? Search metalink for async i/o ibm, see things like Note: 233659.1 jg -- @home.com is bogus. http://www3.signonsandiego.com/stories/2009/sep/22/dell-reaches-deal-buy-pe= rot-systems/?uniontrib
joel-garryThere is a bug in 9i due to which lgwr reports erroneous values for "log file parallel write". See Jonathan's note on this. http://www.jlcomp.demon.co.uk/log_file_writes.html Use OS tracing commands like truss to get the lgwr io timings. regards srivenu
srivenuOn Oct 2, 12:49=A0pm, Srivenu Kadiyala <sriv...@hotmail.com> wrote: > There is a bug in 9i due to which lgwr reports erroneous values for > "log file parallel write". > See Jonathan's note on this.http://www.jlcomp.demon.co.uk/log_file_writes= ..html > > Use OS tracing commands like truss to get the lgwr io timings. > > regards > srivenu Ah, that must be why it sounds so familiar. Thanks! But Jonathan's note does say "If you=92ve ever been in the habit of discounting the log writer as a source of performance problems because the log writer times are good =96 think again. Any timings from the log writer are not to be trusted in 9.2. If you see high average wait times on log file sync, this may be the only way you can infer that you might have an I/O problem in the log writer." The increasing average wait times on log file sync is what the OP was asking about. I think we're all agreed that looking at what the OS is doing with I/O is what needs to be done. jg -- @home.com is bogus. There must be a Oracle Top Gun joke in here somewhere: http://www3.signonsandiego.com/stories/2009/oct/02/airborne-artistry/
Similar Artilces:
'cat file' but only if 'file' exist
I'm trying to run 'cat *.x' only if *.x files exist. What is the cleanest way of doing this? I'm doing it by shopt -s nullglob for i in *.x; do cat $i; done but this is aweful typing. -- William Park, Open Geometry Consulting, <opengeometry@yahoo.ca> No, I will not fix your computer! I'll reformat your harddisk, though. On 2004-06-09, William Park wrote: > I'm trying to run 'cat *.x' only if *.x files exist. What is the > cleanest way of doing this? I'm doing it by > shopt -s nullglob > for i in *.x; do cat $i; done ...
'is not' or '!='
A newbie question to you; what is the difference between statements like: if x is not None: and if x != None: Without any context, which one should be preferred? IMHO, the latter is more readable. On 2014-08-18 21:35, ElChino wrote: > A newbie question to you; what is the difference between statements > like: > if x is not None: > and > if x != None: > > Without any context, which one should be preferred? > IMHO, the latter is more readable. > "x == y" tells you whether x and y refer to objects that are equal. "x is y" tells you whether x and y actually refer to the same object. In the case of singletons like None (there's only one None object), it's better to use "is". "ElChino" <elchino@cnn.cn>: > A newbie question to you; what is the difference between statements > like: > if x is not None: > and > if x != None: Do the following: take two $10 bills. Hold one bill in the left hand, hold the other bill in the right hand. Now, the bill in the left hand "is not" the bill in the right hand. However, the bill in the left hand "==" the bill in the right hand. > Without any context, which one should be preferred? > IMHO, the latter is more readable. In almost all cases, both tests would result in the same behavior. However, the "is not" test is conceptually the correct one since you want...
'^=' and '~='?
Hello, What is the difference between '^=' and '~='? Thanks, Duckhye ...
'YScale','log',
I would like to convert a graph from linear y-axis, to a logarithmic y-axis. However, once that is done, one of the vertical lines (which I use to indicate the required point) disappears. See the image below: http://img517.imageshack.us/img517/4937/weirdak0.jpg My plotting code: figure1 = figure('Color',[0.8 0.8 0.8]); axes('Parent',figure1,'YScale','log','YMinorTick','on','YMinorGrid','on',... 'FontSize',8,... 'FontName','Verdana'); xlim([1 2.2]); ylim([0 1000]); box('on'); grid('o...
``awk '!a[$0]++' file'' and ``awk '{if(!($0 in rec)) {rec[$0]=1; print $0;}}' file ''
Hi all, Currently, I'm reading the book on awk programming language, but meet the following two examples which I cann't understand so well: awk '!a[$0]++' file and awk '{if(!($0 in rec)) {rec[$0]=1; print $0;}}' file Could someone here please give me some hints or explanations on the logic of above codes? Regards -- ..: Hongyi Zhao [ hongyi.zhao AT gmail.com ] Free as in Freedom :. In article <meuejm$gsf$1@aspen.stu.neva.ru>, Hongyi Zhao <hongyi.zhao@gmail.com> wrote: > Hi all, > > Currently, I'm reading the bo...
Problem of 'set(gca, 'yscale', 'log')'
I used the following code to plot F. Everything went well until the last line was executed. The warning message 'Warning: Negative data ignored' popped up and the image totally went wrong. I double-checked the values of 'd' and was pretty sure that it was greater than 0. Would anybody please help me figure this out? Thank you very much! N = 1000; t = 3e-9; d = 0.0001:0.01:1; w = logspace(-3, 1, 101)/t; [D, W] = meshgrid(d, w); S = sqrt((D.*((2*pi./W).^2+4*(pi*t)^2).^2.*(2*pi*D.*... ((2*pi./W).^4+20*((2*pi./W)*pi*t).^2+64*(pi*t)^4)-(2*pi./W).^2.*((2...
web('file', 'filename' '-browser') not working
Hello, I'm working on a project involving Matlab and a nice flashy GUI. To call help files, I do: web('file', 'help.html' '-browser'); On my computer, this works. After compiling it, it works. If I manage to get the current directory wrong, somehow, the browser attempts to go to www.help.com, rather than put up an error. So far so good, except when the file isn't there, which I'm ignoring for the moment. However, when I run the program on other computers (I compile the program first), it always goes to www.help.com, no matter what the pwd says, or where I put help.html. This seems to happen on about half of the other computers I try it on. Any ideas? I had thought it was just path mixups but putting 'pwd' in the appropriate places seems to indicate nothing is amiss. I do not want to use explicit path names, (ie 'file:///c:/stuff/help.html' syntax) as this program is meant for some distribution and I can't guarantee that people will always have it running from the same location. Thank you in advance, --Anne I finally did a = sprintf('file:///%shelp.html#%s', pwd, section); web('file', a, '-browser'); I discovered that the file:/// syntax does not require paths to be deliminated by '/' but can use '\' unlike what I had thought. I read a bug report that using the internal web browser crashes when using compiled code. However, a similar crash happens for me when using R2006a....
'''''''''''''The Running Update/Append Queries Using VBA code Ordeal''''''''''''''
Hello fellow programmers, I am trying to run an append/update query from code, a command button on a form initiates the queries. the format i am using is; _____________________________________________________ SELECT "criteria" FROM "criteria" WHERE "criteria" UPDATE/APPEND "field selections" RecordSource "qryExample" = above text strings" _______________________________________________________________________ When i am running a SELECT query in this manner it works fine with no problems, and accepts the values of specified linked for...
exist('fname','file')
Hello I have a file 'fname' in one of the directories under the matlabpath. the file was saved by the SAVE function. when I exist('fname','file') ans = 0 why it is not showing 2 since it exists? I also tried the full path name of the file, thanks Is the filename actually 'fname'? Or is the filename stored in the fname variable? Or is there an extension? (i.e. fname.mat) Is it in a different directory? If fname is a variable, you need to leave off the quotes: exist(fname,'file') If it has an extension, you need to put that on: e...
Difference between a 'file' and a 'table'
With OS400, all files are objects that can be accessed relationally. When I view the file system from Navigator (windows client), I see there is the Database and SQL tables, then there is the filesystem. I can manipulate both these objects (tables, files) with SQL. So, what is the difference between a table and a file? -- Texeme http://texeme.com Without being strict in its definition a file and a table in OS/400 are the same. If you go into object types you will find that there is a Type *FILE and a Type *TBL, maybe I will ask the next question, what is the difference ...
'to file' and 'to workspace' help
I have a model that runs a 4 degrees of freedom robot here, right now I am only working with rotating the robot though. I have the model using a repeating sequence stair block as an input, this waits 10 seconds spins 5 degrees waits 10 secs spins 5 more degrees all the way up to 360 then i have a stop simulation block that stops the simulation once it has reached 360. The model works perfectly for my purpose, but in my feedback loop that reads my encoder position i am trying to insert a to file or to workspace block so that i can keep track of the encoder readings while the robot is stopped ...
'''''''''''''The Running Update/Append Queries Using VBA code Ordeal'''''''''''''' #2
Hi, Thanks for ur help there HJ. I know how to do the tasks you specified there. I would like for the update query to use field values from some of the fields on the form (frmInvoices) such as InvoiceNumber, DateFrom, DateTo. My problem is that an append/update query can't find the values in the open Form (frmInvoices) when I specify them as; [Forms]![frmInvoices]![InvoiceNumber] a select query has no problem finding the field values on a form. please help. Aaron Hi Aaron, Could you post the entire code that you are having trouble with? Now it is not possible to see what goes wrong. HJ "Aaron" <aaron@rapid-motion.co.uk> wrote in message news:260d7f40.0408120245.2f3d01f8@posting.google.com... > Hi, > > Thanks for ur help there HJ. > > I know how to do the tasks you specified there. > > I would like for the update query to use field values from some of the > fields on the form (frmInvoices) such as InvoiceNumber, DateFrom, > DateTo. My problem is that an append/update query can't find the > values in the open Form (frmInvoices) when I specify them as; > > [Forms]![frmInvoices]![InvoiceNumber] > > a select query has no problem finding the field values on a form. > > please help. > > Aaron First off, if you are not always using all the parameters specified in your form, then you have to add parameters to your query on the fly. Also, you can't just do something like qdf.SQL = "SE...
if str_mo not in ('','.') and str_da not in ('','.') and str_yy not in ('','.') Any shorter ?
Hi, there. =20 I'm just curious if it ever dawned on anybody how to abbreviate this line : if str_mo not in ('','.') and str_da not in ('','.') and str_yy not in ('','.')=20 =20 Igor Kurbeko Clinical Programmer Analyst 678 336 4328 ikurbeko@atherogenics.com =20 no brain no pain =20 how about: if not (str_mo in ('','.') or str_da in ('','.') or str_yy in ('','.')) OR if not (missing(str_mo) or missing(str_da) or missing(str_yy)) Eric On 22 Oct 03 21:13:37 GMT, ikurbeko@ATHER...
Tuning 'log file sync'
One of our database experiences heavy waits on 'log file sync'. Top waits from V$SYSTEM_EVENT are given below. 'Log file sync' exceeds 'db file sequential read' and 'db file scattered read'. Metalink Note 223117.1 says that they key to understanding 'log file sync' is to compare average times waited for 'log file sync' and 'log file parallel write': if they are similar then it is I/O problem, but if they are different then "the delay is caused by the other parts of Redo Logging mechanism that occur during a COMMIT/ROLLBACK (and are n...
'Adding new data file' vs 'extending existing data file size' to increase Tablespace
As the Tablespace is almost filled on the running system now, we have to add additional space to the Tablespace. As I understand, the following are the two options available to do that: 1) Add a new data file to hold the additional data in Tablespace: SQL> alter tablespace my_TS add datafile '/someDir/my_TS2.dbf' size 100M; 2) Resize the existing Tablespace's data file. SQL> alter database datafile '/someDir/my_TS1.dbf' resize 200M; What is the best way to go? In my understanding, the 1st option is not preferable as the Tablespace is spread over 2 data files and ...
Gui having an 'open file window' and a 'save file window'
Is it possible to click on a button in the gui and have a Windows-like window where I can select the file to open and another like when you click on 'save as'? Thank you very much nathaniel zoso wrote: > Is it possible to click on a button in the gui and have a > Windows-like window where I can select the file to open and another > like when you click on 'save as'? > > Thank you very much Check out the UIGETFILE and UIPUTFILE functions, respectively. -SteveSimon ...
change 'file name' in 'From Multimedia File' simulink block
I need to load a avi video into workspace and do some processing work. I use the 'From Multimedia File' block in simulink to extract the audio of the avi file. The question is that if for different avi files, i have to manually set the 'file name' of the 'From Multimedia File' everytime before start the simulation. I can read the avi file in a .m file and get the path name and filename first. Is that possible to send these path name and filename automatically to the 'file name' in 'From Multimedia File' block when the avi file is loaded? thx a lo...
Is 'du -b file' equivalent to 'wc -c file'?
Hi all, It seems that both 'du -b file' and 'wc -c file' can give the correct bytes count on the file. Are they equivalent for all case on this type of job? Regards -- ..: Hongyi Zhao [ hongyi.zhao AT gmail.com ] Free as in Freedom :. On 2015-05-22, Hongyi Zhao <hongyi.zhao@gmail.com> wrote: > Hi all, > > It seems that both 'du -b file' and 'wc -c file' can give the correct > bytes count on the file. Are they equivalent for all case on this type of > job? > > Regards There's no -b switch for du on my system (Mac OS X 10.10.3), and it's not in POSIX. The -c switch for wc is however standard, so use that instead. Note that you will have to use -m with wc to always get the correct number of *characters* in a file. -- :: Andreas Kusalananda Kahari, Uppsala University, Sweden :: :: a n d r e a s . k a h a r i @ i c m . u u . s e :: On Fri, 22 May 2015 06:52:32 +0000, Kusalananda wrote: > There's no -b switch for du on my system (Mac OS X 10.10.3), I can find the following for my case manpage of du: -b, --bytes equivalent to '--apparent-size --block-size=1' --apparent-size print apparent sizes, rather than disk usage; although the apparent size is usually smaller, it may be larger due to holes in ('sparse') files, internal fragmentation, indirect blocks, and the like -B, --block-size=SIZE scale sizes by SIZE befo...
Fetch the newest file containing the string 'fgractg*.log' in the filename and contains the string 'ORA-' in it
Hello, I posted a message a month ago and I still have the same questions unresolved. I hope I am clear in my question. I am trying to develop a shell script that checks whether the newest file modified today that contains the string 'fgractg*.log' in the filename ALSO contains the string 'ORA-' in the file and if so, it gives the name of the file. I have this from someone else andd it also has syntax errors and does not work for me. fgractg_check=` ls -ltr fgractg*\.log | grep "`date +'%b %e'" | sed "s/.* \(fgractg*\.log\)$/grep -l 'fgractg...
A function with 'and' , 'not' , 'null' , 'car' and 'cdr'
What's this ? (defun enigma (x) (and (not (null x)) (or (null (car x)) (enigma (cdr x))))) "I suppose I should learn Lisp, but it seems so foreign." - Paul Graham, Nov 1983 On Wed, Oct 07 2015, CAI GENGYANG wrote: > What's this ? > > > (defun enigma (x) > (and (not (null x)) > (or (null (car x)) > (enigma (cdr x))))) Bad taste? It returns T if the list X contains nil as an element. It would be clearer to write (some #'null x). Helmut CAI GENGYANG ...
Issue with the 'script' command in users '.kshrc' and '.bashrc' files
I am attempting to monitor users actions by using the following 'script' command: # exec script -a /tmp/${LOG} In order to capture all types of login whether 'telnet', su, su - etc etc I have put it into the .profile, .dtprofile and the *rc shell files. This works fine for CSH and SH, however if I launch another session (dtterm &) or switch shell to either KSH or BASH, then it seems to spin round and attempt to infinately create fresh 'script' sessions until I quit out. Example below: Script started, file is /tmp/x Script started, file is /tmp/x Script started,...
Re: if str_mo not in ('','.') and str_da not in ('','.') and str_yy not in ('','.') Any shorter ?
OR you could use ARRAY data new; set old; array igor $ (*) str_mo str_da str_yr; do over igor; if igor ~in (' ','.') then do; end; run; Prasad Ravi Igor Kurbeko <ikurbeko@ATHEROGENIC To: SAS-L@LISTSERV.UGA.EDU S.COM> cc: Sent by: "SAS(r) Subject: if str_mo not in ('','.') and str_da not in ('','.') and str_yy ...
error: expected '=', ',', ';', 'asm' or '__attrib
Hi I'm trying to compile an ADC Driver & come acrosss the following error. I've no experience writing drivers before, and hence have no clue how to fix it. Hope someone out there has encountered the problem & suggesst a fix for the same. The Error is I get is : qadc.c: At top level: qadc.c:97: error: expected '=', ',', ';', 'asm' or '__attribute__' before 'qadc_read' make: *** [qadc.o] Error 1 [root@localhost qadc]# ########################################################################### ADC Driver Code ########################################################################### #define MODULE #define __KERNEL__ #include <linux/config.h> #include <linux/module.h> #include <linux/kernel.h> /* printk */ #include <linux/fs.h> / #include <linux/errno.h> /* error codes */ #include <linux/types.h> /* size_t */ #include <linux/proc_fs.h> /* proc file system */ #include <linux/fcntl.h> #include <asm/system.h> /* cli, flags */ #include <asm/uaccess.h> /* copy from/to user */ /*Registers to get qadc access*/ volatile unsigned short * qadcmcr = (unsigned short *)0x40190000; volatile unsigned short * qacr0 = (unsigned short *)0x4019000a; volatile unsigned short * qacr1 = (unsigned short *)0x4019000c; volatile unsigned short * qacr2 = (unsigned short *)0x4019000e; volatile unsigned short * qasr0 = (unsigned short *)0x40190010; volatile unsigned short * qasr1...
error: expected '=', ',', ';', 'asm' or '__attrib
Hi I'm trying to compile an ADC Driver & come acrosss the following error. I've no experience writing drivers before, and hence have no clue how to fix it. Hope someone out there has encountered the problem & suggesst a fix for the same. The Error is I get is : qadc.c: At top level: qadc.c:97: error: expected '=', ',', ';', 'asm' or '__attribute__' before 'qadc_read' make: *** [qadc.o] Error 1 [root@localhost qadc]# ########################################################################### ADC Driver Code ##...
I'm trying to run 'cat *.x' only if *.x files exist. What is the cleanest way of doing this? I'm doing it by shopt -s nullglob for i in *.x; do cat $i; done but this is aweful typing. -- William Park, Open Geometry Consulting, <opengeometry@yahoo.ca> No, I will not fix your computer! I'll reformat your harddisk, though. On 2004-06-09, William Park wrote: > I'm trying to run 'cat *.x' only if *.x files exist. What is the > cleanest way of doing this? I'm doing it by > shopt -s nullglob > for i in *.x; do cat $i; done ...
'is not' or '!='
A newbie question to you; what is the difference between statements like: if x is not None: and if x != None: Without any context, which one should be preferred? IMHO, the latter is more readable. On 2014-08-18 21:35, ElChino wrote: > A newbie question to you; what is the difference between statements > like: > if x is not None: > and > if x != None: > > Without any context, which one should be preferred? > IMHO, the latter is more readable. > "x == y" tells you whether x and y refer to objects that are equal. "x is y" tells you whether x and y actually refer to the same object. In the case of singletons like None (there's only one None object), it's better to use "is". "ElChino" <elchino@cnn.cn>: > A newbie question to you; what is the difference between statements > like: > if x is not None: > and > if x != None: Do the following: take two $10 bills. Hold one bill in the left hand, hold the other bill in the right hand. Now, the bill in the left hand "is not" the bill in the right hand. However, the bill in the left hand "==" the bill in the right hand. > Without any context, which one should be preferred? > IMHO, the latter is more readable. In almost all cases, both tests would result in the same behavior. However, the "is not" test is conceptually the correct one since you want...
'^=' and '~='?
Hello, What is the difference between '^=' and '~='? Thanks, Duckhye ...
'YScale','log',
I would like to convert a graph from linear y-axis, to a logarithmic y-axis. However, once that is done, one of the vertical lines (which I use to indicate the required point) disappears. See the image below: http://img517.imageshack.us/img517/4937/weirdak0.jpg My plotting code: figure1 = figure('Color',[0.8 0.8 0.8]); axes('Parent',figure1,'YScale','log','YMinorTick','on','YMinorGrid','on',... 'FontSize',8,... 'FontName','Verdana'); xlim([1 2.2]); ylim([0 1000]); box('on'); grid('o...
``awk '!a[$0]++' file'' and ``awk '{if(!($0 in rec)) {rec[$0]=1; print $0;}}' file ''
Hi all, Currently, I'm reading the book on awk programming language, but meet the following two examples which I cann't understand so well: awk '!a[$0]++' file and awk '{if(!($0 in rec)) {rec[$0]=1; print $0;}}' file Could someone here please give me some hints or explanations on the logic of above codes? Regards -- ..: Hongyi Zhao [ hongyi.zhao AT gmail.com ] Free as in Freedom :. In article <meuejm$gsf$1@aspen.stu.neva.ru>, Hongyi Zhao <hongyi.zhao@gmail.com> wrote: > Hi all, > > Currently, I'm reading the bo...
Problem of 'set(gca, 'yscale', 'log')'
I used the following code to plot F. Everything went well until the last line was executed. The warning message 'Warning: Negative data ignored' popped up and the image totally went wrong. I double-checked the values of 'd' and was pretty sure that it was greater than 0. Would anybody please help me figure this out? Thank you very much! N = 1000; t = 3e-9; d = 0.0001:0.01:1; w = logspace(-3, 1, 101)/t; [D, W] = meshgrid(d, w); S = sqrt((D.*((2*pi./W).^2+4*(pi*t)^2).^2.*(2*pi*D.*... ((2*pi./W).^4+20*((2*pi./W)*pi*t).^2+64*(pi*t)^4)-(2*pi./W).^2.*((2...
web('file', 'filename' '-browser') not working
Hello, I'm working on a project involving Matlab and a nice flashy GUI. To call help files, I do: web('file', 'help.html' '-browser'); On my computer, this works. After compiling it, it works. If I manage to get the current directory wrong, somehow, the browser attempts to go to www.help.com, rather than put up an error. So far so good, except when the file isn't there, which I'm ignoring for the moment. However, when I run the program on other computers (I compile the program first), it always goes to www.help.com, no matter what the pwd says, or where I put help.html. This seems to happen on about half of the other computers I try it on. Any ideas? I had thought it was just path mixups but putting 'pwd' in the appropriate places seems to indicate nothing is amiss. I do not want to use explicit path names, (ie 'file:///c:/stuff/help.html' syntax) as this program is meant for some distribution and I can't guarantee that people will always have it running from the same location. Thank you in advance, --Anne I finally did a = sprintf('file:///%shelp.html#%s', pwd, section); web('file', a, '-browser'); I discovered that the file:/// syntax does not require paths to be deliminated by '/' but can use '\' unlike what I had thought. I read a bug report that using the internal web browser crashes when using compiled code. However, a similar crash happens for me when using R2006a....
'''''''''''''The Running Update/Append Queries Using VBA code Ordeal''''''''''''''
Hello fellow programmers, I am trying to run an append/update query from code, a command button on a form initiates the queries. the format i am using is; _____________________________________________________ SELECT "criteria" FROM "criteria" WHERE "criteria" UPDATE/APPEND "field selections" RecordSource "qryExample" = above text strings" _______________________________________________________________________ When i am running a SELECT query in this manner it works fine with no problems, and accepts the values of specified linked for...
exist('fname','file')
Hello I have a file 'fname' in one of the directories under the matlabpath. the file was saved by the SAVE function. when I exist('fname','file') ans = 0 why it is not showing 2 since it exists? I also tried the full path name of the file, thanks Is the filename actually 'fname'? Or is the filename stored in the fname variable? Or is there an extension? (i.e. fname.mat) Is it in a different directory? If fname is a variable, you need to leave off the quotes: exist(fname,'file') If it has an extension, you need to put that on: e...
Difference between a 'file' and a 'table'
With OS400, all files are objects that can be accessed relationally. When I view the file system from Navigator (windows client), I see there is the Database and SQL tables, then there is the filesystem. I can manipulate both these objects (tables, files) with SQL. So, what is the difference between a table and a file? -- Texeme http://texeme.com Without being strict in its definition a file and a table in OS/400 are the same. If you go into object types you will find that there is a Type *FILE and a Type *TBL, maybe I will ask the next question, what is the difference ...
'to file' and 'to workspace' help
I have a model that runs a 4 degrees of freedom robot here, right now I am only working with rotating the robot though. I have the model using a repeating sequence stair block as an input, this waits 10 seconds spins 5 degrees waits 10 secs spins 5 more degrees all the way up to 360 then i have a stop simulation block that stops the simulation once it has reached 360. The model works perfectly for my purpose, but in my feedback loop that reads my encoder position i am trying to insert a to file or to workspace block so that i can keep track of the encoder readings while the robot is stopped ...
'''''''''''''The Running Update/Append Queries Using VBA code Ordeal'''''''''''''' #2
Hi, Thanks for ur help there HJ. I know how to do the tasks you specified there. I would like for the update query to use field values from some of the fields on the form (frmInvoices) such as InvoiceNumber, DateFrom, DateTo. My problem is that an append/update query can't find the values in the open Form (frmInvoices) when I specify them as; [Forms]![frmInvoices]![InvoiceNumber] a select query has no problem finding the field values on a form. please help. Aaron Hi Aaron, Could you post the entire code that you are having trouble with? Now it is not possible to see what goes wrong. HJ "Aaron" <aaron@rapid-motion.co.uk> wrote in message news:260d7f40.0408120245.2f3d01f8@posting.google.com... > Hi, > > Thanks for ur help there HJ. > > I know how to do the tasks you specified there. > > I would like for the update query to use field values from some of the > fields on the form (frmInvoices) such as InvoiceNumber, DateFrom, > DateTo. My problem is that an append/update query can't find the > values in the open Form (frmInvoices) when I specify them as; > > [Forms]![frmInvoices]![InvoiceNumber] > > a select query has no problem finding the field values on a form. > > please help. > > Aaron First off, if you are not always using all the parameters specified in your form, then you have to add parameters to your query on the fly. Also, you can't just do something like qdf.SQL = "SE...
if str_mo not in ('','.') and str_da not in ('','.') and str_yy not in ('','.') Any shorter ?
Hi, there. =20 I'm just curious if it ever dawned on anybody how to abbreviate this line : if str_mo not in ('','.') and str_da not in ('','.') and str_yy not in ('','.')=20 =20 Igor Kurbeko Clinical Programmer Analyst 678 336 4328 ikurbeko@atherogenics.com =20 no brain no pain =20 how about: if not (str_mo in ('','.') or str_da in ('','.') or str_yy in ('','.')) OR if not (missing(str_mo) or missing(str_da) or missing(str_yy)) Eric On 22 Oct 03 21:13:37 GMT, ikurbeko@ATHER...
Tuning 'log file sync'
One of our database experiences heavy waits on 'log file sync'. Top waits from V$SYSTEM_EVENT are given below. 'Log file sync' exceeds 'db file sequential read' and 'db file scattered read'. Metalink Note 223117.1 says that they key to understanding 'log file sync' is to compare average times waited for 'log file sync' and 'log file parallel write': if they are similar then it is I/O problem, but if they are different then "the delay is caused by the other parts of Redo Logging mechanism that occur during a COMMIT/ROLLBACK (and are n...
'Adding new data file' vs 'extending existing data file size' to increase Tablespace
As the Tablespace is almost filled on the running system now, we have to add additional space to the Tablespace. As I understand, the following are the two options available to do that: 1) Add a new data file to hold the additional data in Tablespace: SQL> alter tablespace my_TS add datafile '/someDir/my_TS2.dbf' size 100M; 2) Resize the existing Tablespace's data file. SQL> alter database datafile '/someDir/my_TS1.dbf' resize 200M; What is the best way to go? In my understanding, the 1st option is not preferable as the Tablespace is spread over 2 data files and ...
Gui having an 'open file window' and a 'save file window'
Is it possible to click on a button in the gui and have a Windows-like window where I can select the file to open and another like when you click on 'save as'? Thank you very much nathaniel zoso wrote: > Is it possible to click on a button in the gui and have a > Windows-like window where I can select the file to open and another > like when you click on 'save as'? > > Thank you very much Check out the UIGETFILE and UIPUTFILE functions, respectively. -SteveSimon ...
change 'file name' in 'From Multimedia File' simulink block
I need to load a avi video into workspace and do some processing work. I use the 'From Multimedia File' block in simulink to extract the audio of the avi file. The question is that if for different avi files, i have to manually set the 'file name' of the 'From Multimedia File' everytime before start the simulation. I can read the avi file in a .m file and get the path name and filename first. Is that possible to send these path name and filename automatically to the 'file name' in 'From Multimedia File' block when the avi file is loaded? thx a lo...
Is 'du -b file' equivalent to 'wc -c file'?
Hi all, It seems that both 'du -b file' and 'wc -c file' can give the correct bytes count on the file. Are they equivalent for all case on this type of job? Regards -- ..: Hongyi Zhao [ hongyi.zhao AT gmail.com ] Free as in Freedom :. On 2015-05-22, Hongyi Zhao <hongyi.zhao@gmail.com> wrote: > Hi all, > > It seems that both 'du -b file' and 'wc -c file' can give the correct > bytes count on the file. Are they equivalent for all case on this type of > job? > > Regards There's no -b switch for du on my system (Mac OS X 10.10.3), and it's not in POSIX. The -c switch for wc is however standard, so use that instead. Note that you will have to use -m with wc to always get the correct number of *characters* in a file. -- :: Andreas Kusalananda Kahari, Uppsala University, Sweden :: :: a n d r e a s . k a h a r i @ i c m . u u . s e :: On Fri, 22 May 2015 06:52:32 +0000, Kusalananda wrote: > There's no -b switch for du on my system (Mac OS X 10.10.3), I can find the following for my case manpage of du: -b, --bytes equivalent to '--apparent-size --block-size=1' --apparent-size print apparent sizes, rather than disk usage; although the apparent size is usually smaller, it may be larger due to holes in ('sparse') files, internal fragmentation, indirect blocks, and the like -B, --block-size=SIZE scale sizes by SIZE befo...
Fetch the newest file containing the string 'fgractg*.log' in the filename and contains the string 'ORA-' in it
Hello, I posted a message a month ago and I still have the same questions unresolved. I hope I am clear in my question. I am trying to develop a shell script that checks whether the newest file modified today that contains the string 'fgractg*.log' in the filename ALSO contains the string 'ORA-' in the file and if so, it gives the name of the file. I have this from someone else andd it also has syntax errors and does not work for me. fgractg_check=` ls -ltr fgractg*\.log | grep "`date +'%b %e'" | sed "s/.* \(fgractg*\.log\)$/grep -l 'fgractg...
A function with 'and' , 'not' , 'null' , 'car' and 'cdr'
What's this ? (defun enigma (x) (and (not (null x)) (or (null (car x)) (enigma (cdr x))))) "I suppose I should learn Lisp, but it seems so foreign." - Paul Graham, Nov 1983 On Wed, Oct 07 2015, CAI GENGYANG wrote: > What's this ? > > > (defun enigma (x) > (and (not (null x)) > (or (null (car x)) > (enigma (cdr x))))) Bad taste? It returns T if the list X contains nil as an element. It would be clearer to write (some #'null x). Helmut CAI GENGYANG ...
Issue with the 'script' command in users '.kshrc' and '.bashrc' files
I am attempting to monitor users actions by using the following 'script' command: # exec script -a /tmp/${LOG} In order to capture all types of login whether 'telnet', su, su - etc etc I have put it into the .profile, .dtprofile and the *rc shell files. This works fine for CSH and SH, however if I launch another session (dtterm &) or switch shell to either KSH or BASH, then it seems to spin round and attempt to infinately create fresh 'script' sessions until I quit out. Example below: Script started, file is /tmp/x Script started, file is /tmp/x Script started,...
Re: if str_mo not in ('','.') and str_da not in ('','.') and str_yy not in ('','.') Any shorter ?
OR you could use ARRAY data new; set old; array igor $ (*) str_mo str_da str_yr; do over igor; if igor ~in (' ','.') then do; end; run; Prasad Ravi Igor Kurbeko <ikurbeko@ATHEROGENIC To: SAS-L@LISTSERV.UGA.EDU S.COM> cc: Sent by: "SAS(r) Subject: if str_mo not in ('','.') and str_da not in ('','.') and str_yy ...
error: expected '=', ',', ';', 'asm' or '__attrib
Hi I'm trying to compile an ADC Driver & come acrosss the following error. I've no experience writing drivers before, and hence have no clue how to fix it. Hope someone out there has encountered the problem & suggesst a fix for the same. The Error is I get is : qadc.c: At top level: qadc.c:97: error: expected '=', ',', ';', 'asm' or '__attribute__' before 'qadc_read' make: *** [qadc.o] Error 1 [root@localhost qadc]# ########################################################################### ADC Driver Code ########################################################################### #define MODULE #define __KERNEL__ #include <linux/config.h> #include <linux/module.h> #include <linux/kernel.h> /* printk */ #include <linux/fs.h> / #include <linux/errno.h> /* error codes */ #include <linux/types.h> /* size_t */ #include <linux/proc_fs.h> /* proc file system */ #include <linux/fcntl.h> #include <asm/system.h> /* cli, flags */ #include <asm/uaccess.h> /* copy from/to user */ /*Registers to get qadc access*/ volatile unsigned short * qadcmcr = (unsigned short *)0x40190000; volatile unsigned short * qacr0 = (unsigned short *)0x4019000a; volatile unsigned short * qacr1 = (unsigned short *)0x4019000c; volatile unsigned short * qacr2 = (unsigned short *)0x4019000e; volatile unsigned short * qasr0 = (unsigned short *)0x40190010; volatile unsigned short * qasr1...
error: expected '=', ',', ';', 'asm' or '__attrib
Hi I'm trying to compile an ADC Driver & come acrosss the following error. I've no experience writing drivers before, and hence have no clue how to fix it. Hope someone out there has encountered the problem & suggesst a fix for the same. The Error is I get is : qadc.c: At top level: qadc.c:97: error: expected '=', ',', ';', 'asm' or '__attribute__' before 'qadc_read' make: *** [qadc.o] Error 1 [root@localhost qadc]# ########################################################################### ADC Driver Code ##...
Web resources about - Increase in 'log file sync' waits while 'log file parallel write' remains unchanged - comp.databases.oracle.serverResources last updated: 3/8/2016 5:32:08 PM