Examine the output of the following query:
SQL> SELECT tablespace_name, tablespace_size, allocated_space, free_space
2 FROM DBA_TEMP_FREE_SPACE;
TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
—————————— ————— ————— ———-
TEMP_L 157286400 144048128 157220864
TEMP 105906176 105906176 0
After some time you executed the same command and observed a different output, as shown below:
SQL> SELECT tablespace_name, tablespace_size, allocated_space, free_space
2 FROM DBA_TEMP_FREE_SPACE;
TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
—————————— ————— ————— ———-
TEMP_L 131072 65536 65536
TEMP 105906176 105906176 0
Why has the output changed?
A.
because checkpoint occurred
B.
because the TEMP_L tablespace was shrunk
C.
because the database instance was restarted
D.
because no sort operations are running currently