Oracle-L: DBMS_STATS vs. analyze

From: <rgaffuri_at_cox.net>
Date: Tue, 06 May 2003 06:52:02 -0800
Message-ID: <F001.00590FB6.20030506065202@fatcity.com>

This is an old and probably stupid question, but Im on a new project and they are using Analyze. Im trying to get them to switch to DBMS_STATS please let me know if my argument is correct. Need to be able to articulate this adequately.

DBMS_STATS is faster
the statistics gathered are better
you can use histograms and I believe I may have identified some areas where they would be appropriate.

anything I missed? Ive pointed them to asktom also. Any other good sources to point them to?

My career path and Oracle?

Hello Gurus,

I've been wondering about something, at best this can be dangerous :-) Is anyone else been doing some serious career path evaluation?

I have been wondering seriously about the future of Oracle, I don't know if it is just my imagination but Oracle's market share seems to be dwindling rapidly, both on the small to medium enterprise but also in the high end enterprise scope. I think someone on this group mentioned the other day that Oracle's revenues and market share base was begin held up by existing customers, and was not experiencing any noteworthy growth in new customers.

Lets face it Oracle is pricing itself out of the market, DBs like MSSQL, MySQL and Postgresql are beginning to out price it BIG time. Many of these DBs are beginning to add features to their feature lists that equal Oracles.

Am I the only one who is wondering if re-skilling now while I can and still have a job, should be a serious consideration for this years career planning?

Please share your views. I would love to hear how some of you feel on this subject.

Regards
Denham Eva
Oracle DBA

DISCLAIMER

This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks.

Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity.

This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <rgaffuri_at_cox.net
  INET: rgaffuri_at_cox.net

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).

Received on Tue May 06 2003 - 09:52:02 CDT