Re: session wait on "control file sequential read" event ,performance was very slowed

machao wrote:
> OS version :hpux 11i
> RDBMS Version :9.2.0.6
>
> I haved a application.
> it inserted data to a very large table,there was 1000+ partition in
> this table.
>
> the speed was very slowed.
>
> I use "select sid,event from v$session_wait",
> It was control file sequential read event.
>
> i run the application on another db,there was a same table ,but the
> table is smaller, it only has 100+ partition.
> the speed was very fast.
>
> what happend?
> what can i do?
> think you very much.

As Pete says ... much more information is required. Here is some additional information required to help you.

Partitioned by what?
Subpartitions?
Local or global indexes?
Preferably provide the DDL.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org