Performance tuning library cache lock & single-task message

My colleague suddenly encountered a problem today,a Database becomes very slow , and the a lot of session wait library cache lock event, Let me help him to look. DB env is rac.

ORA-08104 when online index rebuild

Last night ,The Developers ask me they have creating an index do not use parallel,Unacceptably slow. then kill the session to cancel, but now to face ORA-08104 during trying to online index rebuild . that is a busy product database(7×24). DB version 10205 2nodes rac on hpux.

Troubleshooting ORA-07445 [skgxpdmpmem()+22096]

ORA-07445: exception encountered: core dump [skgxpdmpmem()+22096] [SIGSEGV] [Address not mapped to object] [0x0002D0B8C] [] []
Sun Dec 21 20:55:43 EAT 2014
Trace dumping is performing id=[cdmp_20141221205543]
Sun Dec 21 20:55:45 EAT 2014
Errors in file /opt/oracle/app/admin/anbob/bdump/anbob1_pmon_13442.trc:
ORA-00484: LMS* process terminated with error

Troubleshooting ORA-00600 internal error [6704], [2], [1405099], [953234]

刚接手一套数据库,数据库执行SQL时提示 ORA-00600: internal error code, arguments: [6704], [2], [1405099], [953234], [], [], [], [], [], [], [], []],下面简单记录一下。

Shell: extract more from listener.log (分析oracle监听日志连接频率)

最近遇到了两起数据库连接数不足的问题, 通常都会预留一些会话增加的情况, 但在一些特殊情况下如连接风暴(logon storm), 如果在监听中没有做rate限流,对数据库来说
巨大的冲击可能会导致数据库Hang 或 ora-20 或ora-18 错误。

hpux psu 遇到的一些小问题

XX电信就是一个急性子,上午决定升级晚上就要实施,下面记录一下HPUX IA64 PSU […]

Unable execute “@”(at) sql file in sqlplus on hp-ux issue

I have a ORACLE db server on hp-ux,  i want to execute […]