Monthly Archives: June 2011

Troubleshooting series: time wasted on app side for connections to database

The requirement is to finish transactions in 3 seconds. But during nightly batch load the requirement is violated. Database ASH, AWR, redo Log Miner, v$event_histogram snapshots, even app logs show transactions are completed in 3 seconds. Where is the time … Continue reading

Posted in Uncategorized | Leave a comment

Bug series: 11g instance crash. Resource Manager switched off

Database version: 11.2.0.2 Instance would crash immediately after instance bounce with ORA-7445[ksldclt_cln] Metalink note: Bug 9903826 – ORA-7445 [kcbsacc] and PMON crashing with ORA-7445 [kcbsslc] Causing Instance to Terminate [ID 9903826.8] Solution _resource_manager_always_off = TRUE worked. One more optional component … Continue reading

Posted in Uncategorized | Leave a comment

Bug series: 11g new features, ORA-24247, ACL, external network packages, NULLs

Oracle 11G has a new security: DBA has to configure ACL’s (package DBMS_NETWORK_ACL_ADMIN ) else Oracle throws “ORA-24247: network access denied by access control list (ACL)” error if your application depends on “external network services” (Oracle’s talk) packages (like UTL_TCP/HTTP, … Continue reading

Posted in Uncategorized | Leave a comment

Bug series: intro. statistics_level ALL, db_cache_advice and crash

This is the first post on daily bugs encountered by me. Got to keep track of them. I believe I’ve ran into this bug years before and now it happened again. And the bug is: Databases affected: at least 10.2.0.4, … Continue reading

Posted in Uncategorized | Leave a comment