-
编辑 删除
"scnhealthcheck.sql" script (文档 ID 1393363.1)
APPLIES TO:Oracle Database - Enterprise Edition - Version 10.1.0.5 to 12.1.0.1 [Release 10.1 to 12.1]Oracle Database - Standard Edition - Version 10.1.0.5 to 12.1.0.1 [Release 10.1 to 12.1]Information in this document applies to any platform.PURPOSEThis document describes the "scnhealth...
-
编辑 删除
PARALLEL_DEGREE_POLIC
The initialization parameter PARALLEL_DEGREE_POLICY controls whether automatic degree of parallelism (DOP), parallel statement queuing, and in-memory parallel execution are enabled. This parameter has three possible values:MANUAL - Disables automatic DOP, statement queuin...
-
编辑 删除
Waiting for clusterware split-brain resolution
APPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.1.0.2 [Release 11.2 to 12.1]Information in this document applies to any platform.PURPOSEThe purpose of this document is to explain when a "Waiting for clusterware split-brain resolution" alert log message ...
-
编辑 删除
Master Note for Tablespace Issues
Master Note for Tablespace Issues (文档 ID 1270839.1)转到底部APPLIES TO:...
-
编辑 删除
How to Perform a Health Check on the Database
How to Perform a Health Check on the Database (文档 ID 122669.1)1. Parameter file2. Controlfiles3. Redolog files4. Archiving5. Datafiles 5.1 Autoextend 5.2 Location6. Tablespaces 6.1 SYSTEM Tablespace 6.2 SYSAUX Tablespace (10g Release and above) 6.3 Loc...
-
编辑 删除
不完全恢复，选择性。
==================================list backup of database summary;list backup of database;==============选择时间段恢复：1，restore database from tag='q107' validate ;2，run{set until time "to_date('2016-12-22 08:00:00','yyyy-mm-dd hh24:mi:ss')";restore database;}List of Backups=====...
-
编辑 删除
单机升级rac
1，修改spfile：*.audit_file_dest='/u01/app/oracle/admin/hrbvsdb/adump'*.audit_trail='DB'*.cluster_database_instances=3*.cluster_database=true*.compatible='11.2.0.4.0'*.control_files='+DATA/control01.ctl','+DATA/control02.ctl'*.db_block_size=8192*.db_name='apex'*.db_recovery_file_dest_size...
-
编辑 删除
数据库不完全恢复。
RMAN> startup mountOracle instance starteddatabase mountedTotal System Global Area 1068937216 bytesFixed Size 2260088 bytesVariable Size 666895240 bytesDatabase Buffers 394264576 bytesRedo Buffers 5517312 bytesRMAN> list backup of database;List of Backup Sets===================BS Key Type LV Size Device Type Elapsed Time Completion Time-------
-
编辑 删除
"scnhealthcheck.sql" script (文档 ID 1393363.1)
APPLIES TO:Oracle Database - Enterprise Edition - Version 10.1.0.5 to 12.1.0.1 [Release 10.1 to 12.1]Oracle Database - Standard Edition - Version 10.1.0.5 to 12.1.0.1 [Release 10.1 to 12.1]Information in this document applies to any platform.PURPOSEThis document describes the "scnhealth...
-
编辑 删除
Removing Sessions in Killed Status on Unix (文档 ID 274216.1)
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...
-
编辑 删除
Killed Session Are Not Cleaned By PMON
In this DocumentSymptomsCauseSolutionReferencesAPPLIES TO:Oracle Database - Enterprise Edition - Version 9.2.0.1 and laterInformation in this document app...
-
编辑 删除
PRTMV means PARTition Mult-Version.
PRTMV means PARTition Mult-Version.11204 bug 分区表 主备不同步？
-
编辑 删除
标量子查询
SQL允许子查询出现在返回单个值的表达式能够出现的任何地方，只要该子查询只返回包含单个属性的单个元组；这样的子查询称为标量子查询（scalar subquery）。例如，一个子查询可以用到下面例子的select子句中，这个例子列出所有的系以及它们拥有的教师数：select dept_name, (select co...
-
编辑 删除
Connections to NOMOUNT/MOUNTED or RESTRICTED Databases Fail
In this DocumentSymptomsChangesCauseSolutionReferencesAPPLIES TO:Oracle Net Services - Version 11.1.0.6 to 11.2.0.4 [Relea...
-
编辑 删除
Fail with TNS-12526, TNS-12527 or TNS-12528
In this DocumentSymptomsChangesCauseSolutionReferencesAPPLIES TO:Oracle Net Services - Version 10.2.0.5 to 12.1.0.2 [Relea...
-
编辑 删除
RMAN DUPLICATE...FROM ACTIVE DATABASE (文档 ID 1075908.1)
In this DocumentGoalSolution PROCEDURE: 1. Prepare the production database to be the primary database 2. Ensure ...
-
编辑 删除
Connecting to Nomounted database
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...
-
编辑 删除
oracle 统计信息过期判断和自动收集
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...
-
编辑 删除
oracle直方图使用
Height-Balanced Histograms:当桶数量>列中的不同值的个数,或者不同值大于254.优化器首先会检查在直方图中使用谓词作为endpoint的有多少个bucket？1，如果有多个，计算公式：Number of bucket endpoints / total number of buckets) * number of rows in the table2，对于只是一个bucket或者不是任何bu...
-
编辑 删除
oracle 柱状图（Histograms）
柱状图（Histograms）：Height-Balanced Histograms：列中不同值的个数小于直方图的桶数，每个桶的值不同。Frequency Histograms：列中不同值的个数大于直方图的桶数，每个桶的值相同，最后一个桶除外。 收集方法：GATHER_TABLE_STATS==》method_opt 通过size参数指定直方图的桶数：SIZE {integer | REPEAT |...
