OraFAQ Forum: Performance Tuning » TIMED

Home » RDBMS Server » Performance Tuning » TIMED_STATISTICS parameter

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TIMED_STATISTICS parameter [message #267384]

Thu, 13 September 2007 02:40

tanmoy1048
Messages: 133
Registered: June 2007

Senior Member

So far I know, timed_statictics(if true) decreases the performance of database. but if I disable the sql_trace, then is it necessary to make timed_statistics to true???

What will happen if i make it false???

thanx

Report message to a moderator

Re: TIMED_STATISTICS parameter [message #267423 is a reply to message #267384]

Thu, 13 September 2007 04:41

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Did you mean to state that sql_trace decreases performance of the database? Setting timed_statistics to true would have a negligible affect on database performance.

Report message to a moderator

Re: TIMED_STATISTICS parameter [message #267432 is a reply to message #267384]

Thu, 13 September 2007 04:57

tanmoy1048
Messages: 133
Registered: June 2007

Senior Member

sql_trace(true) decreases performance.And I got the solution for timed_statistics. Its important for monitoring and different reports.

Report message to a moderator

Previous Topic:	How to rebuild indexes
Next Topic:	AWR report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 12 03:37:20 CDT 2024