Re: Meaning of V$WAITSTAT statistics
Hi all Sorry for interrupting this thread ! I'm sorry to say that it is not possible to answer since time_statistics = false and there for the time column is zero. So we know that this db has waited on (data block 335274, segment header 52,undo header 322 and undo block 419) these different thing but we don't know for how long time and therefor we don't know if it is a problem ! Turn on time_statistics on the db and see what the wait time is then you might find that you have a problem or not if it's not broken don't fix it Raghu Kota wrote: > Hi Friends > > My v$waitstat shows like this..I think there is no time waited..Its > okay, Or any thing Iam missing here?? > > SQL> select * from v$waitstat; > > CLASS COUNT TIME > -- -- -- > data block 335274 0 > sort block 0 0 > save undo block 0 0 > segment header 52 0 > save undo header0 0 > free list 0 0 > system undo header 0 0 > system undo block 0 0 > undo header 322 0 > undo block419 0 > > Thanks > Raghu. > > > > > >> From: "Mohan, Ross" <[EMAIL PROTECTED]> >> Reply-To: [EMAIL PROTECTED] >> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >> Subject: RE: RE: Meaning of V$WAITSTAT statistics >> Date: Wed, 03 Oct 2001 07:05:20 -0800 >> >> > > _ > Get your FREE download of MSN Explorer at > http://explorer.msn.com/intl.asp > -- Regards Peter Gram Miracle A/S http://MiracleAS.dk Tel: +45 2527 7107 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Meaning of V$WAITSTAT statistics
LOL! Ross, you have a drink on me if we ever meet! > -Original Message- > From: Mohan, Ross [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 03, 2001 11:05 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: RE: Meaning of V$WAITSTAT statistics > > > I didn't mean to offend anyone and I apologize if i did so. > By the way, it's spelled "Mladen" and not "Maladen". > > -Original Message- > Sent: Tuesday, October 02, 2001 4:25 PM > To: Multiple recipients of list ORACLE-L > > > Was that a joke, Maladen? > > -Original Message- > Sent: Tuesday, October 02, 2001 3:20 PM > To: Multiple recipients of list ORACLE-L > > > I didn't mean to offend anyone and I apologize if I did so. > By the way, it's spelled "unpalatable" and not "unplatable". > > > -Original Message- > > From: Cyril Thankappan [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, October 02, 2001 1:25 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: RE: Meaning of V$WAITSTAT statistics > > > > > > > > > > Hello > > > > Can you please clarify the relation > > between 'save undo headers' and Billy Graham. > > > > If making a joke out of what is 'unplatable' > > or 'inconvenient' to believe is comforting you > > by all means go ahead. > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Cyril Thankappan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / > Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Gogala, Mladen > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mohan, Ross > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mohan, Ross > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Meaning of V$WAITSTAT statistics
I didn't mean to offend anyone and I apologize if i did so. By the way, it's spelled "Mladen" and not "Maladen". -Original Message- Sent: Tuesday, October 02, 2001 4:25 PM To: Multiple recipients of list ORACLE-L Was that a joke, Maladen? -Original Message- Sent: Tuesday, October 02, 2001 3:20 PM To: Multiple recipients of list ORACLE-L I didn't mean to offend anyone and I apologize if I did so. By the way, it's spelled "unpalatable" and not "unplatable". > -Original Message- > From: Cyril Thankappan [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 02, 2001 1:25 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: RE: Meaning of V$WAITSTAT statistics > > > > > Hello > > Can you please clarify the relation > between 'save undo headers' and Billy Graham. > > If making a joke out of what is 'unplatable' > or 'inconvenient' to believe is comforting you > by all means go ahead. > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Cyril Thankappan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Meaning of V$WAITSTAT statistics
Can't remember where this came from but the following events can be safely ignored. Sorry it's just a starter but my understanding of this isn't what it should be. Iain Nicoll client message SQL*Net message from client SQL*Net more data from client rdbms ipc message pipe get Null event pmon timer smon timer parallel query dequeue -Original Message- Sent: 02 October 2001 23:50 To: Multiple recipients of list ORACLE-L Yes, you are right, but my pupils... they WANT TO KNOW THE MEANING... >From: Greg Moore <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: Meaning of V$WAITSTAT statistics >Date: Tue, 02 Oct 2001 14:13:38 -0800 > > > The Oracle 8i Reference manual Appendix A > >While it describes the wait events, it doesn't tell you which ones you can >safely ignore when using waits for tuning. > >Even if you know which ones to focus on, the descriptions are pretty >inadequate. We are informed that a "db file sequential read" means the >session is waiting "while a sequential read from the database is being >performed." On the other hand, a "db file scattered read" is "similar to db >file sequential read, except that a session is reading multiple data >blocks." > >Worse, suppose one of these two waits is twice as significant in my >database >than the other. Does that mean I have a problem and should start using the >wait interface methodologies to track down the SQL that's causing the wait >event to be high? Or is it normal that in a well tuned database that the >one will be higher than the other by a factor of two? Or in fact is it >typical in a well tuned database that the one that appears to be the least >significant should actually be much lower, so I should focus on that? Or >is >there really no such thing as a typical profile for a well tuned database, >because various wait events might be high on your system and low on mine >simply because of the way they're used, so no one really has any idea what >to focus on at any given time? > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Greg Moore > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alejandra Pazos Freire INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nicoll, Iain (Calanais) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Meaning of V$WAITSTAT statistics
Nice one Cyril, Just what we need now, another religious argument. After the events of the other week I think you should lighten up, it was tongue in cheek I am sure. -Original Message- Sent: 02 October 2001 18:25 To: Multiple recipients of list ORACLE-L Hello Can you please clarify the relation between 'save undo headers' and Billy Graham. If making a joke out of what is 'unplatable' or 'inconvenient' to believe is comforting you by all means go ahead. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Meaning of V$WAITSTAT statistics
Where can I find this paper ? I have look for this statistic in the Ixora site, but I didn't find it. And this isn't an event, it is a statistic >From: "Gogala, Mladen" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Meaning of V$WAITSTAT statistics >Date: Tue, 02 Oct 2001 12:05:54 -0800 > >Well, the only real paper about that was written by Anjo Kolk in Jurassic >period >and it describes all wait events in V7. I am not aware of any updates for >V8i. >Second thing to do is to go to Steve Adams's Ixora site enter the event >name >in >the search engine an read the explanation. > > > -Original Message- > > From: Greg Moore [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, October 02, 2001 2:56 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: Meaning of V$WAITSTAT statistics > > > > > > > From the performance perspective, you can safely > > > ignore the "save undo" statistics. > > > > Anyone know where I can find a list of the v$sysstat, > > v$system_event and > > v$session_wait items I can safely ignore? > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Greg Moore > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Gogala, Mladen > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alejandra Pazos Freire INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Meaning of V$WAITSTAT statistics
Thank you very much !!! I don't know why some people have made a joke with this question... When we are tuning a database we must try to understand the statistics, and I didn't found this in the documentation... And when I explain to my pupils the wait statistics, they want to know the meaning of all them ... I'm sorry if I have disturbe the attention of someone... >From: Christopher Spence <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Meaning of V$WAITSTAT statistics >Date: Tue, 02 Oct 2001 08:50:23 -0800 > >Save undo is when a tablespace has undo information, but is currently >offline. > >"Do not criticize someone until you walked a mile in their shoes, that way >when you criticize them, you are a mile a way and have their shoes." > >Christopher R. Spence >Oracle DBA >Phone: (978) 322-5744 >Fax:(707) 885-2275 > >Fuelspot >73 Princeton Street >North, Chelmsford 01863 > > > >-Original Message- >Sent: Monday, October 01, 2001 4:30 PM >To: Multiple recipients of list ORACLE-L > >Hello ! > I need to know what is the meaning of the "save undo block" and "save >undo header" statistics in the V$WAITSTAT view. > >TIA. > Alejandra. > > > > >_ >Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Alejandra Pazos Freire > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Christopher Spence > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alejandra Pazos Freire INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Meaning of V$WAITSTAT statistics
In the Oracle 8i Reference manual Appendix C, there are only the statistics from the V$SYSSTAT, not those that are in the V$WAITSTAT view. And, I have read this manual... >From: John Kanagaraj <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Meaning of V$WAITSTAT statistics >Date: Tue, 02 Oct 2001 13:06:38 -0800 > >Mladen et al, > >The Oracle 8i Reference manual Appendix A describes the very same wait >events (seems to have been lifted straight-away from Anjo Kolk's paper, >modified for 8i and gaps filled in). Look at App C for Statistics >descriptions. > >This is a good time to annouce a new acronym - RRTFM (Re-Read The Fine >Manual)! > >John Kanagaraj >Oracle Applications DBA >DB Soft Inc >Work : (408) 970 7002 > >Listen to great, commercial-free christian music 24x7x365 at >http://www.klove.com > >** The opinions and facts contained in this message are entirely mine >and do not reflect those of my employer or customers ** > > > >-Original Message- > >and it describes all wait events in V7. I am not aware of any > >updates for > >V8i.<---!!! >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: John Kanagaraj > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alejandra Pazos Freire INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Meaning of V$WAITSTAT statistics
Yes, you are right, but my pupils... they WANT TO KNOW THE MEANING... >From: Greg Moore <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: Meaning of V$WAITSTAT statistics >Date: Tue, 02 Oct 2001 14:13:38 -0800 > > > The Oracle 8i Reference manual Appendix A > >While it describes the wait events, it doesn't tell you which ones you can >safely ignore when using waits for tuning. > >Even if you know which ones to focus on, the descriptions are pretty >inadequate. We are informed that a "db file sequential read" means the >session is waiting "while a sequential read from the database is being >performed." On the other hand, a "db file scattered read" is "similar to db >file sequential read, except that a session is reading multiple data >blocks." > >Worse, suppose one of these two waits is twice as significant in my >database >than the other. Does that mean I have a problem and should start using the >wait interface methodologies to track down the SQL that's causing the wait >event to be high? Or is it normal that in a well tuned database that the >one will be higher than the other by a factor of two? Or in fact is it >typical in a well tuned database that the one that appears to be the least >significant should actually be much lower, so I should focus on that? Or >is >there really no such thing as a typical profile for a well tuned database, >because various wait events might be high on your system and low on mine >simply because of the way they're used, so no one really has any idea what >to focus on at any given time? > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Greg Moore > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alejandra Pazos Freire INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Meaning of V$WAITSTAT statistics
> The Oracle 8i Reference manual Appendix A While it describes the wait events, it doesn't tell you which ones you can safely ignore when using waits for tuning. Even if you know which ones to focus on, the descriptions are pretty inadequate. We are informed that a "db file sequential read" means the session is waiting "while a sequential read from the database is being performed." On the other hand, a "db file scattered read" is "similar to db file sequential read, except that a session is reading multiple data blocks." Worse, suppose one of these two waits is twice as significant in my database than the other. Does that mean I have a problem and should start using the wait interface methodologies to track down the SQL that's causing the wait event to be high? Or is it normal that in a well tuned database that the one will be higher than the other by a factor of two? Or in fact is it typical in a well tuned database that the one that appears to be the least significant should actually be much lower, so I should focus on that? Or is there really no such thing as a typical profile for a well tuned database, because various wait events might be high on your system and low on mine simply because of the way they're used, so no one really has any idea what to focus on at any given time? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Meaning of V$WAITSTAT statistics
I'm sorry... I thought that I could find people who like helping other persons, in this e-mail list... I thought that there may be some who knows about Oracle. I was wrong... >From: "Mohan, Ross" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: RE: Meaning of V$WAITSTAT statistics >Date: Tue, 02 Oct 2001 12:25:19 -0800 > >Was that a joke, Maladen? > >-Original Message- >Sent: Tuesday, October 02, 2001 3:20 PM >To: Multiple recipients of list ORACLE-L > > >I didn't mean to offend anyone and I apologize if I did so. >By the way, it's spelled "unpalatable" and not "unplatable". > > > -Original Message- > > From: Cyril Thankappan [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, October 02, 2001 1:25 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: RE: Meaning of V$WAITSTAT statistics > > > > > > > > > > Hello > > > > Can you please clarify the relation > > between 'save undo headers' and Billy Graham. > > > > If making a joke out of what is 'unplatable' > > or 'inconvenient' to believe is comforting you > > by all means go ahead. > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Cyril Thankappan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Gogala, Mladen > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Mohan, Ross > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alejandra Pazos Freire INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Meaning of V$WAITSTAT statistics
I'm sorry... I thought that I could find people who like helping other persons, in this e-mail list... I thought that there may be some who knows about Oracle. I was wrong... >From: "Mohan, Ross" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: RE: Meaning of V$WAITSTAT statistics >Date: Tue, 02 Oct 2001 12:25:19 -0800 > >Was that a joke, Maladen? > >-Original Message- >Sent: Tuesday, October 02, 2001 3:20 PM >To: Multiple recipients of list ORACLE-L > > >I didn't mean to offend anyone and I apologize if I did so. >By the way, it's spelled "unpalatable" and not "unplatable". > > > -Original Message- > > From: Cyril Thankappan [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, October 02, 2001 1:25 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: RE: Meaning of V$WAITSTAT statistics > > > > > > > > > > Hello > > > > Can you please clarify the relation > > between 'save undo headers' and Billy Graham. > > > > If making a joke out of what is 'unplatable' > > or 'inconvenient' to believe is comforting you > > by all means go ahead. > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Cyril Thankappan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Gogala, Mladen > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Mohan, Ross > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alejandra Pazos Freire INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Meaning of V$WAITSTAT statistics
Am I allowed to invoke the 5th ammendment? > -Original Message- > From: Mohan, Ross [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 02, 2001 4:25 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: RE: Meaning of V$WAITSTAT statistics > > > Was that a joke, Maladen? > > -Original Message- > Sent: Tuesday, October 02, 2001 3:20 PM > To: Multiple recipients of list ORACLE-L > > > I didn't mean to offend anyone and I apologize if I did so. > By the way, it's spelled "unpalatable" and not "unplatable". > > > -Original Message- > > From: Cyril Thankappan [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, October 02, 2001 1:25 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: RE: Meaning of V$WAITSTAT statistics > > > > > > > > > > Hello > > > > Can you please clarify the relation > > between 'save undo headers' and Billy Graham. > > > > If making a joke out of what is 'unplatable' > > or 'inconvenient' to believe is comforting you > > by all means go ahead. > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Cyril Thankappan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / > Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Gogala, Mladen > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mohan, Ross > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Meaning of V$WAITSTAT statistics
Mladen et al, The Oracle 8i Reference manual Appendix A describes the very same wait events (seems to have been lifted straight-away from Anjo Kolk's paper, modified for 8i and gaps filled in). Look at App C for Statistics descriptions. This is a good time to annouce a new acronym - RRTFM (Re-Read The Fine Manual)! John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** >-Original Message- >and it describes all wait events in V7. I am not aware of any >updates for >V8i.<---!!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Meaning of V$WAITSTAT statistics
Was that a joke, Maladen? -Original Message- Sent: Tuesday, October 02, 2001 3:20 PM To: Multiple recipients of list ORACLE-L I didn't mean to offend anyone and I apologize if I did so. By the way, it's spelled "unpalatable" and not "unplatable". > -Original Message- > From: Cyril Thankappan [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 02, 2001 1:25 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: RE: Meaning of V$WAITSTAT statistics > > > > > Hello > > Can you please clarify the relation > between 'save undo headers' and Billy Graham. > > If making a joke out of what is 'unplatable' > or 'inconvenient' to believe is comforting you > by all means go ahead. > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Cyril Thankappan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Meaning of V$WAITSTAT statistics
Well, the only real paper about that was written by Anjo Kolk in Jurassic period and it describes all wait events in V7. I am not aware of any updates for V8i. Second thing to do is to go to Steve Adams's Ixora site enter the event name in the search engine an read the explanation. > -Original Message- > From: Greg Moore [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 02, 2001 2:56 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Meaning of V$WAITSTAT statistics > > > > From the performance perspective, you can safely > > ignore the "save undo" statistics. > > Anyone know where I can find a list of the v$sysstat, > v$system_event and > v$session_wait items I can safely ignore? > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Greg Moore > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Meaning of V$WAITSTAT statistics
I didn't mean to offend anyone and I apologize if I did so. By the way, it's spelled "unpalatable" and not "unplatable". > -Original Message- > From: Cyril Thankappan [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 02, 2001 1:25 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: RE: Meaning of V$WAITSTAT statistics > > > > > Hello > > Can you please clarify the relation > between 'save undo headers' and Billy Graham. > > If making a joke out of what is 'unplatable' > or 'inconvenient' to believe is comforting you > by all means go ahead. > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Cyril Thankappan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Meaning of V$WAITSTAT statistics
> From the performance perspective, you can safely > ignore the "save undo" statistics. Anyone know where I can find a list of the v$sysstat, v$system_event and v$session_wait items I can safely ignore? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: Meaning of V$WAITSTAT statistics
Hello Can you please clarify the relation between 'save undo headers' and Billy Graham. If making a joke out of what is 'unplatable' or 'inconvenient' to believe is comforting you by all means go ahead. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Meaning of V$WAITSTAT statistics
Save undo is when a tablespace has undo information, but is currently offline. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Monday, October 01, 2001 4:30 PM To: Multiple recipients of list ORACLE-L Hello ! I need to know what is the meaning of the "save undo block" and "save undo header" statistics in the V$WAITSTAT view. TIA. Alejandra. _ Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alejandra Pazos Freire INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Meaning of V$WAITSTAT statistics
Save undo headers are made for the Billy Graham's database only. Just kidding. The "save undo headers" refer to the deferred rollback segment, which are created if a tablespace goes offline with uncommitted transactions. Those deferred rollback segments are created in the tablespace "SYSTEM" and there is no way of changing that (allegedly, some magic happens if the default tablespace is changed for the user 'SYS', but I've never tested that. It might be a rumor). >From the performance perspective, you can safely ignore the "save undo" statistics. > -Original Message- > From: Alejandra Pazos Freire [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 01, 2001 11:10 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Meaning of V$WAITSTAT statistics > > > ok, I know the meaning of the "undo block" and "undo header" > statistics, but > I don't know how to understand the "save undo block" and > "save undo header" > statistics. > > > > >From: "Mohan, Ross" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: Meaning of V$WAITSTAT statistics > >Date: Mon, 01 Oct 2001 13:05:51 -0800 > > > >rollback=undo > > > >-Original Message- > >Sent: Monday, October 01, 2001 4:30 PM > >To: Multiple recipients of list ORACLE-L > > > > > >Hello ! > > I need to know what is the meaning of the "save undo > block" and "save > >undo header" statistics in the V$WAITSTAT view. > > > >TIA. > > Alejandra. > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Mohan, Ross > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California-- Public Internet access / > Mailing Lists > > > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >the message BODY, include a line containing: UNSUB ORACLE-L > >(or the name of mailing list you want to be removed from). You may > >also send the HELP command for other information (like subscribing). > > > _ > Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alejandra Pazos Freire INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Meaning of V$WAITSTAT statistics
right...okwell. save=write ?? that's what I have always ASSumed...? hth - Ross -Original Message- Sent: Monday, October 01, 2001 11:10 PM To: Multiple recipients of list ORACLE-L ok, I know the meaning of the "undo block" and "undo header" statistics, but I don't know how to understand the "save undo block" and "save undo header" statistics. >From: "Mohan, Ross" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Meaning of V$WAITSTAT statistics >Date: Mon, 01 Oct 2001 13:05:51 -0800 > >rollback=undo > >-Original Message- >Sent: Monday, October 01, 2001 4:30 PM >To: Multiple recipients of list ORACLE-L > > >Hello ! > I need to know what is the meaning of the "save undo block" and "save >undo header" statistics in the V$WAITSTAT view. > >TIA. > Alejandra. >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Mohan, Ross > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alejandra Pazos Freire INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Meaning of V$WAITSTAT statistics
ok, I know the meaning of the "undo block" and "undo header" statistics, but I don't know how to understand the "save undo block" and "save undo header" statistics. >From: "Mohan, Ross" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Meaning of V$WAITSTAT statistics >Date: Mon, 01 Oct 2001 13:05:51 -0800 > >rollback=undo > >-Original Message- >Sent: Monday, October 01, 2001 4:30 PM >To: Multiple recipients of list ORACLE-L > > >Hello ! > I need to know what is the meaning of the "save undo block" and "save >undo header" statistics in the V$WAITSTAT view. > >TIA. > Alejandra. >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Mohan, Ross > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alejandra Pazos Freire INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).