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

On 7 Aug 2006 08:35:04 -0700, "machao" <machao2004_at_gmail.com> 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.

I don't think the size of a table has anything to do with the event you mention.
If the database is waiting for a controlfile to be read then the disk on which the controlfile is located may perceive an I/O bottleneck. You need to investigate where the controlfile is located and possibly relocate it to a less heavily used disk.

--
Sybrand Bakker, Senior Oracle DBA