user269484
Reputation: 1143
Oracle database space
The sum of sm$ts_free.bytes and sm$ts_used.bytes is not equal to sm$ts_alloc.bytes.
What can be the reason behind it?
Upvotes: 3
Views: 238
Answers (1)
Vincent Malgrat
Reputation: 67722
There is a discussion about these views in the OTN forum. It seems the difference between sm$ts_free.bytes + sm$ts_used.bytes and sm$ts_alloc.bytes is a constant overhead. It is probably used to store tablespace header information.
Upvotes: 2
Related Questions
- Database Size in GB with use space and free space Oracle DB
- Oracle 11G usable space
- Find Size of a Database in Oracle
- List only Oracle Temp Table Space
- SYSTEM tablespace in Oracle database
- how do i increase database size from 11GB to above 20Gb
- What is maximum limit space per table in oracle 10g and 11g?
- Estimate the database size
- What is using Oracle database space? ("ORA-12953: ... exceeds the maximum allowed database size")
- Which database is the most space efficient