DB file sequential read on C_OBJ#_INTCOL# ?

October 2014

Hi All ,

OLD DB : HPUX B.11.23 + Oracle 9.2.0.8

NEW DB : HPUX B.11.31 + Oracle 11.2.0.4

Both Database using the same storage (HP MSA4000).

Exp all schema from 9i and imp to 11g and get statistics as follows.

exec dbms_stats.gather_database_stats;

A view join many schema.tables .

Why Do I Wait So Long when i create table test_t1 as select view.... (11g)

Oracle 9i :

create table as select view ........... : 8 MINs

select view ........... : 7 MINs

Oracle 11g : 24 MINs

create table as select view ........... : 24 MINs ( 17232 rows)

select view ............: 9 MINs

## Wait event : create table as select view

SQL> select to_char(sysdate,'HH24:MI:SS') time,username,sid,sql_id,event,p1text,p1,p2text,p2,p3text,p3 from v\$session where sid=1130

Category Leaderboard