Can please you send me the SQL script that SQL*Plus actually runs for SHOW SGA command?

    Requires Free Membership to View

    Login

When you issue SHOW SGA in SQL*Plus, then it runs the following SQL statement for you:

SELECT name,value FROM v$sga;

However, the first line of output from SHOW SGA is the following SQL statement: 

SELECT 'Total System Global Area',SUM(value) FROM v$sga;

Performing a UNION ALL ties it all together:

SELECT 'Total System Global Area',SUM(value) FROM v$sga
UNION ALL
SELECT name,value FROM v$sga;

This was first published in March 2004

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

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