Re: sgastat miscellaneous

From: Winner Manurung <manruw_at_uninet.net.id>
Date: Fri, 27 Jul 2001 01:05:15 +0700
Message-ID: <Nt987.1187$96.7624@news>

Hi Stephan,
It's cumulative value. Just check the shared pool free space.

hth,
Winner

Stephan Bressler <agadir_at_web.de> wrote in message news:9jodkf$qpk$1_at_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 - 13:05:15 CDT