If you have a support contract with oracle then it might be a question for
support .
"Niko" <nick_wakefield_at_hotmail.com> wrote in message
news:9da94cd1.0307211306.1d440db3_at_posting.google.com...
> Hi
>
> I am getting ORA-03113 and ORA-07445 when I try to hit
> V$SHARED_POOL_RESERVED. The udump looks like this. I tracked it down
> to x$ksmspr.
>
> Anyone got any ideas.
>
> RDBMS Version: 9.2.0.3.0
> Operating System and Version: Redhat Linux Advanced Server 8
> Error Number (if applicable): ORA-03113
>
>
> *** 2003-07-21 13:59:08.926
> *** SESSION ID:(17.1403) 2003-07-21 13:59:08.921
> Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to
> object), addr: 0x8be, PC: [0x980edb4, kghrsc()+406]
> *** 2003-07-21 13:59:09.180
> ksedmp: internal or fatal error
> ORA-07445: exception encountered: core dump [kghrsc()+406] [SIGSEGV]
> [Address not mapped to object] [0x8BE] [] []
> Current SQL statement for this session:
> SELECT
REQUEST_FAILURES,LAST_FAILURE_SIZE,MAX_FREE_SIZE,FREE_SPACE,REQUEST_MISSES
> FROM V$SHARED_POOL_RESERVED
> ----- Call Stack Trace -----
> calling call entry argument values in hex
> location type point (? means dubious value)
> -------------------- -------- --------------------
> ----------------------------
> ksedmp()+269 call ksedst()+0 1 ? 0 ? 0 ? 1 ? 6165252C ?
> 66660078 ?
Received on Mon Jul 21 2003 - 21:21:33 CDT
