Of course the system will still have waits -- it's just that the query provided will show values of zero for all of them when TIMED_STATISTICS = FALSE. That's why Rahul said that there were "no waits at all". My bad...
Rahul, Please enable the parameter TIMED_STATISTICS = TRUE, re-run the INSERT operations, re-run the query provided in the earlier email, and then post the results to the list. You can enable the parameter either by setting the parameter in your "init.ora" file and restarting the database instance and then re-running your INSERT operations, or by simply running ALTER SYSTEM SET TIMED_STATISTICS = TRUE and the re-running your INSERT operations (without restarting the database instance). If you choose the latter route, please be sure to update your "init.ora" file accordingly for future database instance startups, as well. Hope this helps... -Tim ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, October 27, 2002 12:18 PM > But even with TIMED_STATISTICS=FALSE, the system will still have waits. > Just because the duration of said waits is not accurately recorded > doesn't mean they do not exist. And if one looks at the V$ wait > interface, the waits will be logged there. > > -Mark > On Sun, 2002-10-27 at 09:48, Tim Gorman wrote: > > Someone else cracked it -- he doesn't have TIMED_STATISTICS = TRUE... > > > > ----- Original Message ----- > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Saturday, October 26, 2002 9:53 PM > > > > > > > > > > *no* waits? > > > > > > How is this possible? > > > > > > Is intantaneous computing now a reality? > > > > > > Sorry for the sarcasm. Wait, no, not really. ;) > > > > > > Seriously, all databases wait, all operations take > > > time. The question on everyone's lips is > > > 'How long are *yours* taking?' > > > > > > Jared > > > > > > On Saturday 26 October 2002 00:33, Rahul wrote: > > > > the DB is *not* experiencing any waits... i'm trying to bring down the > > run > > > > time of the > > > > insertion process, currently it takes around 9 hrs... the management > > wants > > > > to bring it > > > > down to 5-6 hrs...again.. i OD NOT see any wait events while the process > > is > > > > running.. > > > > > > > > there are no indexes on the tables > > > > > > > > > ---------- > > > > > From: Tim Gorman[SMTP:[EMAIL PROTECTED]] > > > > > Reply To: [EMAIL PROTECTED] > > > > > Sent: Friday, October 25, 2002 9:13 PM > > > > > To: Multiple recipients of list ORACLE-L > > > > > Subject: Re: can clustering help INSERTS ? > > > > > > > > > > Rahul, > > > > > > > > > > It does no good to speculate; let's work with facts... > > > > > > > > > > What wait-events are occurring in the sessions running the INSERTs? > > If > > > > > you > > > > > can locate the sessions in the V$SESSION view, then use the value in > > the > > > > > column SID to locate associated rows in the V$SESSION_EVENT view, > > sorting > > > > > by > > > > > the cumulative time spent on each wait-event: > > > > > > > > > > select event, time_waited, average_time, max_time > > > > > from v$session_event > > > > > where sid = &&SID > > > > > union > > > > > select n.name, s.value, 0, 0 > > > > > from v$sesstat s, v$statname n > > > > > where s.sid = &&SID > > > > > and n.name in ('CPU used by this session','parse time > > > > > cpu','recursive > > > > > cpu usage') > > > > > and s.statistic# = n.statistic# > > > > > order by 2 desc > > > > > > > > > > As you can see, in addition to wait-event information, this query will > > > > > also > > > > > mix in CPU statistics from the V$SESSTAT view, to give a better > > picture > > > > > of where time is being spent by these sessions... > > > > > > > > > > Can you post the results of these queries back to the list? > > > > > > > > > > Thanks! > > > > > > > > > > -Tim > > > > > > > > > > ----- Original Message ----- > > > > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > > > > Sent: Friday, October 25, 2002 6:18 AM > > > > > > > > > > > List, > > > > > > i have two heavily inserted tables, the structures are same. > > > > > > currently these tables reside on separate disks, can i increase the > > > > > > performance > > > > > > of inserts if i create these tables in a cluster ? as a cluster > > would > > > > > > > > > > force > > > > > > > > > > > the rows of both the tables > > > > > > to be physically close on the disk ! > > > > > > > > > > > > regards > > > > > > -rahul > > > > > > > > > > > > Ora 7.3 on AIX > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > > > > -- > > > > > > Author: Rahul > > > > > > INET: [EMAIL PROTECTED] > > > > > > > > > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > > > > > San Diego, California -- Mailing list and web hosting > > services > > > > > > > > --------------------------------------------------------------------- > > > > > > 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: Tim Gorman > > > > > INET: [EMAIL PROTECTED] > > > > > > > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > > > > San Diego, California -- Mailing list and web hosting services > > > > > --------------------------------------------------------------------- > > > > > 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: Jared Still > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > > San Diego, California -- Mailing list and web hosting services > > > --------------------------------------------------------------------- > > > 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). > > > -- > -- > Mark J. Bobak > Oracle DBA > [EMAIL PROTECTED] > "It is not enough to have a good mind. The main thing is to use it > well." > -- Rene Descartes > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mark J. Bobak > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).