Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Huge cursor in shared pool
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
![]() |
![]() |