| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: can clustering help INSERTS ?
top waits from system_event, when i siad "no waits" .. i ment no waits while
querying session_wait !!
offcourse a DB WILL experience waits... but, are these waits slowing down my
inserts ??
these stats are after the insertion of 16 million rows, the table in question is the only table on that disk
EVENT TOTAL_WAITS TOTAL_TIMEOUTS SEC_WAITED AVERAGE_WAIT ----------------------------------- ----------- -------------- ---------- ------------ parallel query dequeue wait 314695 314824 629392.78 200.000883 db file parallel write 28199 356 3850.24 13.6538175 db file sequential read 650214 0 2681.93 .412468818 buffer busy waits 31427 16 955.09 3.03907468 latch free 1623885 42121 818.44 .050400121 log file parallel write 25338 0 737.44 2.91041124 db file scattered read 50131 0 690.79 1.37796972 log file sync 10085 3 144.781.43559742
> > 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:Tim_at_SageLogix.com]
> > > Reply To: ORACLE-L_at_fatcity.com
> > > 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" <ORACLE-L_at_fatcity.com>
> > > 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: rahul_at_ratelindo.co.id
> > > >
> > > > 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: ListGuru_at_fatcity.com (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: Tim_at_SageLogix.com
> > >
> > > 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: ListGuru_at_fatcity.com (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: Rahul
> > INET: rahul_at_ratelindo.co.id
> >
> > 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: ListGuru_at_fatcity.com (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: Tim_at_SageLogix.com
>
> 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: ListGuru_at_fatcity.com (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: Rahul INET: rahul_at_ratelindo.co.id 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: ListGuru_at_fatcity.com (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).Received on Sun Oct 27 2002 - 21:23:23 CST
 |
 |