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

We need more exact information.

1. Trace the Seesion
2. Tkprof it
3. Post it.

alter session set timed_statistics=true; alter session set max_dump_file_size=unlimited; alter session set events '10046 trace name context forever, level 12';

and tkprof it.

Tkprof "Input File Name" "Output/Formatted File Name" sys=no explain=system/manager

...Pete

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.
Received on Mon Aug 07 2006 - 12:27:55 CDT