Home » RDBMS Server » Server Administration » analyze &DBMS_STAT
analyze &DBMS_STAT [message #62536] Tue, 27 July 2004 10:35 Go to next message
ram
Messages: 95
Registered: November 2000
Member
hi
what's the differnece between analyze & dbms_stats
i mean what the advantages of dbms_Stats over analyze
command
ram

Report message to a moderator

Re: analyze &DBMS_STAT [message #62608 is a reply to message #62536] Mon, 02 August 2004 22:29 Go to previous message
Thomas
Messages: 67
Registered: September 1999
Member
DBMS_STATS package is meant to substitude the ANALYZE command. It's more efficient since you can gather the statistics in PARALLEL. It also gathers more accurate statistics, since you can customize the process.

The ANALYZE command should be obsolete soon ...

Hope that helps,

clio_usa - OCP DBA 8/8i/9i

Oracle DBA Resources
Oracle DBA Forums
USENET Oracle newsgroups

Report message to a moderator

Previous Topic: rollback segments
Next Topic: Listener related problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 19 02:27:48 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.