oracle启动pmon,oracle 11g pmon工作内容系列三

59 阅读 0 评论 39 点赞

我是靠谱客的博主还单身舞蹈，最近开发中收集的这篇文章主要介绍oracle启动pmon,oracle 11g pmon工作内容系列三，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

结论

1,oradebug dump errorstack 4，可以跟踪pmon的工作内容

2，从上述的TRACE FILE可知有清除进程本身资源的操作，即清除PsO，进程状态对象

fd=/proc/self/fd/8 File=/oracle/product/11.2.0/db_1/dbs/lkinstguowang (deleted)

2015-11-01 22:03:06.576879 :8016E390:diag_uts:dbktb.c@716:dbktbDefaultBucketFree(): process state object being deleted; switched to private bucket

2015-11-01 22:24:16.725104 :80227F92:diag_uts:dbktb.c@716:dbktbDefaultBucketFree(): process state object being deleted; switched to private bucket

2015-11-02 04:22:12.519252 :80D595BD:diag_uts:dbktb.c@716:dbktbDefaultBucketFree(): process state object being deleted; switched to private bucket

2015-11-02 04:35:34.461716 :80DD430B:diag_uts:dbktb.c@716:dbktbDefaultBucketFree(): process state object being deleted; switched to private bucket

2015-11-02 04:51:10.259771 :80E5C6B8:diag_uts:dbktb.c@716:dbktbDefaultBucketFree(): process state object being deleted; switched to private bucket

2015-11-02 05:21:44.279344 :80F64EE0:diag_uts:dbktb.c@716:dbktbDefaultBucketFree(): process state object being deleted; switched to private bucket

2015-11-02 05:54:21.974978 :81070F34:diag_uts:dbktb.c@716:dbktbDefaultBucketFree(): process state object being deleted; switched to private bucket

3，errorstack可以跟踪各个ORACLE进程，且级别可以指定

4, 即可以结合oradebug errorstack及10246从不同维度分析pmon的工作内容

5，分析一个事物，要从多个方面来分析，即需要不同的工具，还要进一步扩宽思路，掌握能力

6,errorstack产生的TRACE FILE内容非常多，有空再研究下

测试

1,数据库版本

SQL> select * from v$version where rownum=1;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

2，获取PMON信息

SQL> select pname,pid,spid from v$process where pname='PMON';

PNAME PID SPID

---------- ---------- ------------------------------------------------

PMON 2 10556

3，测试会话信息

SQL> SQL> select addr,pid,spid from v$process where addr=(select paddr from v$session where sid=(select sid from v$mystat where rownum=1));

ADDR PID SPID

---------------- ---------- ------------------------------------------------

00000000DD636140 150 4160

SQL> select sid,serial# from v$session where sid=(select sid from v$mystat where rownum=1);

SID SERIAL#

---------- ----------

343 8273

4,oradebug dump errorstack 4分析pmon

SQL> oradebug setospid 10556

Oracle pid: 2, Unix process pid: 10556, image: oracle@seconary (PMON)

SQL> oradebug dump errorstack 4

Statement processed.

5,kill 死测试会话

kill -9 4600

6，查看PMON的TACE文件

SQL>

oradebug tracefile_name

/oracle/diag/rdbms/guowang/guowang/trace/guowang_pmon_10556.trc

--释放BUFFER CACHE占用的资源

[oracle@seconary trace]$ more /oracle/diag/rdbms/guowang/guowang/trace/guowang_pmon_10556.trc|grep -i --color delet

2AC1458CC000 4E204F44 4420544F 54454C45 524F2045 [DO NOT DELETE OR]

uword ksosp_alloc_where_delete1_ [0600107D8, 0600107DC) = 000001F2

uword ksosp_lat_where_delete1_ [060010908, 06001090C) = 00000204

uword ksosp_lat_where_delete2_ [060010910, 060010914) = 00000205

uword ksirsoDeleteWhere00_ [060010B88, 060010B8C) = 0000020C

uword ksirsoDeleteWhere01_ [060010B90, 060010B94) = 0000020D

uword ksirsoDeleteWhere02_ [060010B98, 060010B9C) = 0000020E

uword ksirsoDeleteWhere03_ [060010BA0, 060010BA4) = 0000020F

uword ksirsoDeleteWhere04_ [060010BA8, 060010BAC) = 00000210

uword ksirsoDeleteWhere05_ [060010BB0, 060010BB4) = 00000211

uword ksirsoDeleteWhere06_ [060010BB8, 060010BBC) = 00000212

uword ksirsoDeleteWhere07_ [060010BC0, 060010BC4) = 00000213

uword ksirsoDeleteWhere08_ [060010BC8, 060010BCC) = 00000214

uword ksirsoDeleteWhere09_ [060010BD0, 060010BD4) = 00000215

uword kfelsoDelete_ [060048658, 06004865C) = 000013FB

uword kgqbt_latch_delete_ [060007BF4, 060007BF8) = 00000F3F

uword kgs_delete_where_ [060007E98, 060007E9C) = 00000F80