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 Go to next message
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>
Re: duplicate entries in dba_free_space [message #686724 is a reply to message #686723] Fri, 02 December 2022 10:56 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
It isn't a duplicate: there are two areas of free space. Each starts at a different place in the file.
Re: duplicate entries in dba_free_space [message #686725 is a reply to message #686724] Fri, 02 December 2022 13:29 Go to previous message
shrinika
Messages: 306
Registered: April 2008
Senior Member
cool. good to know. thank you sir.
Previous Topic: Proxy PDB Connection Fails with Password Error
Next Topic: New Oracle Home patches do not match database registry patches after migration
Goto Forum:
  


Current Time: Thu Mar 28 15:41:43 CDT 2024