Re: Oracle performance monitoring
From: Christian Metzler <cme_at_magnet.at>
Date: 1995/12/22
Message-ID: <2531913694.2110117_at_magnet.at>#1/1
Date: 1995/12/22
Message-ID: <2531913694.2110117_at_magnet.at>#1/1
> Re: Oracle performance monitoring
You can also use the Oracle tkprof utilitity to watch performance at
statement level.
First you have to set the parameter: 'sql_trace=true' in your init.ora file.
Then you can analyze the generated trace files with tkprof, which gives you
detailed information on how long it took to parse,fetch or execute the sql
statements.
chris
cme_at_magnet.at
Received on Fri Dec 22 1995 - 00:00:00 CET