ANBOB – Page 58 – 提供综合数据库运维服务与优化方案(不限Oracle MySQL PG GaussDB GoldenDB OceanBase等), 微信/Tel:(+86)134-365-60330

more about session_cached_cursors

2024-05-132012-11-14 by weejar zhang

Session cursor caching does not mean that server process caches the whole SQL area in the PGA.It just means that Oracle does not release the cursor object when the same statement was executed more than 2 times in the same process…

bind variable在11g 中出现Cursor: mutex S

2012-11-232012-11-12 by weejar zhang

今天看到一个案例，从10G升级到11GR2后cpu负载迅速上升，很快达到100%,通过OWI显示出现大量“Cursor: mutex S”事件，mutex S是发生在cursor cache上的序列化mutex

Installing Enterprise Manager Cloud Control 12c r2 Agent on Linux(安装em12c agent)

2016-04-252012-11-07 by weejar zhang

Oracle Management Agent 12c communicates only with Oracle Management Service 12c and not with any earlier release of Enterprise Manager

Installing Enterprise Manager Cloud Control 12c release2 on Linux(安装em12c)

2016-04-252012-11-06 by weejar zhang

EM 12c在安装时和11EM相似，只是增加了Plug-ins 的选择，Plug-ins 和 Connectors做为GRID CONTROLE的扩展并增加了一些非oracle的产品整合为”Cloud”云管理包含DATABASE,Middleware,VM server

skip a transaction in goldengate(跳过一个事务OGG)

2013-09-102012-11-01 by weejar zhang

GGSCI (ggsdb) 1> alter replicat ricme, extrba 84510103
REPLICAT altered.
GGSCI (ggsdb) 3> start ricme

SQL ordered by Version Count and Troubleshooting

2025-06-302012-10-31 by weejar zhang

the cause:
bug,related to name resolution issues, bind buffer length, fine grained access control, cursor invalidation, or any of the other common structural or coding reasons for multiple child cursors

DB_FILE_MULTIBLOCK_READ_COUNT parameter

2012-10-25 by weejar zhang

DB_FILE_MULTIBLOCK_READ_COUNT is one of the parameters you can use to minimize I/O during table scans. It specifies the maximum number of blocks read in one I/O operation during

RMAN-08137: WARNING archived log not deleted, needed for standby or upstream capture process

2024-11-122012-10-23 by weejar zhang

When he tried deleting archivelog manually with RMAN on primary db host, he got following warning:

“归档日志未删除, 因为备用或上游捕获进程需要它”

Memory Notification: Heap size nnnnK exceeds notification threshold (51200K)

2014-03-112012-10-19 by weejar zhang

Memory Notification: Library Cache Object loaded into SGA
Heap size 106084K exceeds notification threshold (51200K)
KGL object name …

know more about dbms_job fails

2012-10-19 by weejar zhang

When job execution fails, the SNP processes attempts to rerun the job one minute later. If this run fails, another attempt is made in two minutes and another in four minutes. The job queue doubles the retry interval until it exceeds the normal execution interval..

goldengate update collisions

2013-09-102012-10-18 by weejar zhang

Total updates 12.00
Total deletes 0.00
Total discards 0.00
Total operations 13.00
Total update collisions 12.00

sqlplus autotrace sql Statistics value全部为0

2012-10-15 by weejar zhang

0 db block gets
0 consistent gets
0 physical reads
0 redo size
0 bytes sent via SQL*Net to client
0 bytes received via SQL*Net from client
0 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
62 rows processed

ora-600 [kcbgcur_9] internal error when ALTER DATABASE ADD SUPPLEMENTAL LOG DATA

2014-01-142012-10-10 by weejar zhang

SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcbgcur_9], [8388681], [25],
[100663296], [33554432], [], [], []

最近出差，至双节后

2012-09-24 by weejar zhang

在公司累脑子，出来奉献点儿体力，顺便也当散散心缓解一下，接了个苦差事，从9月20号开始出差浙江两周，最近也已经跑了几个地方，只是好久没出来，换地后一连一周多了没有晚上睡好觉过，浙江给我的印象是处处在盖楼，处处在铺路，处处在建高架，处处在挖地铁，有钱人多，还有以下资源beautiful scene and beautiful girl… 最近很辛苦，更新要一直到10月9号后了，这段时间从未再沾一下ORACLE.

How to stop or kill datapump jobs?(停止数据泵job)

2012-11-232012-09-17 by weejar zhang

3 begin
4 hdl := dbms_datapump.attach(‘SYS_IMPORT_FULL_03′,’SYSTEM’);
5 DBMS_DATAPUMP.STOP_JOB(hdl,1,0);
6 end;

迁移controlfile 从文件系统到ASM

2012-09-12 by weejar zhang

alter system set control_files=’+DATA/ANBOB/CONTROLFILE/current.260.793738081′,’+DATA/ANBOB/CONTROLFILE/current.261.793738087′,’+DATA/ANBOB/CONTROLFILE/current.276.793737555′ scope=spfile;