Databases Reference
In-Depth Information
Janice reviews the file ord_ora_23342.txt and finds that the output is much
easier to interpret. A sample of the output is shown below.
Using statistics from the trace file such as CPU time and elapsed time can help
Janice focus on which of the HR department's SQL statements need tuning.
Oracle provides two websites that can assist the DBA when trouble strikes. MetaLink,
Oracle's trouble reporting site at
http://metalink.oracle.com
, is a subscription
service that allows DBAs to submit problem reports (either online or by phone) and
search the knowledge base of all other problems submitted to Oracle support staff.
Oracle's technology network,
http://technet.oracle.com
, is a free service,
although user registration is required to access the site. Technet contains searchable
product documentation, trial versions of most of Oracle's software, discussion
forums, sample code, white papers, and more.
Terms to Know
alert log file
TKPROF
system trace file
user trace file
