| How the HWM move? [message #351335] |
Tue, 30 September 2008 06:33  |
yr0123
Messages: 5
Registered: September 2008
|
Junior Member |
|
|
I want to know how the HWM move,so i do a test
1.I create a tablespace xcgl(block size is 8k):
create tablespace xcgl
datafile '/dbf/oradata/orakf/xcgl1.dbf' size 1000M
extent management local uniform size 1m segment space management auto;
2.create table in it
create table test(a number(10));
analyze the table,the blocks in "user_tables" is 0.empty_blocks is 60.
3.insert records,from 1 to 5000,then analyze table test,in "user_tables",blocks is 60,empty_blocks is 68.
4.I insert from 1 to 5000 to the table test repeatly,the blocks in "user_tables" suddenly grows to 124 ,and empty_blocks is 4
5.continue to insert record, the size as flowing:
blocks empty_blocks
0 128
60 68
124 4
186 70
my question is how the HWM(blocks) move in ASSM?
Sorry very much,I am not good at english,i put the post error place,how can i do?
[Updated on: Tue, 30 September 2008 06:40] Report message to a moderator |
|
|
|
|
|
| Re: How the HWM move? [message #351451 is a reply to message #351336] |
Tue, 30 September 2008 21:48  |
yr0123
Messages: 5
Registered: September 2008
|
Junior Member |
|
|
thanks,Michel.
but i think than HWM is "blocks" in user_tables,
and my question is why the "blocks" in user_tables grows
from 0 to 60, 124, 186?
60-0=60
124-60=64
186-124=62
does the HWM move about 60 blocks each time?
and why the size is different?
thanks.
|
|
|
|
|
|
| Re: How the HWM move? [message #352472 is a reply to message #351335] |
Tue, 07 October 2008 22:04 |
yr0123
Messages: 5
Registered: September 2008
|
Junior Member |
|
|
hello! Michel.
Maybe the situation I describled is not clear,here is an exmple:
1.create a new table
create table test(a number(10));
now the blocks in "dba_tables" is 0
2.insert 5000(for example,from 1 to 5000) records into the table
now the blocks in "dba_tables" is 60
3.insert 5000 records again into the table,now the table has 10,000 records,
now the bocks in "dba_tables" is the same:60,
my question is why blocks doesnot increase here?
4. insert 5000 records again,now the table has 15,000 records,
the blocks is also 60
5. insert 5000 records again,now the table has 20,000 records
it suddenly grows to 124.
why blocks in dba_tables does not increase in step 3,4,and suddenly grows to 124 in step 5?
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
