|
Enable
tracing in the database help in database tuning. Here is a table which
show the tracing levels and how the tracing could be enabled:
|
Level
|
How
is enabled
|
|
1.1
session
(current session)
|
ALTER
SESSION SET sql_trace = true;
ALTER
SESSION SET TRACEFILE_IDENTIFIER=<TRACEID>;
(See comment a). )
|
|
1.2
session
(another session)
|
select
sid, serial# from v$session where ...
SID
SERIAL#
-----
----------
11
13442
execute
dbms_system.set_sql_trace_in_session (<SID>,
<SERIAL#>, true);
|
|
2.0 database
|
a)
modify init.ora by adding sql_trace = true;
b)
ALTER SYSTEM SET SQL_TRACE = TRUE SCOPE=MEMORY;
(if spfile is used);
|
Comments:
a)
The default name for
a trace files is INSTANCE_PID_ora_TRACEID.trc where:
·
INSTANCE is the name
of the Oracle instance;
·
PID is the operating
system process ID (V$PROCESS.OSPID);
·
TRACEID is a
character string of your choosing.
More information
about this subject (
Enable tracing in the database ) you can get from
www.in-oracle.com
|