Q

How to find Oracle database instance size

How to find out the Oracle database instance size (BG + SGA)?

How to find out the Oracle database instance size (BG + SGA)?
Sign on to the database as SYSTEM with SQL*Plus. Then type "show sga" -- this will show you the total SGA size. The background processes do not require any additional memory as they all attach to the SGA.
This was first published in July 2007

Dig deeper on Oracle DBA jobs, training and certification

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close