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 -> Re: session wait on "control file sequential read" event ,performance was very slowed

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

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 07 Aug 2006 11:31:54 -0700
Message-ID: <1154975507.716799@bubbleator.drizzle.com>


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.

As Pete says ... much more information is required. Here is some additional information required to help you.

Partitioned by what?
Subpartitions?
Local or global indexes?
Preferably provide the DDL.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Aug 07 2006 - 13:31:54 CDT

Original text of this message

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