good explanation august 02, 2004
reviewer: cyrille from france
thanks for all your explanation.
hwm below or above? august 26, 2004
reviewer: rd from nz hi tom,
at the beginning of the thread you said
"
truncate it. that puts all of the blocks below the hwm. now we have 31
unused blocks + 1 system block = 32 blocks total. none on the free list since
none of them have any data."
should that have been "that puts all of the blocks above the hwm"
cos truncate will always lower the hwm or am i wrong??
thanks,
regards,
rd.
| followup: |
correct, the hwm would not even "exist" really. |
free space august 30, 2004
reviewer: nazmul hoque from bangladesh dear tom,
i need your help, i am useing oracle 8.1.7, i have three table space in my data
base size are 38 mb, 204 mb & 51 mb, but my database useing space from my server
more than 3 gb.
and file size temp01.dbf is 1.19 gb and users01.dbf file is
1.17 gb.
my idea this is abnormal, please help me to free space from my server.
thanks/hoque
| followup: |
do you have a dba you can work with?
you control the size of temp, that is entirely up to you. if you don't like
temp being so large, drop it and recreate it.
search this site for maxshrink, it'll tell you if you can shrink your
users01.dbf file.
it is normal for a database to consume space. you have indexes, you have free
space in there. 3gig is tiny. |
