- 博客(55)
- 收藏
- 关注
转载 Oracle 11g 针对SQL性能的新特性(三)- SQL Plan Management
【源自网络】SQL Plan Management (SPM)历史SQL的执行效率,取决于它的执行计划是否高效。 优化器的算法是一个平衡,需要收集尽量少的信息,用尽量快的速度试图去得到一个最优的执行计划,这也...
2013-08-24 20:19:18
158
转载 rollback的进度
【源自网络】如果一个会话正在回滚,如何知道回滚的进度?如何知道还需要多长时间才能回滚结束?下面做一个简单的总结:=========================一、对于死事务对死事务,可以查询x$ktuxe:...
2013-06-16 14:50:18
270
转载 CheckPoint
【源自网络】目的-----本文帮助DBA更好地理解增量检查点,checkpoint调优的相关参数信息:- FAST_START_MTTR_TARGET - LOG_CHECKPOINT_INTERV...
2013-05-23 11:42:43
206
转载 权限视图
ALL_COL_PRIVSDescribes all column object grants for which the current user or PUBLIC is th...
2013-03-21 14:17:52
169
转载 ORACLE EXECUTE IMMEDIATE
【源自网络】EXECUTE IMMEDIATE 代替了以前Oracle8i中DBMS_SQL package包.它解析并马上执行动态的SQL语句或非运行时创建的PL/SQL块.动态创建和执行SQL语句性能超...
2013-03-08 23:16:25
105
转载 monitor impdp/expdp
相关视图:• DBA_DATAPUMP_JOBS - all active Data Pump jobs and the state of each job • USER_DATAPUMP_JOBS – su...
2013-02-28 22:41:07
80
转载 inode知识
源自 http://blog.chinaunix.net/uid-25892360-id-3072958.html转载:http://www.kuqin.com/linux/20111204/315634....
2013-02-20 10:27:10
91
转载 Creating Physical Standby Using RMAN DUPLICATE FROM ACTIVE DATABASE
Applies to: Oracle Server - Enterprise Edition - Version 11.1.0.6 to 11.2.0.4 [Release 11.1 to 11.2]Info...
2013-01-24 22:44:51
146
转载 ORA-32000 not able to modify the rdbms spfile which is there in ASM
In this DocumentSymptomsChangesCauseSolutionApplies to: Oracle Server - Enterprise Edition - Version 11....
2013-01-23 20:36:51
433
转载 Oracle IO问题解析
【源自网络】数据库的作用就是实现对数据的管理和查询。任何一个数据库系统,必然存在对数据的大量读或者写或者两中操作都大量存在。IO问题也往往是导致数据库性能问题的重要原因。在这篇文章中,主要帮助大家在理解Ora...
2013-01-13 21:14:48
221
转载 视图杂记8
V$SESSION_BLOCKERSV$SESS_TIME_MODELV$SYS_TIME_MODEL V$SESSION_LONGOPSV$SESSION_WAIT_HISTORYV$SESSION_CON...
2013-01-09 20:21:51
147
转载 WARNING: Read Failed. group:5 disk:3 AU:14009 offset:630784 size:8192
系统平台:AIX 6100-05-05-1112数据库版本:11.2.0.2.0实例的 alert 报错:Errors in file /oracle/app/oracle/diag/rdbms/csh...
2013-01-06 19:16:02
758
转载 奇怪的indrebuild$
长事务统计中发现如下会话SQL,一直持续...在MOS未找到相关indrebuild$说明,又是BUG?SID SERIAL# MACHINE OWNER...
2013-01-06 02:26:07
177
转载 SESSION_CACHED_CURSORS,OPEN_CURSORS,CURSOR_SHARING
SESSION_CACHED_CURSORS,就是说的是一个session可以缓存多少个cursor,让后续相同的SQL语句不再打开游标,从而避免软解析的过程来提高性能。(绑定变量是解决硬解析的问题),软解析...
2013-01-02 20:16:54
112
转载 Oracle Parallel Execution(并行执行)
【源自网络】关于Oracle 的并行执行,Oracle 官方文档有详细的说明: Using Parallel Executionhttp://do...
2012-12-12 23:52:07
64
转载 Oracle Parallel Execution(并行执行)
【源自网络】关于Oracle 的并行执行,Oracle 官方文档有详细的说明: Using Parallel Executionhttp://do...
2012-12-12 23:52:07
85
转载 How To Analyze the Wait Statistic: 'enq: HW - contention' [ID 419348.1]
In this Document Goal SolutionApplies to: Oracle Server - Enterprise Edition - Version: 10...
2012-12-12 23:38:34
90
转载 Wait: log file sync
When a user session commits (or rolls back), the session's redo information must be flushed to the red...
2012-12-12 22:49:16
55
转载 Automatic SQL Tuning - SQL Profiles. [ID 271196.1]
Applies to: Oracle Server - Enterprise Edition - Version 10.1.0.2 and laterInformation in this documen...
2012-12-12 22:44:00
120
转载 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 ...
2012-12-09 15:36:38
69
转载 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...
2012-12-09 15:36:00
109
转载 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...
2012-12-09 15:03:31
67
转载 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...
2012-12-09 15:02:19
96
转载 ORACLE监听日志的正确删除步骤
【源自网络】1.进入$ORACLE_HOME/network/log,查看日志大小 du -a2. 把 listen log 关闭.lsnrctl set log_status off;3.把日志改名,mv...
2012-12-09 14:34:10
1862
转载 操作分区表对global和local索引的影响
【源自网络】使用分区表,要非常注意索引。因为删除、move分区都会造成索引失效。小表的索引和非主键、唯一建索引还好,重建即可。 如果是几十G的表,重建索引花费巨大,会严重影响查询性能; 如果是主键或者...
2012-12-08 22:01:55
268
转载 局部分区索引的分区消除
【源自网络】局部分区索引的分区消除分区消除行为:如果查询首先访问索引,是否能消除分区完全取决于查询中的谓词。SQL> create table test2 (a int,3 b int,4 data ...
2012-12-08 20:44:39
150
转载 oracle 中 global index & local index的区别
【源自网络】表可以按range,hash,list分区,表分区后,其上的索引和普通表上的索引有所不同,oracle对于分区表上的索引分为2类,即局部索引和全局索引,下面分别对这2种索引的特点和局限性做个总结...
2012-12-08 19:40:08
122
转载 自动工作负载库(Automatic Workload Repository,AWR)
AWR的由来: 10g之前的oracle:用户的连接将产生会话,当前会话记录保存在v$session中;处于等待状态的会话会被复制一份放在v$session_wait中。当该连接 断开后,其原来的连接信...
2012-12-08 17:10:18
86
转载 视图杂记7
ALL_AUDIT_POLICIESALL_AUDIT_POLICY_COLUMNS ALL_CLUSTERSALL_COLL_TYPESALL_COL_COMMENTSALL_COL_PENDIN...
2012-12-07 00:25:03
136
转载 视图杂记5
•DBA_TABLES and DBA_OBJECT_TABLES•DBA_TAB_STATISTICS and DBA_TAB_COL_STATISTICS•DBA_TAB_HISTOGRAMS•DBA_T...
2012-12-07 00:24:09
72
转载 视图杂记4
When you specify WITHOUT VALIDATION for the exchange partition operation, this is normally a fast operat...
2012-12-07 00:22:52
83
转载 分区操作
Modify Partition Unusable local indexesMarks the local index partition associated with the table partit...
2012-12-07 00:22:02
125
转载 视图杂记3
DBA_CONSTRAINTS ALL_CONSTRAINTSUSER_CONSTRAINTSDBA view describes all constraint definitions in the dat...
2012-12-07 00:20:26
100
转载 视图杂记2
SELECT * FROM V$DIAG_CRITICAL_ERROR;---To find the trace file for your current session:SELECT VALUE FROM...
2012-12-07 00:19:22
86
转载 视图杂记1
V$PROCESS Contains information about the currently active processes V$SESSION Lists session informat...
2012-12-07 00:16:05
93
转载 停止JOB的操作
select sid from dba_jobs_running;select a.spid from v$process a ,v$session b where a.addr=b.paddr and b....
2012-12-07 00:13:52
215
转载 ORADEBUG一些操作
SQL> oradebug help ...---oradebug setmypidselect spid, pid from v$process where addr = (select paddr ...
2012-12-07 00:09:22
58
转载 alter system/session set events详解
【源自网络】格式:alter system|session set events ‘[eventnumber|immediate] trace name eventname [forever] [, lev...
2012-12-07 00:02:20
119
转载 oracle物化视图日志结构
【源自网络】物化视图的快速刷新要求基本必须建立物化视图日志,这篇文章简单描述一下物化视图日志中各个字段的含义和用途。 物化视图日志的名称为MLOG$_后面跟基表的名称,如果表名的长度超过20位,则...
2012-12-05 00:12:17
83
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人