Home » RDBMS Server » Server Administration » Re: size of db
Re: size of db [message #369619] Wed, 08 November 2000 09:49
Adan Lopez
Messages: 2
Registered: November 2000
Junior Member
Hi:

Try the next query in sqlplus:

col bytes format 999,999,999,999
select sum(bytes) bytes
from dba_data_files
union
select sum(bytes) bytes
from v$log ;

Sum the rows returned. The rest of the database are the control files, usually very small:

select * from v$controlfile ;

I hope this help you.

Regards.

Adan.

Report message to a moderator

Previous Topic: RBS and REDO LOG
Next Topic: date check confusion
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 03 17:58:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.