Home » RDBMS Server » Server Administration » finding database size & finding how many databases are running
finding database size & finding how many databases are running [message #279805] Sat, 10 November 2007 10:20 Go to next message
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.
Re: finding database size & finding how many databases are running [message #279806 is a reply to message #279805] Sat, 10 November 2007 10:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: finding database size & finding how many databases are running [message #280681 is a reply to message #279805] Wed, 14 November 2007 08:59 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
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
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:
  


Current Time: Fri Dec 09 05:59:40 CST 2016

Total time taken to generate the page: 0.24507 seconds