Ask the Expert

How to find Oracle database instance size

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

    Requires Free Membership to View

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.