When solving tuning problems, session traces are very useful and
offer vital information. Traces are simple and straightforward
for dedicated server sessions, but for shared server sessions, many
processes are involved. The trace pertaining to the user session is
scattered across different trace files belonging to different
processes. This makes it difficult to get a complete picture of the
life cycle of a session.
Now there is a new tool, a command line utility called
trcsess to help read the trace files. The trcsess
command-line utility consolidates trace information from selected
trace files, based on specified criteria. The criteria include
session id, client id, service name, action name and module name.
Also note that beginning with Oracle 10g, Oracle Trace
functionality is no longer available. For tracing database activity,
use SQLTrace or TKPROF instead.
The syntax for the trcsess utility is:
trcsess
[output=output_file_name]
[session=session_Id]
[clientid=client_Id]
[service=service_name]
[action=action_name]
[module=module_name]
[trace_files]
where:
- output specifies the file where the output is generated.
When this option is not specified, the standard output is used
for the output.
- session consolidates the trace information for the session
specified. The session Id is a combination of session index and
session serial number.
- clientid consolidates the trace information given client Id.
- service consolidates the trace information for the given
service name.
- action consolidates the trace information for the given
action name.
- module consolidates the trace information for the given
module name.
- trace_files is a list of all trace file names,
separated by spaces, in which trcsess will look for trace
information. The wild card character * can be used to specify
the trace file names. If trace files are not specified, all the
files in the current directory are checked by trcsess.
Once the trace files have been consolidated,
tkprof can be run against the consolidated trace file for
reporting purposes.
|
|
 |
|
Guarantee your Success!
Oracle is the
world's most complex, robust and flexible database, considered
impossible to master without a mentor.
That's why all BC
Oracle trainers are working professionals, experts in Oracle who
share their tips and secrets. |
|
| |
|
Burleson is the American Team
Note:
This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
Oracle forum.
Verify
experience!
Anyone
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
publish
their Oracle
qualifications.
Errata?
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback. Just
e-mail:
 and include the URL for the page.
Copyright ? 1996 - 2012
All rights reserved.
Oracle ?
is the registered trademark of Oracle Corporation.
|
|
