-
编辑 删除
ORA-04031
What is an ORA-04031 Error?The memory pool in the SGA are comprised of memory chunks in various sizes. When the database starts is started, you have a large chunk of memory allocated in the various p...
-
编辑 删除
shared pool 结构
The SGA is comprised of fixed areas like the Log Buffers and the Buffer Cache(s) as well as memory pools (Shared Pool, Large Pool, Java Pool, and in 10g, the Streams Pool). Memory ...
-
编辑 删除
goldengate oracle to mysql配置
extract的mgr参数：PORT 7809DYNAMICPORTLIST 7840-7850添加提取进程：add extract exttmy,sourceistable exttmy参数：extract exttmyuserid gg,password ggrmthost 192.168.6.12, mgrport 7809 rmttask re...
-
编辑 删除
Bug 4369756 - Log apply may dump [krvsmso]
Sat Dec 4 04:05:58 2010Errors in file /u01/app/oracle/admin/xxaadb/bdump/xxaadb_p012_549.trc:ORA-07445: exception encountered: core dump [krvsmso()+1379] [SIGSEGV] [Address not mapped to objec...
-
编辑 删除
cache buffer chain latch
-
编辑 删除
索引的row lock wait
一个session 无法产生索引的row lock wait Insert 也不会产生表的row lock wait，因为表块不会分裂在索引块分裂的同时往索引块里插入数据，会发生index的row lock wait比如session a的第10个块正在进行块分裂...
-
编辑 删除
索引块分裂
索引和表的itl 是完全不同的，如果表没有空闲空间创建itl并且itl使用完，则发生itl 等待。索引块如果没有空闲空间创建itl，会发生索引块分裂，将一个索引块分裂为2个，而不发生itl 等待。 试验；1，创建表...
-
编辑 删除
cache buffer chains。trace文件
对lms进程做了个trace发现很多cache buffer chains latch waitWAIT #0: nam='latch: cache buffers chains' ela= 65 address=52915195616 number=122 tries=0 obj#=-1 tim=1253410761813115WAIT #0: nam='latch: c...
-
编辑 删除
读懂trc文件db file scattered read
WAIT #1: nam="db file scattered read" ela= 5 p1=4 p2=1435 p3=25 WAIT #1: nam="db file scattered read" ela= 7 p1=4 p...
-
编辑 删除
rac进程evmd
The third component in OCS is called Event Management Logger. Event Management logger also runs as daemon process ‘evmd’. The daemon process ‘evmd’spawns a permanent child process called ‘evmlogg...
-
编辑 删除
rac进程 ocssd
Oracle Cluster Synchronization Services Daemon (ocssd) is the component, which provides the synchronization services between the nodes. OCSSD provides the access to the node membership. It also enable...
-
编辑 删除
rac进程 crsd
crsdCRSd manages the resources like starting and stopping the services and failing-over the application resources. It spawns separate processes to manage application resources. CRS daemon has two m...
-
编辑 删除
锁与锁等待
当一个表被update，insert 或者delete 操作这个表被锁了，表的一个行，只能有一个tx锁。如果锁不释放，如果其他session也再update 该行，则发生锁等待，在oltp系统里，session 就得不到释放，容易造成session 爆满的...
-
编辑 删除
ITL与pctfree
某些生产系统ITL 的等待比较多。dba_tables 中INI_TRANS参数默认值为1,这个参数是不生效的，实际默认情况每个ini_trans为2就是每个块中默认有两个事物槽，如果该块有update或者delete等操作，通过ITL，去更新undo...
-
编辑 删除
x$bh
select owner,object_name,object_type from dba_objects where data_object_id in (select obj from x$bh where hladdr in (select addr from (select addr from v$latch_children where name='cache b...
-
编辑 删除
调整sar 取样时间
编辑文件/etc/cron.d编辑sysstat[root@slave-report1 cron.d]# more sysstat# run system activity accounting tool every 10 minutes*/1 * * * * root /usr/lib64/sa/sa1 1 1
-
编辑 删除
查看临时表空间使用情况
select (sum (blocks))*8/1000 "MB",sql_id from v$sort_usage group by sql_id; 根据sql_id select sql_text from v$sqltext where sql_id='xxxx' group by piece;
-
编辑 删除
通过trace文件判断锁的对象
数据库遇相关锁的报错DUMP LOCAL BLOCKER/HOLDER: block level 5 res [0x5120013][0x3cd2],[TX]----------resource 0x0xbc4c96528----------------------resname : [0x5120013...
-
编辑 删除
不同路径创建dg注意问题
1，spfile 里的*.log_file_name_convert='+DATA/oradata/jiebin/','/u02/oradata/jiebin/'2 create standby controlfile as 'xxx'3将standby control file 传过来后，从库的控制文件mount后，将会自动改变数据文件...
-
编辑 删除
基于scn 增量
基于scn 的增量备份：rman 读当前系统数据块的scn ，假如当前系统的scn 大于或等于设定scn ，则备份。 关于基于scn 的增量，可以做from scn 即备份大于或等于设定scn 的...
