Q
Problem solve Get help with specific problems with your technologies, process and projects.

Finding database or instance size

How can I find the database size or instance size? Also, can one instance can be shared by two or multiple servers?

How can I find the database size or instance size? Also, can one instance can be shared by two or multiple servers?
The total allocated size of the database is the sum of sizes of the database's datafiles. You can use the following query to see the size of these datafiles:
SELECT SUM(bytes) AS bytes FROM dba_data_files;
To see the sum of table and index sizes, use this query:
SELECT SUM(bytes) AS bytes FROM dba_segments;
The instance size is the sum of memory allocated by the instance. Sign on to SQL*Plus as SYSDBA and issue the following:
SHOW SGA
In most configurations, there is a one-to-one correspondence between instance, server and database. One instance can mount only one database and the instance runs on only one server. If you use Oracle's Real Application Clusters (RAC), you can have one instance running on a server but have mutliple instances (and thus multiple servers) accessing the same database.

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close