-
编辑 删除
p1Text="name|mode"
ash里的p1 text则SELECT chr(bitand(1415053316 ,-16777216)/16777215)|| chr(bitan...
-
编辑 删除
rebuild online 和drop partition update global indexes
rebuild online 需要双倍空间drop partition update global indexes ，是将索引条目删除，不需要双倍空间，也不会释放索引空间
-
编辑 删除
rac 重建undo
select segment_name,status,tablespace_name from dba_rollback_segs where status not in ('ONLINE','OFFLINE') and tablespace_name='UNDOTBS5'; SEGMENT_NAME------------------------------------------...
-
编辑 删除
ORA-00600: internal error code, arguments: [kcbgcur_9], [335544649],
BEGIN dbms_logstdby.build; END; *ERROR at line 1:ORA-00600: internal error code, arguments: [kcbgcur_9], [335544649], [17], [393216], [131072], [], [], []ORA-06512: at "SYS.DBMS_INTE...
-
编辑 删除
所有进程空闲时，logical dataguard 竟然延时
所有进程空闲时，逻辑库竟然延时select * from v$logstdby_process 2 ; SID &nb...
-
编辑 删除
rac 一个节点log switch 引起其他节点log switch
今天凌晨的第3个节点日志切换，引起其他节点日志切换-rw-r----- 1 oracle oinstall 1066656256 Jan 27 04:49 Arc_3_47431_592235202.arc-rw-r----- 1 oracle oinstall 13001728 Jan 27 04:...
-
编辑 删除
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...
