Home » RDBMS Server » Server Administration » need help on issue of updating statistics (8.1.7,win 2003 server)
need help on issue of updating statistics [message #463810] Sun, 04 July 2010 04:28 Go to next message
ultgnp
Messages: 106
Registered: May 2010
Location: Germany
Senior Member
Hi,

Can anyone please let me know if there are any problems with updating statistics? My manager told me that they had big performance issue when they updated the statistics of whole database. Is this a rare case?

I know the advantages of updating statistics,but are there any dis-advantages?


Best Regards,
Atiq

Report message to a moderator

Re: need help on issue of updating statistics [message #463813 is a reply to message #463810] Sun, 04 July 2010 05:28 Go to previous messageGo to next message
halim
Messages: 100
Registered: September 2008
Senior Member
Quote:
I know the advantages of updating statistics


what are they advantages?


Regards
Halim

Report message to a moderator

Re: need help on issue of updating statistics [message #463857 is a reply to message #463813] Sun, 04 July 2010 21:57 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
V8.1.7 RBO does not require or use statistics

Report message to a moderator

Previous Topic: ORA-01033 oracle initialization or shutdown in progress
Next Topic: How to Resize Temp Tablespace
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 19 19:09:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.