-
编辑 删除
KGL simulator, shared pool simulator and buffer cache simulator
http://blog.tanelpoder.com/2009/09/13/kgl-simulator-shared-pool-simulator-and-buffer-cache-simulator-what-are-these/ http://www.eygle.com/archives/2011/11/simulator_lru_latch.html KGL=Ke...
-
编辑 删除
熊猫大侠一次性能诊断优化十一问
熊猫大侠一次性能诊断优化十一问刚才看到 ORA-600 & ORA-7445 by Maclean...
-
编辑 删除
熊猫大侠十一问
熊猫大侠十一问
-
编辑 删除
Tanel Poder
Oracle, Exadata, Performance, Troubleshooting
-
编辑 删除
Understanding METHOD_OPT=> 'for all columns size'
version 1：method_opt:决定histograms信息是怎样被统计的 method_opt参数尤其适合在表和索引数据发生变化时刷新统计数据。method_opt参数也适合用于判断哪些列需要直方图。 某些情况下，索引内的各个...
-
编辑 删除
无题
来时顾瞻清波门，再日西湖梦浊雰。 欲知往来归何处，此中泪多湖上雨。 浮生长叹锁眉沉...
-
编辑 删除
http://www.eygle.com/archives/2012/03/enmotech_blog_portal.html
http://www.eygle.com/archives/2012/03/enmotech_blog_portal.html
-
编辑 删除
OakTable
OakTable
-
编辑 删除
Julian Dyke
Julian Dyke
-
编辑 删除
Oracle Database, Application Server, and Collaboration Suite Documentation
Search and Download Oracle Database, Application Server, and Collaboration Suite Documentation
-
编辑 删除
ixora
ixora
-
编辑 删除
Jonathan Lewis
Jonathan Lewis
-
编辑 删除
Jeffrey Hunter
Jeffrey Hunter
-
编辑 删除
asktom
asktom
-
编辑 删除
Prevents Merging An Inline View
Quote from oracle doc：Using the NO_MERGE Hint The NO_MERGE hint prevents the database from merging an inline view into a potentially non-collocated SQL sta...
-
编辑 删除
Tuning Outer Joins
Tuning Left join：SQL> /已选择1777行。已用时间: 00: 00: 15.82执行计划----------------------------------------------------------Plan hash value: 3132434474---------------------------...
-
编辑 删除
Diagnostic and Tuning Tools
http://oreilly.com/catalog/oracle2/chapter/ch10.html#64141:In this chapter: MONITOR: Monitoring System Activity Tables SQL_TRACE: Writing a Trace File TKPROF: Interpreting the Trace File EXPLAIN ...
-
编辑 删除
Csscan&Lcsscan
1 C:\Documents and Settings\pengju> csscan -help Character Set Scanner v2.1 : Release 10.2.0.0.0 - Production on 星期二 4月 10 21:03:48 2012 Copyright (c) 1982, 2005, Oracle. ...
-
编辑 删除
non
select (select l.ORACLE_USERNAME from v$session_wait sw, ...
-
编辑 删除
Locktree
E:\oracle\product\10.2.0\db_2\RDBMS\ADMIN\utllockt.sqlrem rem $Header: utllockt.sql 21-jan-2003.16:21:56 bnnguyen Exp $ locktree.sql rem Rem Copyright (c) 1989, 2003, Oracle Corporation. Al...
