[Q]What is going on?

Have you ever had the following experience? (if not, please try it). Process A (do the following, step by step,in sqlplus): 1) create table T_1 as select * from Large_table;

• Large_table contains about 120000 rows,
• each rows is about 1000 bytes. 2) optional (commit) 3) truncate table T_1; 4) drop table T_1; 5) commit; All things should be finished within a normal (acceptable) response time.

Process B (do the following, step by step, in sqlplus): 1) create table T_1 as select * from Large_table;

• Large_table contains about 120000 rows,
• each rows is about 1000 bytes. 2) optional (commit) 3) set transaction use rollback segment Big_rollback_seg; 4) delete from T_1; 5) optional (commit or rollback) 6) truncate table T_1; 7) drop table T_1; 8) commit; At STEP 6), it will take a significant longer time to finish. In addition, other processes also take a hit with response time. For example, in Process C, drop table T_2 -- (where T_2 contains only one row) where you are doing truncate table T_1 in Process B.

Please let me know whether it is true in your environment. More importantly, concrete explanation is appreciated. Thanks. Received on Mon May 25 1998 - 18:26:05 CDT