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

Giganews Newsgroups
Subject: session wait on "control file sequential read" event ,performance was very slowed
Posted by:  machao (machao20…@gmail.com)
Date: 7 Aug 2006

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.

Replies