Re: shared pool problems

From: <giardine_at_my-deja.com>
Date: 2000/04/16
Message-ID: <8dcoo3$4ip$1@nnrp1.deja.com>#1/1

In article <8d7fet$jo7$1_at_nnrp1.deja.com>, Mark D Powell <markp7832_at_my-deja.com> wrote:
> What is your version of Oracle?
> What is your shared pool size? How much did you reserve?
> How much free memory is there in the pool? And how is it being used?
>

Thank you for the querys.
I have Oracle 8.0.5.
Total Pool Free Bytes Free
---------- ---------- ----------
9000000 4776028 53.1

Reserved is 5%, the default.

The interesting results are those from the last query.

NAMESPACE                       TYPE             memory
--------------------    ------------         ----------
BODY                         PACKAGE BODY      34864
CLUSTER                    CLUSTER               6075
TABLE/PROCEDURE       NOT LOADED          0
TABLE/PROCEDURE       PACKAGE               203901
TABLE/PROCEDURE       SEQUENCE             6648
TABLE/PROCEDURE       SYNONYM             60144
TABLE/PROCEDURE       TABLE                  173060
TABLE/PROCEDURE       VIEW                    5033
                                INVALID TYPE        2041327
                                NOT LOADED            0

Is all this stuff in the "free bytes" ?
What is the INVALID TYPE that is taking so much space?

Thanks again,
Belinda

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Apr 16 2000 - 00:00:00 CDT