You might want to set it only when you are
troubleshooting.
G!
--- Linda Hagedorn <Linda_at_pets.com> wrote: > Hello,
>
> My searches in Metalink show timed_statistisc=True
> is the recommended
> setting. I'm hearing that some Oracle classes
> recommend keeping
> timed_statistics=False unless you are tracing.
>
> Other than, 'It depends', what do you have your
> statistics set for?
>
> We have SQL_TRACE on all the time. I'd prefer
> having timed_statistics=true
> so I can grep for the total line in a large number
> of tkprof output files,
> and selectively find the long-running transactions.
>
> Any opinions are welcome.
>
> Thanks,
>
> Linda Hagedorn
>
>
> --
> Author: Linda Hagedorn
> INET: Linda_at_pets.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
Received on Fri Aug 18 2000 - 17:14:19 CDT
