Members   Search   Help    Register    Login   Home
Home » RDBMS Server » Performance Tuning » BACKUP OF HISTOGRAMS (Oracle 10g)
BACKUP OF HISTOGRAMS [message #410338] Fri, 26 June 2009 07:17 Go to next message
arunprasad_bh
Messages: 30
Registered: June 2007
Member
Hi Is it possible to backup histograms and restore them if need be?

We are thinking of removing histograms that are collected automatically. It may be possible that some histograms that are created on purpose would also be lost.

So exploring backup and restore option.

Arun
Report message to a moderator
Re: BACKUP OF HISTOGRAMS [message #410356 is a reply to message #410338] Fri, 26 June 2009 09:00 Go to previous message
Michel Cadot
Messages: 28996
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
DBMS_STATS.EXPORT_TABLE_STATS

Regards
Michel
Report message to a moderator
Previous Topic:How do you know whether the Index is getting used or not
Next Topic:stale or empty statiscs
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 9 03:31:21 CST 2009

Total time taken to generate the page: 0.44055 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.