Re: application dump core after running statement "alter system flush shared_pool"

On 31 Jan 2007 23:37:41 -0800, "linux_bp" <rishabh.garg_at_gmail.com> wrote:

>After upgrading oracle server to 9.2.0.8.0 from 9.2.0.4.0 our
>application running on other machine is dumping core because of SEGV
>signal after running the following statement on DB machine:
>SQL> alter system flush shared_pool;
>
>As client stack got corrupted after running the above statement on DB
>machine ,so we could not specify the exact location of core in the
>stack from the core file.

1. Ask yourself a question.. Why do I flush shared pool?
2. If you find a meaningful answer (which most likely you won't), open a ticket with Oracle Support ....... We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc) remove NSPAM to email