11g Oracle 加强了oradebug 可以使用oradebug doc命令查看internal trace command,下面简述各种命令的输出,由于是undocumented,所以很多东西有待研究
Contents
ORADEBUG DOC
ORADEBUG DOC E[……]
January 2, 2012 11g, Internals, oracle No comments oradebug
11g Oracle 加强了oradebug 可以使用oradebug doc命令查看internal trace command,下面简述各种命令的输出,由于是undocumented,所以很多东西有待研究
Contents
ORADEBUG DOC
ORADEBUG DOC E[……]
December 17, 2011 Internals, oracle No comments scripts
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[……]
December 1, 2011 Internals, oracle, RAC 2 comments RAC
在RAC环境中,Oracle使用GRD(Global Resource Service)来记录各个RAC节点的资源信息,具体通过GCS(Global Cache Service)和GES(Global Enqueue Service)这两个服务进行管理。
由于在RAC中每个节点都有自己的SGA和b[……]
November 8, 2011 Internals, oracle 9 comments pga
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[……]
October 24, 2011 Internals, oracle 1 comment oracle data
xxx_objects.data_object_id differs from object_id after
* truncate table (or alter table truncate partition), unless table/partition is empty
*[……]
October 24, 2011 Internals, oracle 2 comments oracle data
通过dump datafile header 发现每个Checkpoint cnt不同
大致原因如下:
1.tablespace 建立的时间不同 现在我们新建一个tablespace ->liu datafile->liu01.dbf
DATA FILE #10:
(name #[……]