-
编辑 删除
缩小表空间，回收磁盘
##缩小表空间select /*+ ordered use_hash(a,c) */ &nb...
-
编辑 删除
Oracle Parallel Execution(并行执行)
【源自网络】关于Oracle 的并行执行，Oracle 官方文档有详细的说明： Using Parallel Executionhttp://download.oracle.com/docs/cd/E11882_01/server.112/e10837/parallel....
-
编辑 删除
Oracle Parallel Execution(并行执行)
【源自网络】关于Oracle 的并行执行，Oracle 官方文档有详细的说明： Using Parallel Executionhttp://download.oracle.com/docs/cd/E11882_01/server.112/e10837/parallel....
-
编辑 删除
How To Analyze the Wait Statistic: 'enq: HW - contention' [ID 419348.1]
In this Document Goal SolutionApplies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 and later [Release: 10.2 and later ]Information in this document applies to any plat...
-
编辑 删除
Wait: log file sync
When a user session commits (or rolls back), the session's redo information must be flushed to the redo logfile by the LGWR background process. This event shows the time that it takes for th...
-
编辑 删除
Automatic SQL Tuning - SQL Profiles. [ID 271196.1]
Applies to: Oracle Server - Enterprise Edition - Version 10.1.0.2 and laterInformation in this document applies to any platform.PurposeSQL Profiles is a new feature from 10g which is manage...
-
编辑 删除
Taking Systemstate Dumps when You cannot Connect to Oracle [ID 121779.1]
***Checked for relevance on 5-Nov-2012***PURPOSE-------The purpose of this note is to provide a method for taking system state dumpson the very rare occasions when connect internal is not...
-
编辑 删除
SYSTEMSTATE DUMPs: An example of how to take and upload them [ID 125568.1]
Applies to: Enterprise Manager for Oracle Database - Version: 8.1.7.4 and later [Release: and later ]Oracle Server - Enterprise Edition - Version: 6.0.0.0 and later [Release: 6.0 and l...
-
编辑 删除
Further TNS Listener Tracing [ID 751432.1]
In this Document Goal Solution ReferencesApplies to: Oracle Net Services - Version: 9.2.0.1.0 to 11.2.0.1 - Release: 9.2 to 11.2Information in this document applies to any platform.Checke...
-
编辑 删除
Diagnosing TNS listener Hangs [ID 1401376.1]
Applies to: Oracle Net Services - Version: 9.2.0.1 and later [Release: 9.2 and later ]Information in this document applies to any platform.GoalTo be used to help diagnose and offer possibl...
-
编辑 删除
ORACLE监听日志的正确删除步骤
【源自网络】1.进入$ORACLE_HOME/network/log,查看日志大小 du -a2. 把 listen log 关闭.lsnrctl set log_status off;3.把日志改名,mv listener.log listener.log_bak4.启动listen log lsnrctl set log_s...
-
编辑 删除
局部分区索引的分区消除
【源自网络】 局部分区索引的分区消除分区消除行为：如果查询首先访问索引，是否能消除分区完全取决于查询中的谓词。SQL> create table test2 (a int,3 b int,4 data char(20)5 )6 partition by range(...
-
编辑 删除
oracle 中 global index & local index的区别
【源自网络】 表可以按range，hash，list分区，表分区后，其上的索引和普通表上的索引有所不同，oracle对于分区表上的索引分为2类，即局部索引和全局索引，下面分别对这2种索引的特点和局限性做个总结...
-
编辑 删除
自动工作负载库（Automatic Workload Repository，AWR）
AWR的由来： 10g之前的oracle:用户的连接将产生会话，当前会话记录保存在v$session中；处于等待状态的会话会被复制一份放在v$session_wait中。当该连接 断开后，其原来的连接信息在v$session和v$session_...
-
编辑 删除
视图杂记7
ALL_AUDIT_POLICIESALL_AUDIT_POLICY_COLUMNS ALL_CLUSTERSALL_COLL_TYPESALL_COL_COMMENTSALL_COL_PENDING_STATSALL_COL_PRIVS ALL_COL_PRIVS_MADEALL_COL_PRIVS_RECD ALL_CONSTRAINTSALL_CONS_C...
-
编辑 删除
视图杂记5
•DBA_TABLES and DBA_OBJECT_TABLES•DBA_TAB_STATISTICS and DBA_TAB_COL_STATISTICS•DBA_TAB_HISTOGRAMS•DBA_TAB_COLS•DBA_COL_GROUP_COLUMNS•DBA_INDEXES and DBA_IN...
-
编辑 删除
视图杂记4
When you specify WITHOUT VALIDATION for the exchange partition operation, this is normally a fast operation because it involves only data dictionary updatesTo avoid the overhead of this valida...
-
编辑 删除
分区操作
Modify Partition Unusable local indexes Marks the local index partition associated with the table partition as UNUSABLE Modify Partition Rebuild Unusable local indexes Rebuilds ...
-
编辑 删除
视图杂记3
DBA_CONSTRAINTS ALL_CONSTRAINTSUSER_CONSTRAINTS DBA view describes all constraint definitions in the database. ALL view describes constraint definitions accessible to current user. USER v...
-
编辑 删除
视图杂记2
SELECT * FROM V$DIAG_CRITICAL_ERROR;---To find the trace file for your current session:SELECT VALUE FROM V$DIAG_INFO WHERE NAME = 'Default Trace File';---To find all trace files for the curren...
