-
编辑 删除
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...
-
编辑 删除
视图杂记1
V$PROCESS Contains information about the currently active processes V$SESSION Lists session information for each current session V$SESS_IO Contains I/...
-
编辑 删除
停止JOB的操作
select sid from dba_jobs_running;select a.spid from v$process a ,v$session b where a.addr=b.paddr and b.sid in (select sid from dba_jobs_running); EXEC DBMS_JOB.BROKEN(job#,TRUE); se...
-
编辑 删除
ORADEBUG一些操作
SQL> oradebug help ...---oradebug setmypidselect spid, pid from v$process where addr = (select paddr from v$session where sid = <your SID >);SQL> oradebug setospid 19592SQL> oradebug setorapid...
-
编辑 删除
alter system/session set events详解
【源自网络】 格式：alter system|session set events ‘[eventnumber|immediate] trace name eventname [forever] [, level levelnumber] : …….’通过:符号，可以连续设置多个事件，也可以通过连续...
-
编辑 删除
oracle物化视图日志结构
【源自网络】 物化视图的快速刷新要求基本必须建立物化视图日志，这篇文章简单描述一下物化视图日志中各个字段的含义和用途。 物化视图日志的名称为MLOG$_后面跟基表的名称，如果表名的长度超过20...
-
编辑 删除
物化视图日志的维护
【源自网络】物化视图日志经常会由于物化视图长时间没有刷新，或者基表的一次批量数据更改而变得很大，这会影响物化视图的刷新性能，因此对于这种情况需要对物化视图日志进行处理，降低物化视图日志表的高水...
