Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Huge cursor in shared pool

Huge cursor in shared pool

From: Helen <hhjin_at_yahoo.com>
Date: 11 Oct 2001 12:49:46 -0700
Message-ID: <ebcac1e2.0110111149.3718a534@posting.google.com>


We are running 8.1.5.0.0 on Sun Solaris 2.6

SGA is about 700M. Shared pool is around 150M.

When checking what's in the shared pool, found huge cursors (several M). One of the cursors once grew up to 71M !! I was told cursor is about 250 bytes in size on average.

Any ideas? This does NOT happen with the same code on 8.1.6.3.0.0. We will eventually upgrade, but..

Helen

sqlplus >set serveroutput on size 2000
sqlplus >exec dbms_shared_pool.sizes(0)

Size (K)
4976 INSERT INTO CONTENTITEM_PRODUCTAFFSECTION ( CONTENTITEM_ID,PROD UCTAFFILIATESECTION_ID ) VALUES ( :b1,:b2 )
(9F14CEF8,450275836) (CURSOR)

4710 insert into PORTERTEMP values (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,: 11,:12,:13,:14,:15,:16,:17,:18,:19,:20,empty_clob(),:21,:22 ,:23,:24,:25,empty_clob(),:26,:27,:28,:29)
(9D4A6E1C,2421300843) (CURSOR)

2560 insert into contentitem (id, contentitemtype_id, contentitemsta te_id, source_id, productaffiliate_id, display_time, expire _time, create_time, slug, title) values (:1, :2, :3, :4, :5 , :6, :7, :8, :9, :10)
(A4135208,873585448) (CURSOR)

218        SYS.STANDARD                  (PACKAGE)
Received on Thu Oct 11 2001 - 14:49:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US