-
编辑 删除
Mutexes in Oracle10g
摘要Mutexes的介绍从http://archive.netbsd.se/?ml=oracle-l&a=2006-04&t=1969601To improve cursor execution and also hard parsing, a new memory serialization mechanism has been created in 10gR2.For certai...
-
编辑 删除
cursor: pin S
OTN的解释,cursor: pin SA session waits on this event when it wants to update a shared mutex pin and another session is currently in the process of updating a shared mutex pin for the same cursor obj...
-
编辑 删除
sql plan enhancements in 10g
Since the days of Version 7, Oracle has been exposing more (and more detailed) diagnostic information to its users. Oracle was originally instrumented to assist the kernel developers with their own pe...
-
编辑 删除
kksfbc child completion & cursor: pin S
The problem seems to be the following: Session 1 gets a child cursor for a table_x_x_xxxx_x_x cursor...
-
编辑 删除
Static Service Registration (SID_LIST) Section
一直使用listener.ora中的静态注册，但一直没有系统学习其中各部分的含义，今天看到trace listener顺便学习一下You can use the SID_LIST section of the listener.ora to statically configure service informatio...
-
编辑 删除
row cache lock等待事件一例
上线前第一次预演：有多进程ctas大表的时候数据中出现了大量的row cache lock，由于前期也用同样的脚本导过一次，速度很快，就没有非空闲等待事件，所以很奇怪，既然问题出现了，只奇怪是没用的，row cache只有看看v...
-
编辑 删除
ORA-00600: internal error code, arguments: [ktadrprc-1]
忘记关recyclebin了，现在回收站占了很大的空间，想清一下回收站start time09050207:02:38 PMpurge dba_recyclebin*ERROR at line 1:ORA-00600: internal error code, arguments: [ktadrprc-1], [], [], [], [], []...
-
编辑 删除
10g Recyclebin Features And How To Disable it( _recyclebin )
Doc ID: 265253.1In this Document Purpose Scope and Application 10g Recyclebin Features And How To Disable it( _recyclebin ) ABOUT 10g...
-
编辑 删除
ora10g Collecting statistics
1.base 1) 为了让查询优化器(query optimizer)产生最优的执行计划，对象上的statistics一定是要有效的。oracle数据库收集statistics的功能在每个版本都在得到不断的提高 2) 8i中，引入了dbms_sta...
-
编辑 删除
EXP-00009: no privilege to export
xjprmapp:jfexp:/jfexp>exp monitor/monitor@crmdb tables=dbcustadm.dcustdoc file=dcutdoc.dmp direct=yExport: Release 9.2.0.1.0 - Production on Tue Apr 28 22:49:18 2009Copyright (c) 1982, 2002, Oracle ...
-
编辑 删除
Finding chained rows in Oracle tables
Finding and repairing chained rows is an important part of Oracle administration. When an Oracle rows expands, it sometimes chains onto multiple data blocks. Excessive row chaining can cau...
-
编辑 删除
关于insert append
SQL> truncate table bill3g.BF_PAY_FEE_T;Table truncated.Elapsed: 00:00:01.22SQL> insert /*+ append parallel(a 2) */into bill3g.BF_PAY_FEE_T a select * from bss2.BF_PAY_FEE_T@zz where city_code=890;^...
-
编辑 删除
rac parameter
Parameters That Must Be Identical Across All InstancesCertain initialization parameters that are critical at database creation or that affectcertain database operations must have the same value for e...
-
编辑 删除
V$LOCKED_OBJECT中的object_Id
dba_objects中有object_id和dba_object_id，那V$LOCKED_OBJECT中的object_Id到底应该和哪个对应呢？做个实验来验证下SQL> show userUSER is "SYS"SQL> create table test as select * from tab where 1=2;Table cr...
-
编辑 删除
语句优化一例
语句为：select '20000号拆出来的套餐订购 895'||count(*)from uniteleacc.bb_user_product_info_t a,unitelecrm.bb_service_relation_t b, tsubproduct_item_20000mid d, pitemrolemid cwhere a.f_use...
-
编辑 删除
oracle hint
DRIVING_SITE Hint The DRIVING_SITE hint instructs the optimizer to execute the query at a different site than that selected by the database. This hint is useful if you are using distributed query opt...
-
编辑 删除
Troubleshooting ORA-27300 ORA-27301 ORA-27302 errors
晚上有应用人员说测试库连不了，第一反应是看看/oracle文件系统是否满了，没满，于是再看看alert文件，一堆报错Errors in file /oracle/app/admin/crmkfdb/bdump/crmkfdb_psp0_152212.trc:ORA-27300: OS system dep...
-
编辑 删除
较少见的等待事件Local Write Wait-- Event 60
Oracle 10.2.0.1.0在开发环境里面truncate一些列表，速度奇慢。看了一下session等待事件 Local Write Wait- Event# 是60，Class是 User I/O。 上Metalink也没有查到这个等待事件，Google了一下，还是找到了一点解释...
-
编辑 删除
转：Managing swap in Oracle Linux & UNIX
For those of us who review the Oracle installation documentation, we know that Oracle suggests that you configure a substantial amount of swap space. If you have between 1 and 2G RAM, you need to conf...
-
编辑 删除
Detecting Potential I/O Bottlenecks in AIX
Using IBM's AIX dialect of UNIX, an I/O bound database server is usually evidenced by a high value in the wa (wait) column of vmstat. In the next listing, we see that 22 percent of the CPU time is bei...
