Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: can clustering help INSERTS ?

Re: can clustering help INSERTS ?

From: Tim Gorman <Tim_at_SageLogix.com>
Date: Sun, 27 Oct 2002 11:58:22 -0800
Message-ID: <F001.004F4D30.20021027115822@fatcity.com>


Of course the system will still have waits -- it's just that the query provided will show values of zero for all of them when TIMED_STATISTICS = FALSE. That's why Rahul said that there were "no waits at all". My bad...

Rahul,

Please enable the parameter TIMED_STATISTICS = TRUE, re-run the INSERT operations, re-run the query provided in the earlier email, and then post the results to the list.

You can enable the parameter either by setting the parameter in your "init.ora" file and restarting the database instance and then re-running your INSERT operations, or by simply running ALTER SYSTEM SET TIMED_STATISTICS = TRUE and the re-running your INSERT operations (without restarting the database instance). If you choose the latter route, please be sure to update your "init.ora" file accordingly for future database instance startups, as well.

Hope this helps...

-Tim

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

-- 
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).
Received on Sun Oct 27 2002 - 13:58:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US