ORACLE 优秀博文收藏

wait event 的文档 Kyle Hailey
https://sites.google.com/site/embtdbo/wait-event-documentation

Adaptive Cursor Sharing
http://database.com.mk/wordpress/2010/05/03/adaptive-cursor-sharing/

direct path read 相关
http://afatkulin.blogspot.com/2009/01/11g-adaptive-direct-path-reads-what-is.html
http://afatkulin.blogspot.com/2012/07/serial-direct-path-reads-in-11gr2-and.html

 

ORA-15041,ASM磁盘虚假耗尽：

https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?returnToSrId=&_afrLoop=753804223145954&srnum=&type=DOCUMENT&id=460155.1&displayIndex=1&_afrWindowMode=0&_adf.ctrl-state=11997r76ax_49

 

 

oracle里列值顺序对性能的影响，很好的文章

http://www.ixora.com.au/tips/table_column_order.htm

 

 

Recursive Sessions and ORA-00018: maximum number of sessions exceeded

http://tech.e2sn.com/oracle/oracle-internals-and-architecture/recursive-sessions-and-ora-00018-maximum-number-of-sessions-exceeded

 

 

Systematic Latch Contention Troubleshooting in Oracle
http://tech.e2sn.com/oracle/troubleshooting/latch-contention-troubleshooting

 

Session Snapper

http://tech.e2sn.com/oracle-scripts-and-tools/session-snapper

 

Killing Oracle Sessions
http://www.oracle-base.com/articles/misc/killing-oracle-sessions.php

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22034023/viewspace-762581/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22034023/viewspace-762581/