Home » RDBMS Server » Performance Tuning » gather_fixed_objects_stats
gather_fixed_objects_stats [message #165923] Mon, 03 April 2006 06:17 Go to next message
orant1
Messages: 28
Registered: June 2005
Junior Member
HI,

when should I use procedure gather_fixed_objects_stats,
at database creation or when all data, indexes are imported?
I am doing migration from Oracle 9i to 10g (using export,import)

Thanks

Report message to a moderator

Re: gather_fixed_objects_stats [message #165926 is a reply to message #165923] Mon, 03 April 2006 06:36 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I guess, after everything is done and when the databas is in a normal workload.

Report message to a moderator

Previous Topic: Clearing Blocks from Memory
Next Topic: "db file scattered read" too high and Query going for full table scan-Why ?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 27 08:33:53 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.