Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> session wait on "control file sequential read" event ,performance was very slowed

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

From: machao <machao2004_at_gmail.com>
Date: 7 Aug 2006 08:35:04 -0700
Message-ID: <1154964904.453847.152030@m73g2000cwd.googlegroups.com> 





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 - 10:35:04 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US