Re: What is ORA-6508?

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Fri, 29 Oct 1999 11:56:08 -0700
Message-ID: <3819EDC8.1B4A33CD@vnl.nl>

Iain Shanks wrote:

> Can anyone explain what the causes (and remedies) for an ORA-6508 error?
>
> We are trying to run some PL/SQL stored procedures, and are sometimes
> getting a 6508 error (PL/SQL could not find program unit being called),
> usually when other (fairly resource intensive) processes are running
> against the database. The error seems to clear itself after usage of
> the system returns to normal, so we don't think there's anything
> basically wrong with the code.
>
> So, does anyone know what's going wrong and what (if anything) we can do
> to sort it?
>
> Thanks for all your help
>
> Iain
>
> "All opinions expressed are solely those of the author and not of
> Logica"

Non enough (contigious) memory available could be the cause of that, especially if it runs OK when midly loaded; that rules out ownership problems, etc.
IFAIK, oracle 8 resolves this better, and will reorg memory if space is found, but not contigious, V7 it had to be contigious. Increase shared pool, or flush it.

--
Met vriendelijke groet/kind regards,

Frank van Bortel
Technical consultant Oracle

Work:                                Home:
----------------------------------   ----------------------------
Inter Access V&L                     Hunzestraat 4
Palatijn 3, 7521 PN Enschede         7555 WB Hengelo
PoBox 545, 7500 AM Enschede          (31)074-2425046

053-4341500 Received on Fri Oct 29 1999 - 13:56:08 CDT