RE: frequently used procs

Looking at v$sql can give that information. You can get the number of executions at different times and find out how many times they are called.

select executions from v$sql

where sql_text like '%procname%';

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Onkar N Tiwary Sent: Tuesday, December 20, 2005 9:22 AM To: oracle-l_at_freelists.org
Subject: frequently used procs

hi all,

I want to find out what are the stored procedures exists in the database which are used frequently. Any Suggestion.

DB : Oracle 9i rel 2(9.2.0.6.0)

OS: Solaris 5.9

--
Thanks & Regards,
T. Onkar Nath
OneAPPS Enterprise Technology Pvt. Ltd.

       to_onkar_at_yahoo.com
       onkarnath.tiwary_at_gmail.com

Bu mesaj ve onunla iletilen tum ekler gonderildigi kisi ya da kuruma ozel ve Bankalar \ Kanunu geregince, gizlilik yukumlulugu tasiyor olabilir. Bu mesaj, hicbir sekilde, \ herhangi bir amac icin cogaltilamaz, yayinlanamaz ve para karsiligi satilamaz; mesajin \ yetkili alicisi veya alicisina iletmekten sorumlu kisi degilseniz, mesaj icerigini ya da \ eklerini kopyalamayiniz, yayinlamayiniz, baska kisilere yonlendirmeyiniz ve mesaji \ gonderen kisiyi derhal uyararak bu mesaji siliniz. Bu mesajin iceriginde ya da eklerinde \ yer alan bilgilerin dogrulugu, butunlugu ve guncelligi Bankamiz tarafindan garanti \ edilmemektedir ve bilinen viruslere karsi kontrolleri yapilmis olarak yollanan mesajin \ sisteminizde yaratabilecegi zararlardan Bankamiz sorumlu tutulamaz.

This message and the files attached to it are under the privacy liability in accordance \ with the Banking Law and confidential to the use of the individual or entity to whom they \ are addressed. This message cannot be copied, disclosed or sold monetary consideration for \ any purpose. If you are not the intended recipient of this message, you should not copy, \ distribute, disclose or forward the information that exists in the content and in the \ attachments of this message; please notify the sender immediately and delete all copies of \ this message. Our Bank does not warrant the accuracy, integrity and currency of the \ information transmitted with this message. This message has been detected for all known \ computer viruses thence our Bank is not liable for the occurrence of any system corruption \ caused by this message Received on Tue Dec 20 2005 - 16:29:49 CST