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 -> sgastat miscellaneous

sgastat miscellaneous

From: Stephan Bressler <agadir_at_web.de>
Date: Thu, 26 Jul 2001 08:33:35 +0200
Message-ID: <9jodkf$qpk$1@news.mch.sbs.de>

Hi,

our shared_pool ist 100MB. After a livetime of 20 hours new connections fail due to "cannot allocate 4096 bytes in shared pool". Looking at v$sgastat, miscellaneous keeps more than 70 MB.

What's in this area? How can we get rid of if?

TIA
Stephan Received on Thu Jul 26 2001 - 01:33:35 CDT

Original text of this message

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