Database Administration (MOSC)

MOSC Banner

filesystem has 25 gb free but script maxbytes gave 333.763657 GB

edited May 5, 2010 8:00AM in Database Administration (MOSC) 4 commentsAnswered ✓
The filesystem ora1 has 25 gb free. I want to understatnd what does it means the following script.  does it means that if all datafiles use its maxsize the filesystem ora1 will become in zero bytes?
This is the script and the result:

SQL> select sum(bytes)/1024/1024/1024,sum(maxbytes)/1024/1024/1024 from dba_data_files where file_name like '%/psprdb01/prd/ora1%';

SUM(BYTES)/1024/1024/1024 SUM(MAXBYTES)/1024/1024/1024
------------------------- ----------------------------
               106.322266                   333.763657

SQL>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center