Problem with high HWM

Purpose :
Shows that HWM can create problem.

Time Needed : 5Min.

Preparation
create table t pctfree 90 pctused 10
as
select * from all_objects;
delete from t where object_id <> 55;
set autotrace on

1. Test Case 1 (This can happen with high HWM)
select object_name from t;
(6328 consistent gets == see the higher consistent gets. it took 07.07 sec to get answer)

2. Test Case 2 (Now with low HWM)

create table tmp as select * from t;
truncate table t;
insert into t select * from tmp;
drop table tmp;
set autotrace on
select object_name from t;
(3 consistent gets = see the lower consistent gets.it took 07.03 sec to get answer)

Backout Procedure
drop table t;
set autotrace off

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: