Internals

11g Oradebug Infrastructure (Internal only)

January 2, 2012 11g, Internals, oracle No comments

11g Oracle 加强了oradebug 可以使用oradebug doc命令查看internal trace command,下面简述各种命令的输出,由于是undocumented,所以很多东西有待研究

Contents
ORADEBUG DOC
ORADEBUG DOC E[……]

Read more

Scripts:curheaps.sql

December 17, 2011 Internals, oracle No comments

该script 显示各个cursor占用的heap大小

——————————————————————————–

— File name: curheaps.sq[……]

Read more

模拟一次online redo crash 的恢复

December 7, 2011 Internals, oracle No comments

[oracle@liu dbs]$ sqlplus ‘/as sysdba’

SQL*Plus: Release 10.2.0.1.0 – Production on Wed Dec 7 00:06:50 2011

Copyright (c) 1982, 2005, Oracle. Al[……]

Read more

[转] Oracle 10g RAC中的DRM问题及关闭

December 1, 2011 Internals, oracle, RAC 2 comments

在RAC环境中,Oracle使用GRD(Global Resource Service)来记录各个RAC节点的资源信息,具体通过GCS(Global Cache Service)和GES(Global Enqueue Service)这两个服务进行管理。
由于在RAC中每个节点都有自己的SGA和b[……]

Read more

[转] Know More about Oracle PGA Memory

November 8, 2011 Internals, oracle 9 comments

Question :

1. How can we know available PGA and temporary tablespace before we issue a huge operation?
2. Can we estimate PGA and temporary tables[……]

Read more

data_object_id

October 24, 2011 Internals, oracle 1 comment

xxx_objects.data_object_id differs from object_id after

* truncate table (or alter table truncate partition), unless table/partition is empty
*[……]

Read more

datafile Checkpoint cnt

October 24, 2011 Internals, oracle 2 comments

通过dump datafile header 发现每个Checkpoint cnt不同

大致原因如下:

1.tablespace 建立的时间不同 现在我们新建一个tablespace ->liu datafile->liu01.dbf

DATA FILE #10:
(name #[……]

Read more