|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 :22.214.171.124
I haved a application.
it inserted data to a very large table,there was 1000+ partition in
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 can i do?
think you very much.