Re: drop user user_name cascade - question

"Tom Miskiewicz" <miskiewicz2_at_no.spam.yahoo.com> wrote in message news:wXeq9.10$CU4.2842_at_news.ecrc.de...
> > - contents of the alert_<sid>.log
>
> Fri Oct 11 11:43:11 2002
> Errors in file
> /export/home/oracle/admin/arstest1/bdump/arstest1_ora_4490.trc:
> ORA-07445: exception encountered: core dump [kcfcbkq()+156] [SIGSEGV]
> [Address not mapped to object]
> [2972260692] [] []

This is an internal (read unhandled) error and as such should be reported to Oracle support. Like Sybrand I'd suspect that you are running out of RAM, but this should be logged as a support call.

From the docs

ORA-07445 exception encountered: core dump [string] [string] [string] [string] [string] [string]

Cause: An operating system exception occurred which should result in the creation of a core file. This is an internal error.

Action: Contact Oracle Customer Support.

If you want to try reducing the memory allocation drop your block biffers parameter to (say) 25000 or 1/3rd of your current value.

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************