Home » RDBMS Server » Performance Tuning » TIMED_STATISTICS parameter
TIMED_STATISTICS parameter [message #267384] Thu, 13 September 2007 02:40 Go to next message
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
Re: TIMED_STATISTICS parameter [message #267423 is a reply to message #267384] Thu, 13 September 2007 04:41 Go to previous messageGo to next message
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.
Re: TIMED_STATISTICS parameter [message #267432 is a reply to message #267384] Thu, 13 September 2007 04:57 Go to previous message
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.
Previous Topic: How to rebuild indexes
Next Topic: AWR report
Goto Forum:
  


Current Time: Tue Dec 06 15:54:22 CST 2016

Total time taken to generate the page: 0.06552 seconds