Re: INIT.ORA Parameters

On Fri, 16 Jan 1998 08:36:45 -0800, azaman <azaman_at_ibm.net> wrote:

>Hi Everyone
>
>Please help me understand the following two init.ora parameters:
>
> o sql_trace
> o timed_statistics
>
>Questions:
>
>1. Can I set these parameters to TRUE at session level ?

Yes
>
>2. If timed_statistics is set to TRUE and sql_trace set to
> FALSE at instance level , is the system incurring any
> overheads because of timed_statistics being set to TRUE ?

Yes. Timed statistics are still being collected in the database v$ tables even though a trace file is not being generated. The overhead is minimal though. It probably won't effect throughput more than 5%

>
>3. Is this a sensible plan :
> Have timed_statistics set to TRUE and sql_trace set
> to FLASE at instance level.
>
> Only set sql_trace to TRUE at session level if
> required.
>
>I will really appreciate an -email with any information.

We have a performance monitor that requires this very setup. There's a small performanace penalty but it allows the tool to better report on how the database is performing.

--
Chuck Hamilton
chuckh_at_dvol.com

Never share a foxhole with anyone braver than yourself!