RE: can clustering help INSERTS ?

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