Re: package in sqlarea

From: Mohammed Shakir <mshakir08816_at_yahoo.com>
Date: Wed, 10 Apr 2002 18:28:21 -0800
Message-ID: <F001.00441437.20020410182821@fatcity.com>

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 <bigplanet34_at_HOTMAIL.COM> 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: mshakir08816_at_yahoo.com

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: ListGuru_at_fatcity.com (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).

Received on Wed Apr 10 2002 - 21:28:21 CDT