| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ?: ?Problem with resize
Thank you, Christian.
On a similar note, I noticed that if you shrink a rollback segment without explicitly specifying a new size, it shrinks to the optimal size minus one block size, if the optimal size is set to the rollback segment. Or it shrinks to minextents size minus one block size if the optimal size is not set.
Oracle documentation could have been clearer about this.
Yong Huang
yong321_at_yahoo.com
you wrote:
Yong,
V$datafile stores the size from block #1. In contrast OS does it from =
block
#0. Use the Oracle utility dbfsize to verify the amount of blocks. So =
then
compare it with the result from v$datafile.
Regards.
 |
 |