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
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: 26766
Registered: January 2009
Location: SoCal
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: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
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: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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: 3174
Registered: May 2013
Location: World Wide on the Web
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: Please tune this query.
Next Topic: Lost Index from the second execution time
Goto Forum:
  


Current Time: Thu Mar 28 12:39:12 CDT 2024