ORACLE 11.2 性能调优之03 ( ADR使用 )
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了ORACLE 11.2 性能调优之03 ( ADR使用 ),小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含4352字,纯文字阅读大概需要7分钟。
内容图文
![ORACLE 11.2 性能调优之03 ( ADR使用 )](/upload/InfoBanner/zyjiaocheng/527/3973db789a9446cb952d8f2b978f965a.jpg)
1.开启 adrci
[oracle@xag112 ~]$ adrci
ADR base = "/u01/app/oracle"
adrci> show home
ADR Homes:
diag/rdbms/db112/DB112
diag/tnslsnr/xag112/listener
adrci> set home diag/rdbms/db112/DB112
adrci> show home
ADR Homes:
diag/rdbms/db112/DB112
2.显示所有问题
adrci> show problem
ADR Home = /u01/app/oracle/diag/rdbms/db112/DB112:
*************************************************************************
0 rows fetched
3.显示所有事件
adrci> show incident
ADR Home = /u01/app/oracle/diag/rdbms/db112/DB112:
*************************************************************************
0 rows fetched
4.跟踪alter 日志
#滚动显示 (类似tail -f alertlog一样)
adrci> show alert -tail -f
2020-07-11 19:01:13.365000 +08:00
CJQ0 started with pid=21, OS id=6128
2020-07-11 19:01:16.492000 +08:00
Setting Resource Manager plan SCHEDULER[0x32DE]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Starting background process VKRM
VKRM started with pid=22, OS id=6130
2020-07-11 19:01:19.998000 +08:00
XDB installed.
XDB initialized.
2020-07-11 19:06:12.558000 +08:00
Starting background process SMCO
SMCO started with pid=25, OS id=6175
#显示当前最后10条数据
adrci> show alert -tail
2020-07-11 19:01:13.365000 +08:00
CJQ0 started with pid=21, OS id=6128
2020-07-11 19:01:16.492000 +08:00
Setting Resource Manager plan SCHEDULER[0x32DE]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Starting background process VKRM
VKRM started with pid=22, OS id=6130
2020-07-11 19:01:19.998000 +08:00
XDB installed.
XDB initialized.
2020-07-11 19:06:12.558000 +08:00
Starting background process SMCO
SMCO started with pid=25, OS id=6175
#显示当前最后10条数据
adrci> show alert -TAIL 10
2020-07-11 19:01:13.365000 +08:00
CJQ0 started with pid=21, OS id=6128
2020-07-11 19:01:16.492000 +08:00
Setting Resource Manager plan SCHEDULER[0x32DE]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Starting background process VKRM
VKRM started with pid=22, OS id=6130
2020-07-11 19:01:19.998000 +08:00
XDB installed.
XDB initialized.
2020-07-11 19:06:12.558000 +08:00
Starting background process SMCO
SMCO started with pid=25, OS id=6175
5.在control中设置的保留时间之后的日志
adrci> show control
ADR Home = /u01/app/oracle/diag/rdbms/db112/DB112:
*************************************************************************
ADRID SHORTP_POLICY LONGP_POLICY LAST_MOD_TIME LAST_AUTOPRG_TIME LAST_MANUPRG_TIME ADRDIR_VERSION ADRSCHM_VERSION ADRSCHMV_SUMMARY ADRALERT_VERSION CREATE_TIME
------------- -------------- ------------- -------------------- ----------------- ------------------ --------------- ---------------- ---------------- ----------------- -------------
2949729008 720 8760 2020-07-10 23:19:05 1 2 80 1 2020-07-10 23:19:05
#改trace files保留72小时
adrci> set control (SHORTP_POLICY = 72)
adrci> set control (LONGP_POLICY = 96)
#改incident file保留96小时
adrci> show control
ADR Home = /u01/app/oracle/diag/rdbms/db112/DB112:
*************************************************************************
ADRID SHORTP_POLICY LONGP_POLICY LAST_MOD_TIME LAST_AUTOPRG_TIME LAST_MANUPRG_TIME ADRDIR_VERSION ADRSCHM_VERSION ADRSCHMV_SUMMARY ADRALERT_VERSION CREATE_TIME
------------- -------------- ------------- -------------------- ----------------- ------------------ --------------- ---------------- ---------------- ----------------- -------------
2949729008 72 96 2020-07-11 19:29:53 1 2 80 1 2020-07-10 23:19:05
6.进入OS命令模式
adrci> host
[oracle@xag112 ~]$
[oracle@xag112 ~]$ pwd
/home/oracle
[oracle@xag112 ~]$ exit
exit
adrci>
ORACLE 11.2 性能调优之03 ( ADR使用 )
标签:pwd def *** install RoCE ali param nan sls
本文系统来源:https://www.cnblogs.com/mydb/p/13285140.html
内容总结
以上是互联网集市为您收集整理的ORACLE 11.2 性能调优之03 ( ADR使用 )全部内容,希望文章能够帮你解决ORACLE 11.2 性能调优之03 ( ADR使用 )所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。