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: 177
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: 22718
Registered: January 2009
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: 58938
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: 606
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: 58938
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: 2190
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: Fri Aug 29 17:25:04 CDT 2014

Total time taken to generate the page: 0.28994 seconds