ITPub博客

很久没写东西了,分享下小小的东西...翻译有点累..概述:*.Oracle使用latches保护数据结构的间歇的,短持续的访问,但是latch不适合保护一些持续时间相对比较长的Resource  db tables.在之中情况下,就要使用lock*....

HEAP DUMP heap name="pga heap"  desc=0xcbc28a0                        &nbsp...

Sessions:           Struct ksusg                    &nb...

Granules:39                               &nb...

三.Oracle内存结构详解三.一 Fixed SGA1.结构及说明: Granule in SGA     |==================| |   Fixed  SGA     |-->Fixed SGA  &nbsp...

 Area #0 `Fixed Size' containing Subareas 0-0                  Total size 00000000001299c8 Minimum Subarea size 000...

(一.五)Memory Areas(内存结构区域)1.PGA*.An Oracle process includes the following memory areas               --一个Oracle进程包(Se...

oradebug dumplistGlobal Area(在SGA中存放)=Fixed(SGA+GSGA,PGA+GPGA,UGA+GPGA)IPC=Shared Global AreaSGA+PGA:在SGA各个pool中的1granule=1extent,1extent=n chunks,在Freelist中单位是bucketsPGA可能类似&nbs...

Rac Cluster 包括常规的几个参数:(单位是s)其中有diagwait:                --集群的对话时间 limitationreboottime:  &...

Example of Redo:CHANGE #3 TYP:0 CLS: 1 AFN:4 DBA:0x01000d44 OBJ:43810 SCN:0x0000.00299b74 SEQ:  1 OP:10.2index redo (kdxlin):  insert leaf row       &nbsp...

----------11(Row Operarion)---------------Opcode Mnemonic Description11.2   IRP       Insert Single Row11.3   DRP     &n...

(四.六)Direct Load(直接加载)*.If archiving is enabled then direct load blocks are written to redo*.In Oracle 9.2 each block requires a 19.1 and 24.2 change*.直接加载比传统的insert 产生的redo少很多,如...

其实很早就掌握了redo internal,Redo是oracle的灵魂,在此分享下:---------------------------------1.Index Insert 10.2+commit(5.4)2.Index update = 10.4 + 10.2 + commit(5.4)3.Index delete = 10.4 +commit(5....

...*.Relationshin between:                      KGLHD - Handle structure    &nb...

BUCKET 179:  LIBRARY OBJECT HANDLE: handle=3124aee0 mutex=0x3124af94(0)  name=select snap_interval, retention,most_recent_snap_time, most_recent_snap_id, status_flag, most_recent_purge_time,...

 工作也有些年了,晒晒自己的接触的(不管是自己还是人家不愿意的- -)外企:(基本是口语不过关,卑具吧)Telenav(同事去美国了,如果我在的话也去了...卑具不?)IBMHP道富银行还有家做Db研发的公司一家做Liunx...

Oracle internal刚刚研究完,终于对oracle有了个教全面的认识了,可惜...贴不下,分享不来了... 最近听说上家外企的同事去US了,曾经的同事,虽然相处不是很久,毕竟感情还是很深厚的,还记得临走之前给他们搭建的DG...

最近想分享下东西,不过上传不了,看来不好搞了

最近研究buffer cache,希望能和大家交流进步Block header dump:  0x01000d3c Object id on Block? Y seg/obj: 0xae46  csc: 0x00.3dbe12  itc: 2  flg: E  typ: 1 - DATA ...

02:24:14.025115 gettimeofday({1263752654, 25192}, NULL) = 002:24:14.025192 gettimeofday({1263752654, 25193}, NULL) = 002:24:14.025193 gettimeofday({1263752654, 25193}, NULL) = 002:24:14.025193 gettime...