Home » RDBMS Server » Performance Tuning » How To Get Previous Version Of Stats Gathered (Oracle,9.2.0.6.0,XP)
How To Get Previous Version Of Stats Gathered [message #321119] Mon, 19 May 2008 02:36 Go to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Dear All,

What are the various methods via i can get
previous version of stats.

DBMS_STATS has the feature via which i can create a
temp table and export and import previous statistics.

Is their any other efficient method available.

Thanks & Regards,
Rajat Ratewal
Re: How To Get Previous Version Of Stats Gathered [message #321129 is a reply to message #321119] Mon, 19 May 2008 03:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.

Regards
Michel
Re: How To Get Previous Version Of Stats Gathered [message #321178 is a reply to message #321129] Mon, 19 May 2008 06:12 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Dear Michel,

Can't we use Export import utility for this.i think
when we use Export utility statistics are also
exported.

Is their any method to specify that only Statistics
will be exported in Export utility command.

Actually i am trying 2-3 approaches via i can achieve
results.

Can, you please guide me on this.

Thanks & Regards,
Rajat Ratewal
Re: How To Get Previous Version Of Stats Gathered [message #321187 is a reply to message #321178] Mon, 19 May 2008 06:35 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Can't we use Export import utility for this.i think
when we use Export utility statistics are also
exported.

Yes but do you want to export the whole table or only the statistics?
For statistics use dbms_stats package.

Quote:
Is their any method to specify that only Statistics
will be exported in Export utility command.

No.

Quote:
Actually i am trying 2-3 approaches via i can achieve
results.

Named them

Regards
Michel

Previous Topic: Find the query running time
Next Topic: Please help tuning SQL
Goto Forum:
  


Current Time: Wed Dec 07 16:20:40 CST 2016

Total time taken to generate the page: 0.08631 seconds