Re: What is the real SGA size?

From: Karl Arao <karlarao_at_gmail.com>
Date: Wed, 25 Apr 2012 14:46:16 -0500
Message-ID: <CACNsJndwqRa7PrP0gL60DmHhZe0zefJkNRnyw4WZSqdm2Jyvaw_at_mail.gmail.com>

resending due to overquoting -->

the output of "show sga" is being dumped to dba_hist_sga which is what is shown as start and end values on the AWR report then the dba_hist_pgastat "total PGA allocated" shows you the PGA section on the AWR report

so the

sum(value) of dba_hist_sga + dba_hist_pgastat "total PGA allocated" = total Oracle memory consumption per snap_id

this is very useful for memory capacity planning purposes..

--

Karl Arao
karlarao.wordpress.com
karlarao.tiddlyspot.com

--

http://www.freelists.org/webpage/oracle-l Received on Wed Apr 25 2012 - 14:46:16 CDT

This message: [ Message body ]
Next message: Ls Cheng: "Re: consistent reads and unique key updates"
Previous message: Ls Cheng: "Re: consistent reads and unique key updates"
In reply to: Orlando L: "What is the real SGA size?"
Next in thread: David Roberts: "Re: What is the real SGA size?"
Reply: David Roberts: "Re: What is the real SGA size?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message