HPE Community
Operating System - HP-UX
1753936 Members
9903 Online
108811 Solutions
New Discussion юеВ

Re: Oracle and memory

 
SOLVED
Go to solution
TwoProc
Honored Contributor

тАО11-08-2005 08:49 AM

тАО11-08-2005 08:49 AM

Re: Oracle and memory

Having actually used A. Clay's "whackball thought" as a strategy - I recommend it highly because it either a) works really well b/c developers take it to heart or b) drives the developers nuts.

Either way, it's a big win!

:-)
We are the people our parents warned us about --Jimmy Buffett
0 Kudos
Reply
Stafford Hyacinth
Advisor

тАО11-08-2005 11:03 AM

тАО11-08-2005 11:03 AM

Re: Oracle and memory

Thanks for the help all. I really appreciate all the feedback.
0 Kudos
Reply
Eric Antunes
Honored Contributor

тАО11-08-2005 08:25 PM

тАО11-08-2005 08:25 PM

Re: Oracle and memory

Hi Stafford,

The MINIMUM Shared Pool is calculated by this formula:

select sum(sharable_mem) from v$db_object_cache; -- Sharable Objects

+

select sum(sharable_mem) from v$sqlarea where executions > 5; -- Sharable SQL

+

select sum(250 * users_opening) from v$sqlarea; -- Cursors

+

20-30% Overhead

= ...


Best Regards,

Eric Antunes
Each and every day is a good day to learn.
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.