Home » RDBMS Server » Server Administration » duplicate entries in dba_free_space (oracle19c)
duplicate entries in dba_free_space [message #686723] |
Fri, 02 December 2022 10:48  |
shrinika
Messages: 306 Registered: April 2008
|
Senior Member |
|
|
Team, I am seeing duplicate entries in dba_free_space view. Can some one please clarify why we get two
entries for the same tablespace?
SQL> select * from dba_free_space where tablespace_name='FRAUD_DAT';
TABLESPACE_NAME FILE_ID BLOCK_ID BYTES BLOCKS RELATIVE_FNO
------------------------------ ---------- ---------- ---------- ---------- ------------
FRAUD_DAT 9 2996935104 9.5606E+11 58353280 1024
FRAUD_DAT 9 3055288384 5.9927E+11 36576640 1024
SQL>
|
|
|
|
|
Goto Forum:
Current Time: Thu Apr 10 19:51:30 CDT 2025
|