Pages

▼
January 20, 2017

Solving a critical performance crisis for a national project caused by oracle connection slowness

›
An living national healthcare IT system, one core gateway system is very slow. The gateway system is used to distribute patients' admi...
April 8, 2016

orphan entries in col$ (due to creating online index failure) make gather stats job fail with ORA-01847

›
The gather stats job always fail on one of our core table with below error: EXEC dbms_stats.gather_table_stats(ownname=> 'SYSADM...
1 comment:
June 10, 2014

long parsing time issue: bundles of SQLs cost 10+ seconds to do a hard parse

›
One database, after migrating to 11.2.0.3, customer started to complain the performance was much slower than before. After checking, we saw...
7 comments:
May 28, 2014

database memory exhausted caused by vmware ballooning(vmmemctl.sys)

›
One DB frequently crashed. Here was the entry in alert.log: Fri Oct 11 04:11:22 2013 Errors in file c:\oracle\product\10.2.0\admin\qprod\b...
1 comment:
December 20, 2012

Performance Shooting: How much can SEQUENCE slow down a SQL

›
How much can SEQUENCE drag down speed of SQL? 10%? 20%? Below my working case show you SEQUENCE drag down 600% speed of one SQL. It is du...
December 7, 2012

MMON Slave Process Reports ORA-7445 [kglic0] Error, Plus Database Hangs

›
A DB suddenly hang during a load. User come to me. When i login the server, i can see the issue DB consuming 100% CPU on the server. Trie...
December 2, 2012

solve ORA-1658 VIA errorstack

›
Sometimes a issue itself is not complicated, but it is hard due to other reason, such as lack of neccesary information. For example, one day...
1 comment:
November 27, 2012

LOCK diagnose: NOWAIT lock requests could hang in RAC (blocked in compatble mode)

›
This summary is not available. Please click here to view the post.
1 comment: