OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » new feature of 11g (oracle 10.2.0.1.0 - windows XP)

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

new feature of 11g [message #501732]

Thu, 31 March 2011 00:19

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi All,

please need you's input on below question...

What is the scenario, we should use the new feature of 11g called-Pending Statistics.

Eg:-
EXEC DBMS_STATS.set_table_prefs ('SCOTT', 'EMP', 'PUBLISH', 'false');

Regards:
Muktha

Report message to a moderator

Re: new feature of 11g [message #501742 is a reply to message #501732]

Thu, 31 March 2011 00:50

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Documentation says thatOracle

saving the new statistics as pending allows you to validate the new statistics and publish them only if they are satisfactory.

Report message to a moderator

Re: new feature of 11g [message #501743 is a reply to message #501732]

Thu, 31 March 2011 00:52

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

Senior Member
Account Moderator

Database Performance Tuning Guide
Section 13.3.2 Setting Preferences for Manual Statistics Gathering and following
Section 13.5.1 Pending Statistics and following

Regards
Michel

[Updated on: Thu, 31 March 2011 00:53]

Report message to a moderator

Re: new feature of 11g [message #501753 is a reply to message #501743]

Thu, 31 March 2011 02:06

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi All,

Thanks

Regards
Muktha

Report message to a moderator

Previous Topic:	Identifying proxied user sessions
Next Topic:	How to calculate the number of hash keys

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 06:53:18 CST 2024