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: Fri, 25 Oct 2002 06:13:39 -0800
Message-ID: <F001.004F39A7.20021025061339@fatcity.com>


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

> 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).
Received on Fri Oct 25 2002 - 09:13:39 CDT

Original text of this message

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