梦想有多远

Start dump data blocks tsn: 4 file#: 4 minblk 3 maxblk 3
buffer tsn: 4    数据文件对应的 tablespace 的 number ,这只是dump文件中记录的数据而已,block无此信息
rdba: 0×01000003 (4/3)  datafile 中 block 的地址，标示的第几个 block
scn: 0×0000.00093761  system change number
seq: 0×01 A sequence number incremented for each change to a block at the same SCN
—                        A new SCN is allocated if the sequence number wraps.
—                        同一个SCN影响这个block中的行数大于 254 行就会为这个事务分配一个新的SCN
—                        如下面的操作就可能引起同一个SCN但影响的同一个block 中的行超过254行
—                        “delete from table_name” 
—                        影响的行数(最大254) 是用从 0×01 到 0xfe 表示的
—                        当这个byte 的数据为 0xff 的时候标志这个 block 坏调了—> ora-01578

(全文…)

查找当前在shared pool中被pin住的对象

–1.获得Library Cache Pin等待的对象的信息
–Note: X$KGLOB–[K]ernel [G]eneric [L]ibrary Cache Manager [OB]ject

col KGLNAOWN for a10
col KGLNAOBJ for a20
SELECT addr, kglhdadr, kglhdpar, kglnaown, kglnaobj, kglnahsh, kglhdobj
  FROM x$kglob
 WHERE kglhdadr IN (SELECT p1raw
                      FROM v$session_wait
                     WHERE event LIKE ‘library%’)
ADDR     KGLHDADR KGLHDPAR KGLNAOWN   KGLNAOBJ               KGLNAHSH KGLHDOBJ
——– ——– ——– ———- ——————– ———- ——–
973AA6AC 727BECF0 727BECF0 TAOBAO     CHECK_TAB_COL         902274209 727BEAD8

–2.获得持有等待对象的session信息
–Note:X$KGLPN–[K]ernel [G]eneric [L]ibrary Cache Manager object [P]i[N]s
SELECT a.SID, a.username, a.program, b.addr, b.kglpnadr, b.kglpnuse,
       b.kglpnses, b.kglpnhdl, b.kglpnlck, b.kglpnmod, b.kglpnreq
  FROM v$session a, x$kglpn b
 WHERE a.saddr = b.kglpnuse
   AND b.kglpnmod <> 0
   AND b.kglpnhdl IN (SELECT p1raw
                        FROM v$session_wait
                       WHERE event LIKE ‘library%’)

–3.获得持有对象用户执行的代码
SELECT sql_text
  FROM v$sqlarea
 WHERE (v$sqlarea.address, v$sqlarea.hash_value) IN (
          SELECT sql_address, sql_hash_value
            FROM v$session
           WHERE SID IN (
                    SELECT SID
                      FROM v$session a, x$kglpn b
                     WHERE a.saddr = b.kglpnuse
                       AND b.kglpnmod <> 0
                       AND b.kglpnhdl IN (SELECT p1raw
                                            FROM v$session_wait
                                           WHERE event LIKE ‘library%’)))

http://zhaolinjnu.blog.sohu.com/74567618.html

在oracle 10g，awr将会取代oracle 9i的statpack报表,它可以提供两种形式的报表，一种是html格式，另一种是text文本格式，这里面的html展现形式看起报表来确实比较直观，也可以轻松的跳越,比如说通过sqlid直接就可以跳越到相应的sql文本上！下面通过参考网络上的一些资料，配置awr的过程如下：

–进行相应的授权

CONNECT / AS SYSDBA;
GRANT ADVISOR TO test;
GRANT SELECT_CATALOG_ROLE TO test;
GRANT EXECUTE ON sys.dbms_workload_repository TO test;

(全文…)

1、install  httpd

       tar -xzvf httpd-2.2.4.tar.gz

       cd httpd-2.2.4

       ./configure –prefix=/usr/local/apache –enable-usertrack –enable-cgi –enable-so –enable-mods-shared=all

       make

       make install

2、install cacti

       tar -xzvf cacti-0.8.6j.tar.gz

       mv cacti-0.8.6j /usr/local/watch

3 install rtdtool

.     /configure –prefix=/usr/local/rrdtool

　 　make

　　make install

  (全文…)