All geek questions in one place

Oracle Database Space

Sum sm$ts_free.bytesand sm$ts_used.bytesnot equal sm$ts_alloc.bytes.

What could be the reason for this?

+3
source share
1 answer

The OTN forum has a discussion of these views . It seems that the difference between sm$ts_free.bytes + sm$ts_used.bytesand sm$ts_alloc.bytesis a constant invoice. It is probably used to store table space header information.

+2
source

Source: https://habr.com/ru/post/1734202/

More articles:


All Articles