| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Need help
Yes, I am talkin about the time it takes. The analyze command takes around 2 mins to esimate statistics of a table with a Million records whereas the dbms_stats package function is merely hanging !!
And besides, Djordje is telling that they nearly take up the same time !! But i am not experiencing anything like that.. Do i have to change any settings to make it run faster ??
-----Original Message-----
Sent: Monday, June 02, 2003 9:40 PM
To: Multiple recipients of list ORACLE-L
Kesh - What do you define as performance?
1. How fast a table is analyzed?
2. The performance of the queries that use the statistics that were
collected?
What Oracle version are you on?
In theory, you can analyze tables when the system load isn't so great. In 9i
you can even have Oracle decide when a table needs re-analyzed so it really
lowers the system requirements.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Monday, June 02, 2003 9:50 AM
To: Multiple recipients of list ORACLE-L
Hi all,
Can anyone tell me which of the following performs better in
collecting statistics of a table:
Analyze command or
Dbms_stats.gather_table_stats
I tried my queries with both the options -- but always Analyze is
out-performing the dbms_stats.
But i read in a document that Dbms_stats performs better !!
Besides I also read that Analyze command will be deprecated from Oracle 9i.
So can anyone tell me why dbms_stats is performing poor... Are there any paramters that need to be set to increase the performace of dbms_stats ?
Thanks in advance.
Regards
Kesh
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jayaram Keshava Murthy (Cognizant)
INET: JKmurthy_at_chn.cognizant.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
 |
 |