Home » RDBMS Server » Performance Tuning » faq
faq [message #238334] Thu, 17 May 2007 07:42 Go to next message
kishore_dba
Messages: 21
Registered: March 2007
Location: HYDERABAD
Junior Member
hi all,
what is the purpose of setting the parameter timed_statists= true.

Regards,
Kishore.
Re: faq [message #238346 is a reply to message #238334] Thu, 17 May 2007 08:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.oracle.com/pls/db102/print_hit_summary?search_string=timed_statistics

Regards
Michel
Re: faq [message #238592 is a reply to message #238334] Fri, 18 May 2007 11:55 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Hi
By setting this parameter to true can sometimes produce more accurate statistics for long-running operations.

As per Oracle saying;)
Re: faq [message #238595 is a reply to message #238592] Fri, 18 May 2007 12:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Where Oracle says that?
Post a link.

Regards
Michel
Re: faq [message #238610 is a reply to message #238595] Fri, 18 May 2007 12:56 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Michel Cadot wrote on Fri, 18 May 2007 11:02
Where Oracle says that?
Post a link.

Regards
Michel




http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams215.htm
Re: faq [message #238612 is a reply to message #238610] Fri, 18 May 2007 13:00 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So why not directly posting the link instead of quoting it without the link?

Regards
Michel
Previous Topic: Statspack Report
Next Topic: optimizer mode in oracle 10g
Goto Forum:
  


Current Time: Sun Dec 04 20:57:09 CST 2016

Total time taken to generate the page: 0.10712 seconds