Re: can clustering help INSERTS ?

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" <ORACLE-L_at_fatcity.com>
> 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: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: Jared Still
> > INET: jkstill_at_cybcon.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).
>

-- 
--
Mark J. Bobak
Oracle DBA
mark_at_bobak.net
"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: mark_at_bobak.net

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