Home » RDBMS Server » Server Administration » ANALYZE TABLES!!!
ANALYZE TABLES!!! [message #56053] Tue, 04 March 2003 09:52 Go to next message
raman
Messages: 66
Registered: February 2000
Member
Hi

I have approximately 500 tables and would like to analyze each table whether any row chaining/migration occured. I am doing this through 'OEM'.

Is it advisable to do all at a time? Because it stores the specs in data dictionary! Will there be any performance-down issues?

Please give me if there're any dis-advantages.

thankyou
-ramanujam

Report message to a moderator

Re: ANALYZE TABLES!!! [message #56067 is a reply to message #56053] Tue, 04 March 2003 18:45 Go to previous message
Yikaikai
Messages: 2
Registered: December 2002
Junior Member
I think you can use dbms_stats.gather_schema_stats package to do it

Report message to a moderator

Previous Topic: BLOB desing
Next Topic: can`t SETUP oracle8i on win2000 server
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 07:30:49 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.