RE: can clustering help INSERTS ?

Is timed_statistics set to true?

Regards
Naveen

-----Original Message-----
Sent: Saturday, October 26, 2002 8:48 PM To: Multiple recipients of list ORACLE-L

Can you display to the list the output from one of the queries, just for fun?

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Saturday, October 26, 2002 1:33 AM

> 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: Naveen Nahata
  INET: naveen_nahata_at_mindtree.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).