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" <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
