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