OraFAQ Forum: Server Administration » Size of the Oracle database 11g

Home » RDBMS Server » Server Administration » Size of the Oracle database 11g

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Size of the Oracle database 11g [message #452307]

Wed, 21 April 2010 04:38

gururajster
Messages: 26
Registered: October 2006
Location: bangalorre

Junior Member

Hi All,

I just want to know how can we find the size of the oracle database 11g.Any help will be highly appreciated.

-KR
Guru

Report message to a moderator

Re: Size of the Oracle database 11g [message #452308 is a reply to message #452307]

Wed, 21 April 2010 04:42

pokhraj_d
Messages: 117
Registered: December 2007

Senior Member

Run the below query:-
===============================

Prompt "Database Size"

select (select sum(bytes/1048576) from dba_data_files) "Data Mb",
(select NVL(sum(bytes/1048576),0) from dba_temp_files) "Temp Mb",
(select sum(bytes/1048576)*max(members) from v$log) "Redo Mb",
(select sum(bytes/1048576) from dba_data_files) +
(select NVL(sum(bytes/1048576),0) from dba_temp_files) +
(select sum(bytes/1048576)*max(members) from v$log) "Total Mb"
from dual;

Thanks-
P

Report message to a moderator

Re: Size of the Oracle database 11g [message #452311 is a reply to message #452308]

Wed, 21 April 2010 04:47

gururajster
Messages: 26
Registered: October 2006
Location: bangalorre

Junior Member

Hi pokhraj,

Many thanks for the quick reply and a solution.

-KR
Guru

Report message to a moderator

Previous Topic:	ORA:16000: database open for read-only access during Select on standby 11gr2 read only.
Next Topic:	Refreshing the Stale Statistics in Oracle Database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 12 09:40:17 CST 2025