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: 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).
