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: Rahul <rahul_at_ratelindo.co.id>
Date: Sun, 27 Oct 2002 19:13:20 -0800
Message-ID: <F001.004F4E57.20021027191320@fatcity.com>


;-)
the only waits i see are "parallel query dequeue wait", and sometimes v$session_wait shows "write complete waits" .. but i'm sure these are not slowing down the process... (or are they ?) as most of the time v$session_wait does not return a row !! and i query this view once every second

Rahul

> ----------
> From: Jared Still[SMTP:jkstill_at_cybcon.com]
> Sent: Sunday, October 27, 2002 8:27 AM
> To: ORACLE-L_at_fatcity.com; Rahul
> Subject: Re: can clustering help INSERTS ?
>
>
> *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).
Received on Sun Oct 27 2002 - 21:13:20 CST

Original text of this message

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