Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: drop user user_name cascade - question

Re: drop user user_name cascade - question

From: Tom Miskiewicz <miskiewicz2_at_no.spam.yahoo.com>
Date: Sun, 13 Oct 2002 15:55:59 +0200
Message-ID: <wXeq9.10$CU4.2842@news.ecrc.de>


> Database configuration, which means

> - how much memory in the system

2GB

> - settings of db_block_buffers

db_block_buffers = 75941

> - shared_pool_size

shared_pool_size = 207370444

> - any other default init.ora setting that should always be changed
> (there are too many to mention them all)
where can I read about it then?

> - number of disk drives used.

2

> - 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] [] []

As long as I'm deleting e.g. indexes one by one it's going. Slow, but working.
As soon as I select about 40 I can wait forever. Nothing happens. Help please! Received on Sun Oct 13 2002 - 08:55:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US