| Segments and Extents [message #127814] |
Wed, 13 July 2005 09:07  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
If I were to sum the bytes in dba_extents for a given tablespace, and then sum the bytes in dba_segments for the same tablespace, why would these two sums be different?
|
|
|
|
| Re: Segments and Extents [message #127821 is a reply to message #127814] |
Wed, 13 July 2005 09:24  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
Found it, although it confused the hell out of me for quite a while this morning. Must be a recyclebin thing (10gR1):
TABLESPACE_NAME ALLOCATED USED BLOCKS USED BLOCKS FREE
--------------- ---------- ---------- ---------- ---------- ---------- ----------
EXAMPLE 100 79.875 10224 79.875 10224 20.0625
FLOW_1 50 1.625 208 1.625 208 48.3125
HTMLDB_APP 100 78.625 10064 78.625 10064 21.3125
HTMLDB_FILES 50 1.0625 136 1.0625 136 48.875
SYSAUX 340 321.8125 41192 321.8125 41192 18.125
SYSTEM 575 566.8125 72552 566.8125 72552 8.125
UNDOTBS1 300 9.25 1184 9.25 1184 290.6875
USERS 505 47.0625 6024 3.5 448 501.3125
8 rows selected.
MYDBA@ORCL > purge tablespace users;
Tablespace purged.
MYDBA@ORCL > start space_query;
TABLESPACE_NAME ALLOCATED USED BLOCKS USED BLOCKS FREE
--------------- ---------- ---------- ---------- ---------- ---------- ----------
EXAMPLE 100 79.875 10224 79.875 10224 20.0625
FLOW_1 50 1.625 208 1.625 208 48.3125
HTMLDB_APP 100 78.625 10064 78.625 10064 21.3125
HTMLDB_FILES 50 1.0625 136 1.0625 136 48.875
SYSAUX 340 321.8125 41192 321.8125 41192 18.125
SYSTEM 575 566.8125 72552 566.8125 72552 8.125
UNDOTBS1 300 9.5 1216 9.5 1216 290.4375
USERS 505 3.5 448 3.5 448 501.3125
8 rows selected.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
