DB hangs after enabling db_block_lru_extended_statistics 
Author Message
 DB hangs after enabling db_block_lru_extended_statistics



Quote:

> Last friday I tried to use db_block_lru_extended_statistics for the first
snip
> After about an hour the database hung. Oracle was using about 50% cpu
> steadily. I bounced the database and in a few hours it had happened again.
> I could log in with svrmgrl but not with sqlplus so this leads me to believe
> it was a lock or latch issue. I was unable to query anything to see what the

snip

This was on a production 7.3.4 database ? don't do that. I used to do the same
on earlier versions. Oracle support does not recommend to use this on
production databases any more. It's not clear what else you can use to make
these estimations...
--
Ronald  -  Unix SA               http://www.***.com/ ~ronr/professional.html
        -  Oracle DBA             http://www.***.com/  
        -  Middleware programmer/



Sun, 12 Aug 2001 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. DB_BLOCK_LRU_EXTENDED_STATISTICS

2. no more db_block_lru_extended_statistics!?

3. db_block_lru_extended_statistics

4. CS/DB CURRICULUMS

5. DB-links hung in DB-jobs

6. Enable comp.lang.pascal.delphi.databases by reading this message


 
Powered by phpBB® Forum Software