Re: Server tracing

From: Frank <frankbo_at_interaccess.nl>
Date: Mon, 23 Oct 2000 12:29:03 +0200
Message-ID: <8t13tj$61v$1@porthos.nl.uu.net>

It's in the manual, nevertheless:
<quote>
The value of SQL_TRACE disables or enables the SQL trace facility. Setting this parameter to TRUE provides information on tuning that you can use to improve performance. Because the SQL trace facility causes system overhead, you should run the database with the value TRUE only for the purpose of collecting statistics. The value can also be changed using the DBMS_SYSTEM package.

For more information about performance diagnostic tools, see Oracle8 Tuning. See also Oracle8 SQL Reference.
</quote>

--
Frank
CUJimmy <public_at_asd-group.com> schreef in berichtnieuws
8ss80a$5ou$1_at_nnrp1.deja.com...


> Could someone tell me how to enable SQL tracing on an Oracle 8i Server -

> I can't seem to find anything about it in the docs.

>

> Thanks a bunch..

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.

Received on Mon Oct 23 2000 - 05:29:03 CDT