ITPub博客

PURPOSE=======This article explains how to get rid of idle sessions. Even when we kill idlesessions from the database, they remain in "killed" status and are accounted for the total sessions/processes initialization parameter.PREFACE=======Sometimes we find orphan server processes which will...

In this DocumentSymptomsCauseSolutionReferencesAPPLIES TO:Oracle Database - Enterprise Edition - Version 9.2.0.1 and laterInformation in this document app...

PRTMV means  PARTition Mult-Version.11204 bug  分区表 主备不同步？

SQL允许子查询出现在返回单个值的表达式能够出现的任何地方，只要该子查询只返回包含单个属性的单个元组；这样的子查询称为标量子查询（scalar subquery）。例如，一个子查询可以用到下面例子的select子句中，这个例子列出所有的系以及它们拥有的教师数：select dept_name,  (select co...

In this DocumentSymptomsChangesCauseSolutionReferencesAPPLIES TO:Oracle Net Services - Version 11.1.0.6 to 11.2.0.4 [Relea...

In this DocumentSymptomsChangesCauseSolutionReferencesAPPLIES TO:Oracle Net Services - Version 10.2.0.5 to 12.1.0.2 [Relea...

In this DocumentGoalSolution PROCEDURE: 1. Prepare the production database to be the primary database 2. Ensure ...

ORA-12528: TNS:listener: all appropriate instances are blocking new connectionsUse (UR=A) with (CONNECT_DATA=(SERVICE_NAME=SERVICE))Connection using SERVICE_NAME without (UR=A) would error with ORA-12528: TNS:listener: all appropriate instances are blocking new connectionsT...

Stale statisticsStatistics gathered by?DBMS_STATS?can become out-of-date. Typically, statistics are stale when 10% or more of the rows in the table have changed since the last time statistics were gathered.The?GATHER_DATABASE_STATS?or?GATHER_SCHEMA_STATS?procedu...

 Height-Balanced Histograms:当桶数量>列中的不同值的个数,或者不同值大于254.优化器首先会检查在直方图中使用谓词作为endpoint的有多少个bucket？1，如果有多个，计算公式：Number of bucket endpoints / total number of buckets) *  number of rows in the table2，对于只是一个bucket或者不是任何bu...

柱状图（Histograms）：Height-Balanced Histograms：列中不同值的个数小于直方图的桶数，每个桶的值不同。Frequency Histograms：列中不同值的个数大于直方图的桶数，每个桶的值相同，最后一个桶除外。 收集方法：GATHER_TABLE_STATS==》method_opt 通过size参数指定直方图的桶数：SIZE {integer | REPEAT |...

service dg rac

 ODA Oracle Database Appliance orachk Healthcheck (Doc ID 2126926.1)Multiplexing Redolog and Control File on ODA (Doc ID 2086289.1)ORAchk – Health Checks for the Oracle Stack (Doc ID 1268927.2)How to Perform a Health Check on the Database (Doc ID 122669.1)Health Monitor (Doc...

blkid – command-line utility to locate/print block device attributesOracle Linux Server release 6.4 [root@rac02:/root]# ll /etc/*release*-rw-r--r--. 1 root root 32 Feb 22 2013 /etc/oracle-release-rw-r--r--. 1 root root 55 Feb 22 2013 /etc/redhat-releaselrwxrwxrwx. 1 root root 14 Nov 29 ...

Stale statisticsStatistics gathered by DBMS_STATS can become out-of-date. Typically, statistics are stale when 10% or more of the rows in the table have changed since the last time statistics were gathered.The GATHER_DATABASE_STATS or GATHER_SCHEMA_STATS procedu...

DISPLAY - to format and display the contents of a plan table.DISPLAY_AWR - to format and display the contents of the execution plan of a stored SQL statement in the AWR.DISPLAY_CURSOR - to format and display the contents of the execution plan of an...

In this DocumentGoalSolutionReferencesAPPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]Information in this document applies to any platform.**...

In this DocumentGoalFixReferencesAPPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.2 and laterInformation in this document applies to any platform.***Checked for relevance...

APPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterInformation in this document applies to any platform.GOALThe primary goal of this how-to is establish a data guard configuration where the primary site is RAC and the standby site is RAC.  Please Not...

Database connections that require SYSDBA privilege and broker connections should be performed through dedicated server based connections NOT dispatchers and shared server processes.NAME                                ...