Oracle   Home  

 

Oracle Database 9i, 10g, 11g

Oracle Data Warehouse & BI

Oracle Applications EBS 11i, R12

 Oracle Middleware

SQL & PL/SQL

UNIX/ Linux

   Home  >  Oracle Database Administration (DBA)  >  Scripts  >  Find the Oracle database size

 

Oracle 10g, 11g Database Administration (DBA): Scripts

Find the Oracle database size

 

 

SELECT SUM (a.log_space + b.data_space + c.tempspace) "Total_DB_Size (G)"
          FROM (SELECT ROUND (SUM (BYTES/1024/1024/1024), 2) data_space
                            FROM dba_data_files) b,
                      (SELECT ROUND (SUM (BYTES*members/1024/1024/1024), 2) log_space
                            FROM v$log) a,
                      (SELECT NVL(ROUND(SUM(BYTES/1024/1024/1024),2), 0) tempspace
                            FROM dba_temp_files) c;

 

 

 

 

Oracle Database 9i, 10g, 11g

Oracle Data Warehouse & BI Oracle Applications EBS 11i, R12  Oracle Middleware

SQL & PL/SQL

UNIX/ Linux

   Home  >  Oracle Database Administration (DBA)  >  Scripts  >  Find the Oracle database size

 

 

Different Romanian Links/ Linkuri romanesti diferite

  1. Invata limba engleza (Learn English language if you are Romanian)

  Doresti un proiect de arhitectura ieftin (pentru zonele Buzau, Bucuresti sau Prahova) ?

 

Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk. Copyright (c) 2009-2011 Paul Catalin Tomoiu. All rights reserved.