Memory consumption by Oracle

From: Upendra N <nupendra_at_hotmail.com>
Date: Thu, 18 Mar 2010 03:26:27 -0400
Message-ID: <BLU129-W221BDD42E957241ABAEED0D82B0_at_phx.gbl>

Here is my burning question...
How to find out the memory consumption by Oracle and how to scale it if one of the node in RAC fails (at a minimum - should have enough memory to handle the additional connections from the failing node). Here is the calculation:
total memory used = SGA size + PGA used + memory allocated for all the connections.

How is "Memory allocated for each connection" is calculated and which statistics should I look at in v$sesstat.

Please let me know if I am missing anything else. Thanks much
-Upendra
                                               

---

Hotmail has tools for the New Busy. Search, chat and e-mail from your inbox. http://www.windowslive.com/campaign/thenewbusy?ocid=PID27925::T:WLMTAGL:ON:WL:en-US:WM_HMP:032010_1
--

http://www.freelists.org/webpage/oracle-l Received on Thu Mar 18 2010 - 02:26:27 CDT