ORACLE数据库服务热线：13764045638 诗檀软件

摘要： Question #1:==========_optimizer_cost_based_transformation=false Currently set to false, should we keep or remove it for 11g upgrade?It is a workarond for several bugs, including ORA-600 bug 6666870 f... 阅读全文

摘要： Found that background process of diag is occupied high pga memory usage in RAC of node 1.Value of PGA memory usage is captured by "select sid, name, value from v$statname n, v$sesstat s where n.statis... 阅读全文

摘要： 9i 中v$session_wait 是Oracle wait interface的一个主要用户接口，而该动态视图的内容来源于x$ksusecst内部视图：SQL> select view_definition from v$fixed_view_definition where view_name='GV$SESSION_WAIT';VIEW_DEFINITION----------------... 阅读全文

摘要： _optimizer_adaptive_cursor_sharing=false disables the feature.There are 2 new columns in V$sql , IS_BIND_SENSITIVE and IS_BIND_AWARE that indicate the status for individual cursors.1.) The parameter "... 阅读全文