Re: Control file sequential read

No the 2 here means the control file# 2, not data file number 2 ..... Probably identifying or refreshing file information .

Anjo.

"Godlewski, Melissa" wrote:

>
>
> Listers,
>
> On development I truncated a fairly large partitioned table, inserted
> the data from production via a db_link and then built partitioned
> indexes on the table. I was watching the v$session_waits for the
> session and noticed several sets of control file sequential reads
> during the index builds. I checked what file 2 was against the
> dba_data_files and it was showing rollback tablespace. Is this due to
> delayed block cleanout?
>
> SID SEQ# EVENT
> --------- ---------
> ----------------------------------------------------------------
>
> 1TEXT
> P1 P1RAW
> ----------------------------------------------------------------
> --------- --------
>
> 2TEXT
> P2 P2RAW
> ----------------------------------------------------------------
> --------- --------
>
> 3TEXT
> P3 P3RAW WAIT_TIME
> ----------------------------------------------------------------
> --------- -------- ---------
> SECONDS_IN_WAIT STATE
> --------------- -------------------
> 12 10086 control file sequential read
>
> ile#
> 2 00000002
>
> lock#
> 1 00000001
>
> locks
> 1 00000001 -1
> 0 WAITED SHORT TIME
>
> FILE_NAME
>
> ---------------------------------------------------------------------------------------------------
>
> FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
> RELATIVE_FNO AUT MAXBYTES
> --------- ------------------------------ --------- --------- ---------
> ------------ --- ---------
> MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
> --------- ------------ ---------- -----------
> /u03/oradata/FDWD/rbs01.dbf
> 2 RBS 630194176 76928
> AVAILABLE 2 NO 0
> 0 0 630185984 76927

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anjo Kolk
  INET: anjo_at_oraperf.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).