OraFAQ Forum: Performance Tuning

Thu, 17 May 2007 07:42

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.

Thu, 17 May 2007 08:59

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Fri, 18 May 2007 11:55

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;)

Fri, 18 May 2007 12:02

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Where Oracle says that?
Post a link.

Regards
Michel

Fri, 18 May 2007 12:56

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

Fri, 18 May 2007 13:00

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

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: Mon Oct 06 11:53:54 CDT 2025