OraFAQ Forum: Server Administration » finding database size & finding how many databases are running

Home » RDBMS Server » Server Administration » finding database size & finding how many databases are running

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

finding database size & finding how many databases are running [message #279805]

Sat, 10 November 2007 10:20

idris_26
Messages: 5
Registered: November 2007
Location: Hyderabad

Junior Member

Hi,

I am new in this forum and this is my first post in the forum. I have 2 questions regarding oracle database 10g administration. they are as follows

1. How to find the size of the database.
2. How to find how many databases are running simultaneously.

Report message to a moderator

Re: finding database size & finding how many databases are running [message #279806 is a reply to message #279805]

Sat, 10 November 2007 10:27

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1. dba_data_files, dba_temp_files, v$log.
All dictionary views are described in documentation, for instance: http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/toc.htm

2. It depends on your OS

Read OraFAQ Forum Guide.
Always post your Oracle version (4 decimals).

Regards
Michel

Report message to a moderator

Re: finding database size & finding how many databases are running [message #280681 is a reply to message #279805]

Wed, 14 November 2007 08:59

monto
Messages: 60
Registered: November 2007
Location: DALLAS

Member

1)sum(datafiles)+sum(tempfiles)=DBSIZE
2)ps -ef|grep pmon,check tnsnames.ora, cat /etc/oratab.

[Updated on: Wed, 14 November 2007 09:00]

Report message to a moderator

Re: finding database size & finding how many databases are running [message #280682 is a reply to message #280681]

Wed, 14 November 2007 09:05

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

sum(datafiles)+sum(tempfiles)=DBSIZE

You missed log files, control files, spfile...

Quote:

ps -ef|grep pmon,check tnsnames.ora, cat /etc/oratab.

Will surely not work in Windows.
In unix, neither tnsnames.ora nor /etc/oratab will give running databases.

Regards
Michel

Report message to a moderator

Previous Topic:	Oracle 10g did not start after joining a windows domain
Next Topic:	Migrating data from Oracle 10g R2 64-bit to Oracle 10g R2 32-bit

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 24 22:00:50 CST 2025