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?
views:
51answers:
1
+2
A:
Hi,
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.
Vincent Malgrat
2010-02-24 08:51:39
Its means for all databases, this gap will exist but in my case another database is not showing this difference (no diff betwwenn sum of sm$ts_free.bytes + sm$ts_used.bytes and sm$ts_alloc.bytes). Why it showing for one and not for another?
2010-02-24 10:56:00
@user269484: well, these views are not documented in the 10g version, they might be deprecated. Since they are not documented, the behaviour may vary between releases and between platforms.
Vincent Malgrat
2010-02-24 11:34:35