-
编辑 删除
AWR vs statspack‘s snap method
Oracle AWR and STATSPACK Manual snapshot commandsThere are times when you want to manually collect AWR and STATSPACK snapshots, such as when you are experiencing a performance problem or doing a stress test. You can issue these commands to get a manual AWR or STATSPACK snapshot at whatever elapsed time interval you desire:AWR manual snapshot:EXEC DBMS_WORKLOAD_REPOSITORY.create_snapshot;STATSPACK manual snapshot:exec statspack.snap;[@more@]
-
编辑 删除
转: Latch 系列
Latch 系列一: Introducion <http://www.oracledba.com.cn/blog/?p=26> Posted in Oracle <http://www.oracledba.com.cn/blog/?cat=1> , Brotherxiao's <http://www.oracledba.com.cn/blog/?cat=18> at 3:55 pm by bachelor什么是latch?latch是一种低级别的序列化的内存锁,用于保护SGA中的共享内存结构.(1)确保内核代码序列执行;(2)防止因缓存区崩溃导致的物理块的坏块任何内核代码在执行前,必须获取latch,执行完后释放latch.latch通常通过两种方式来获取:immediate和willing to wait.当进程以immeidate方式请求latch失
-
编辑 删除
oracle 8i+ 10g cient ORA-12518 metalink 解决方案
8Subject: ORA-12518 Reported When Using 10gr2 TNS Listener to Connect To a 8i Database Doc ID: Note:341482.1 Type: PROBLEM Last Revision Date: 11-JAN-2006 Status: PUBLISHED In this Document Symptoms Cause Solution _____ Applies to: Oracle Net Services - Version: 10.2.0.1.0Microsoft WindowsAll Dedicated Oracle Net connections to the database SymptomsWhen using a 10.2 TNS listener to connection to an 8i database, via dedicated connection model, the following error is reported :OR
