Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: shared pool problems
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
![]() |
![]() |