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
--------- --------- ----------------------------------------------------------------
P1TEXT P1 P1RAW
---------------------------------------------------------------- --------- --------
P2TEXT P2 P2RAW
---------------------------------------------------------------- --------- --------
P3TEXT P3 P3RAW WAIT_TIME
---------------------------------------------------------------- --------- -------- ---------
SECONDS_IN_WAIT STATE
--------------- -------------------
12 10086 control file sequential read
file# 2 00000002
block# 1 00000001
blocks 1 00000001 -1
0 WAITED SHORT TIMEFILE_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
