- 最后登录
- 2015-4-9
- 在线时间
- 114 小时
- 威望
- 334
- 金钱
- 9852
- 注册时间
- 2011-11-16
- 阅读权限
- 60
- 帖子
- 158
- 精华
- 0
- 积分
- 334
- UID
- 94
|
3#
发表于 2013-1-13 01:07:35
- [oracle@localhost ~]$ sqlplus /nolog
- SQL*Plus: Release 10.2.0.1.0 - Production on D??úáù 1?? 12 08:58:50 2013
- Copyright (c) 1982, 2005, Oracle. All rights reserved.
- SQL> conn /as sysdba
- Connected.
- SQL> show parameter dump
- NAME TYPE VALUE
- ------------------------------------ ----------- ------------------------------
- background_core_dump string partial
- background_dump_dest string /u01/app/oracle/admin/song/bdu
- mp
- core_dump_dest string /u01/app/oracle/admin/song/cdu
- mp
- max_dump_file_size string UNLIMITED
- shadow_core_dump string partial
- user_dump_dest string /u01/app/oracle/admin/song/udu
- mp
- SQL> !ls /u01/app/oracle/admin/song/udump
- SQL> alter session set events 'immediate trace name buffers level 3';
- Session altered.
- SQL> !ls /u01/app/oracle/admin/song/udump --第一次是会产生trace
- song_ora_5100.trc
- SQL> !rm /u01/app/oracle/admin/song/udump/* --删 掉
- SQL> !ls /u01/app/oracle/admin/song/udump
- SQL> alter session set events 'immediate trace name buffers level 3';
- Session altered.
- SQL> !ls /u01/app/oracle/admin/song/udump --没有发生trace
- SQL> oradebug setmypid
- Statement processed.
- SQL> oradebug close_trace
- Statement processed.
- SQL> alter session set events 'immediate trace name buffers level 3';
- Session altered.
- SQL> !ls /u01/app/oracle/admin/song/udump
- song_ora_5100.trc
复制代码 |
|