Home » RDBMS Server » Performance Tuning » How to determine memory usage for a function (Toad for Oracle 11g on Windows 7)
How to determine memory usage for a function [message #591091] Wed, 24 July 2013 13:30 Go to next message
jxh461
Messages: 185
Registered: March 2005
Karma: 0
Senior Member
Hi All,

Can someone share a query that would help me determine if a function is worth pinning in memory ?

I want to come up with a percentage, implying that if the function is already im memory 80%+ of the time then it is not worth it.

Thanks in advance.
Re: How to determine memory usage for a function [message #591092 is a reply to message #591091] Wed, 24 July 2013 13:35 Go to previous messageGo to next message
BlackSwan
Messages: 25578
Registered: January 2009
Location: SoCal
Karma: 0
Senior Member
It appears that you suffer from Compulsive Tuning Disorder.
How much faster will the application be when this function is in memory 100% of the time?
Please post reproducible test case that shows you can even measure any difference?

You have a solution in search of a problem.
Re: How to determine memory usage for a function [message #591093 is a reply to message #591091] Wed, 24 July 2013 13:38 Go to previous messageGo to next message
Michel Cadot
Messages: 65153
Registered: March 2007
Location: Nanterre, France, http://...
Karma: 0
Senior Member
Account Moderator
NO function, package or procedure needs to be pinned.

Regards
Michel
Re: How to determine memory usage for a function [message #591113 is a reply to message #591093] Wed, 24 July 2013 21:39 Go to previous messageGo to next message
trantuananh24hg
Messages: 696
Registered: January 2007
Location: Ha Noi, Viet Nam
Karma: 0
Senior Member
According to Michael, no function, package or procedure need to be pinned in memory.

But! You will see the dedicated function, package or procedure hold the more memory that caused "Concurrency" wait event by OEM or any monitoring tools, will you?
Re: How to determine memory usage for a function [message #591129 is a reply to message #591113] Thu, 25 July 2013 00:13 Go to previous messageGo to next message
Michel Cadot
Messages: 65153
Registered: March 2007
Location: Nanterre, France, http://...
Karma: 0
Senior Member
Account Moderator
Explain what you mean.
Post evidences.

Regards
Michel
Re: How to determine memory usage for a function [message #591654 is a reply to message #591113] Tue, 30 July 2013 08:57 Go to previous message
Lalit Kumar B
Messages: 3123
Registered: May 2013
Location: World Wide on the Web
Karma: 0
Senior Member
trantuananh24hg wrote on Thu, 25 July 2013 08:09
According to Michael, no function, package or procedure need to be pinned in memory.


Yes Michel is absolutely correct. Pinning of procedures, packages etc. was used prior to 7.x release. I do not wan't to write anything more on this thread, just have a look at Tom Kyte's answer on pinning not recommended in 8.x and up
Previous Topic: TDE Related Question
Next Topic: Need Help In Performance Tuning
Goto Forum:
  


Current Time: Tue Aug 22 11:59:43 CDT 2017

Total time taken to generate the page: 0.15843 seconds