Month: March 2015

loggerd 进程属于ora.crf服务，该服务负责收集一些OS的CPU和Memory信息，作为对实例本身监控的补充，由于很多环境中没有部署OSW脚本监控OS导致很多RAC问题由于缺少OS信息而无法进一步诊断， 所以需要ora.crf收集， 但ora.crf不能替代 OSW。 建议在重要环境中部署OSW监控。 在有orca等监控工具的前提下可以考虑禁用CHM。 对于上述问题可以考虑KILL ologgerd进程释放资源。 As a temporary work around, you can kill ologgerd and delete the contents in the BDB directory. osysmond should respawn ologgerd and new bdb file will get created. The past data is lost when this is done.   具体可以参考：Cluster Health Monitor (CHM) FAQ [ID 1328466.1] crsctl stop…

Oracle bbed的代码风格 371 /* K_BTTRDA, KDDBTDATA: KTB Data, data block layers defn */ 372 static const kutbl *const kutbltt[] = 373 { 374 &kutblcb, /* cache layer */ 375 &kutbltb, /* transaction layer */ 376 &kutbldb, /* data layer */ 377 &kutbltck /* TAILCHK */ 378 }; 379 380 /* K_BTTRDA, KDDBTINDEX: KTB Data, index…

Oracle RMAN 10g中如何提高copy datafile的并发 try something like this: format后面修改为你复制的目标文件名  run  { allocate channel mac01  DEVICE TYPE DISK MAXOPENFILES=1 PARMS=’BLKSIZE=1048576′ ;    allocate channel mac02  DEVICE TYPE DISK MAXOPENFILES=1 PARMS=’BLKSIZE=1048576′ ;    allocate channel mac03  DEVICE TYPE DISK MAXOPENFILES=1 PARMS=’BLKSIZE=1048576′ ;    allocate channel mac04  DEVICE TYPE DISK MAXOPENFILES=1 PARMS=’BLKSIZE=1048576′ ;    backup as copy (datafile…

Q1. Was there any resource intensive activities were scheduled at that time ? Q2. What is the frequency of issue i.e. CPU /mem spike ? Was this spike rauns for very long hours (more than 10 min or so) ? Q3. What the patch details atside ? $$ORACLE_HOME/OPatch/opatch lsinventory -detail Q4. From the given screens/report…

Initial buffer sizes: read 1024K, overflow 832K, change 805K    1691 #ifdef KCRFR_DEBUG    1692     ksdwrf(“Initial buffer sizes: read %luK, overflow %luK, change %luK\n”, 1693            (unsigned long)fx->krrxread_sz/1024, 1694            (unsigned long)fx->krrxovf_sz/1024, 1695            (unsigned long)kcocv_max_read_size/1024);          …

oracle中导出统计信息到其他表的过程 exec dbms_stats.create_stat_table(‘&OWNER’,’MY_STATS_TAB’); exec dbms_stats.export_table_stats(‘&OWNER’,’&SOURCE_TABNAME’,NULL,’MY_STATS_TAB’); exec dbms_stats.import_table_stats(‘&OWNER’,’&TARGET_TABNAME’, null, ‘MY_STATS_TAB’); 检验： select table_name, num_rows from dba_tables where table_name in (‘&SOURCE_TABNAME’ ,’&TARGET_TABNAME’ );  

rman 注册归档(arch)的语句 One way of registering a logfile is via the following: SQL> alter database register logfile ‘/var/arch/arch_1_101.arc’; So this is a straightforward way of registering a logfile giving the full path to the logfile. However, what if you have a very large number of logfiles to register, the above does not really scale all…

resmgr:internal state change等待  resmgr:internal state change==> session 对应的resource manager plan正在改变中 Hang or similar symptoms when changing resource manager plans during heavy workload activity. One or more sessions block on a wait for “resmgr:internal state change”

SQL> select partition_name from dba_ind_partitions where index_name=’LOCAL_ONE’; PARTITION_NAME ——————————————————————————————— EMPLOYEES_PART1 EMPLOYEES_PART2 EMPLOYEES_PART3 SQL> alter index LOCAL_ONE drop partition EMPLOYEES_PART1; alter index LOCAL_ONE drop partition EMPLOYEES_PART1 * 第 1 行出现错误: ORA-14076: 提交的变更索引分区/子分区操作对本地分区的索引无效 You cannot explicitly drop a partition from a local index. Instead, local index partitions are dropped only when you drop a partition from the…

cssd.log中的报错信息如下： 2013-09-25 08:46:03.739: [    CSSD][2834](:CSSNM00018:)clssnmvDiskCheck: Aborting, 0 of 1 configured voting disks available, need 1 2013-09-25 08:46:03.749: [    CSSD][2834]################################### 2013-09-25 08:46:03.749: [    CSSD][2834]clssscExit: CSSD aborting from thread clssnmvDiskPingMonitorThread 2013-09-25 08:46:03.749: [    CSSD][2834]################################### 2013-09-25 08:46:03.749: [    CSSD][2834](:CSSSC00012:)clssscExit: A fatal error occurred and the CSS daemon is terminating abnormally 2013-09-25 08:46:03.753: […