10046 trace show parameter command
1. alter session set events '10046 trace name context forever ';
- Modify the session's session
2. exec dbms_system.set_ev (9,437,10046,8, 'pecker');
- Execution Trace
3. show parameter
- Execute the command
4. exec dbms_system.set_ev (9,437,10046,0, 'pecker');
- End of the track
5. select d.value | | '/' | | lower (rtrim (i.instance, chr (0))) | | '_ora_' | |
p.spid | | '. trc' trace_file_name
from (select p.spid
from sys.v $ mystat m, sys.v $ session s, sys.v $ process p
where m.statistic # = 1
and s.sid = m.sid
and p.addr = s.paddr) p,
(select t.instance
from sys.v $ thread t, sys.v $ parameter v
where v.name = 'thread'
and (v.value = 0 or t.thread # = to_number (v.value))) i,
(select value from sys.v $ parameter where name = 'user_dump_dest') d;
- Access to trace files
6. SELECT NAME NAME_COL_PLUS_SHOW_PARAM,
DECODE (TYPE,
1,
'boolean',
2
'string',
3
'integer',
4
'file',
5
'number',
6
'big integer',
'unknown') TYPE,
DISPLAY_VALUE VALUE_COL_PLUS_SHOW_PARAM
FROM V $ PARAMETER
WHERE UPPER (NAME) LIKE UPPER ('%%')
ORDER BY NAME_COL_PLUS_SHOW_PARAM, ROWNUM;
- Show parameter in this SQL that is executed SQL code in the background
Related Posts of 10046 trace show parameter command
-
Oracle10g ASM database table space maintenance
1. Default naming Oracle when using ASM + OMF management, Oracle distribution file name will automatically create the appropriate file. Our job to create table space can be simplified as follows: A command. The following are the default Oracle naming ...
-
Oracle deadlock related
ORACLE some were killed in the process, the status was set to "killed", but the lock does not release resources for a long time, sometimes it is no way but to restart the database. Now offers a way to solve this problem, that is, in the kil ...
-
ProC will select the data on the two-dimensional array
Examples are as follows: (Over)
-
Turning optimization oracle article
DB_BLOCK_LRU_LATCHES = 6 BUFFER_POOL_KEEP = (BUFFERS: 14000, LRU_LATCHES: 1) BUFFER_POOL_RECYCLE = (BUFFERS: 2000, LRU_LATCHES: 3) ... Note: buffer_pool_buffers = 2000 * 3 +14000 * 1 = 20000 keep the district will once again be used to retain the use ...
-
Oracle10g with cross-platform endian transfer
In Oracle10g, the same endianness the first cross-platform file information Oracle will automatically re-evaluated, the conversion is no longer necessary. We watch the following tests: [oracle @ danaly oradata] $ sqlplus "/ as sysdba" SQL * ...
-
Oracle XDB relax resolve port conflict of 8080
In this paper, carried: http://www.enet.com.cn/article/2008/0306/A20080306175452.shtml Oracle 9i from the start, Oracle includes the installation of the default XDB. After starting the database, Oracle XDB's http service will automatically take u ...
-
An example of the use of TKPROF
First, view and edit parameters SQL> show parameter max_dump_file_size NAME TYPE VALUE ------------------------------------ ----------- --- --------------------------- max_dump_file_size string UNLIMITED SQL> show parameter user_dump_dest NAME TYPE
Leave a Reply