Home » RDBMS Server » Backup & Recovery » DATABASE
DATABASE [message #242257] Fri, 01 June 2007 06:21 Go to next message
Messages: 1
Registered: June 2007
Junior Member
how to determine the size of ur database
Re: DATABASE [message #242261 is a reply to message #242257] Fri, 01 June 2007 06:55 Go to previous messageGo to next message
Messages: 49
Registered: June 2006
Location: Romania
try this
SQL> select sum(bytes)/1024/1024 as Mb from dba_data_files;


Re: DATABASE [message #242274 is a reply to message #242257] Fri, 01 June 2007 08:05 Go to previous message
Michel Cadot
Messages: 65085
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> Col type_ heading "File type"
SQL> Col kb format 99G999G999G990 heading "Size (Kb)"
SQL> Break on report
SQL> Compute sum label "Total" of kb on report
SQL> Prompt

SQL> Select 'Datafiles' type_, round(sum(bytes/1024)) kb from dba_data_files
  2  union all
  3  Select 'Tempfiles' type_, round(sum(bytes/1024)) kb from dba_temp_files
  4  union all
  5  Select 'Redologs' type_, round(sum(bytes*members)/1024) kb from v$log
  6  /
File type       Size (Kb)
--------- ---------------
Datafiles       1,986,560
Tempfiles         276,480
Redologs           81,920
Total           2,344,960

Previous Topic: Recover redo log files with rman
Next Topic: User-managed backups of a 10g DB using ASM
Goto Forum:

Current Time: Tue Jul 25 01:55:00 CDT 2017

Total time taken to generate the page: 0.08483 seconds