You need to check the SQL in the procedure. I have the same situation. I run Tim Gornman's temp_top_stmt2.sql script to identify the SQL within the procedure. Statspack also identifies the high resource consuming SQL. IXORA also provides scripts to identify them.
Shakir --- Big Planet <[EMAIL PROTECTED]> wrote: > Hi List , > While searching for poor sqls , I am getting a stored procedure name > in v$sqlarea with high value in disk_reads . What does it mean and > how can I reduce the disk read . Yeah ..one more thing does the case > of stored proc and name of bind varibales creats different entry in > sqlarea . > > TIA > Bp > > ===== Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __________________________________________________ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
