-
编辑 删除
How I Resolved Performance Issues After Upgrading from 9i to 10g
In my previous organization, after upgrading the databases from Oracle 9i to 10g, we had a few performance issues. In Oracle 9i, some Queries used to give full reasults in few minutes but th...
-
编辑 删除
诊断事件
诊断事件设置方法：parameter file INIT.ORAdynamically be set using the ALTER SESSION SET EVENTS commanddbms_system.set_ev procedure ORADEBUG utility大体上可分为四类Immediate Dump Events命令提交后即dump...
-
编辑 删除
sga pga management
create pfile from spfile='***/spfileorcl.ora'修改参数文件[oracle@rac1 dbs]$ cat initorcl1.ora orcl2.__db_cache_size=71303168--双下划线参数是由mman进程维护的内部设置 被用于后续自动调整的起...
-
编辑 删除
create statspack
create statspack spdrop.sql Drop PER...
-
编辑 删除
探寻PIN LOCK整理中................
-> Library cache lock: This event controls the concurrency between clients of the library cache. It acquires a lock on the object handle so that either: One client can prevent other clients from acces...
-
编辑 删除
Buffer Busy Wait..整理中.............
当进程需要存取SGA中的buffer的时候，它会依次执行如下步骤的操作：1.获得cache buffers chains latch，遍历那条buffer chain直到找到需要的buffer header2.根据需要进行的操作类型(读或写)，它需要在buffer heade...
-
编辑 删除
非空闲等待事件
非空闲等待事件： 通常数据库发生竞争时就会出现非空闲的等待事件，即某种操作A发生时，A所需要的资源正在被其他的操作占用，而这种独占的资源不能被操作A请求立即得到...
-
编辑 删除
等待事件
转载至http://space.e800.com.cn/haiboli/entity/view/?id=245471 等待事件概述 Oracle的等待事件是衡量oracle运行状况的重要依据及指标. 等待事件的概念是在Oracle7.0.1.2中引入的，大致有100个等待事件。...
-
编辑 删除
查看正在运行的过程或正在被引用的对象
select * from V$access where type='PROCEDURE'V$ACCESS displays information about locks that are currently imposed on library cache objects. The locks are imposed to ensure that they are not aged out ...
-
编辑 删除
consistent get 和DB block get的认识
Oracle accesses blocks in one of two modes, current or consistent.A 'db block get' is a current mode get. That is, it's the most up-to-datecopy of the data in that block, as it is right now, or ...
