Document 436036.1 SQL> connect / as sysdba SQL> oradebug setmypid Oracle 8i / 9i SQL> oradebug dump events <level> /* Level 1 - Dump session group's event settings /* Level 2 - Dump process group's event settings /* Level 4 - Dump system group's event settings (Ie the instance wide events) Oracle 10g / 11g and above SQL> oradebug eventdump <level> /* session - Dump session group's event settings /* process - Dump process group's event settings /* system - Dump system group's event settings(Ie the instance wide events) Note: level needs to be specified in lowercase ! -- OR -- SQL> alter session set events 'immediate eventdump(<level>)'; /* SESSION - Dump session group's event settings /* PROCESS - Dump process group's event settings /* SYSTEM - Dump system group's event settings(Ie the instance wide events)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31439444/viewspace-2672941/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- sqlplus登录数据库报错ORA-12547: TNS:lost contact
- AIX Oracle 11.2.0.4打PSU crsconfig_lib.pm line 11821解决
- Python执行SSH命令通用模板SSH连接状态探测以及钉钉推送
- HP-UX执行Oracle相关命令报错Memory fault(coredump)分析处理
- Python巡检OGG并推送钉钉消息
- kickstart无人值守方式安装Linux 7.6
- ORA-01190使用bbed强制online数据文件
- Oracle 12c RMAN全攻略
- Oracle使用RMAN从Windows迁移数据到Linux
- CentOS 7.6 安装11.2.0.4 RAC
