FAQ
Since oracle seems to be pushing the dbms_stats.gather_stats procedure for
getting table statistics.  Do you run a separate analyze command to find
the number of chained rows since gather stats does not get this value.  Or
are you still using "analyze".



Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional
Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216)
781-4204

Search Discussions

  • Shevtsov, Eduard at Jun 1, 2001 at 1:50 pm
    Hi Jeffrey,


    If you've decided to use dbms_stats, I don't know the reasons to use analyze
    anymore.
    In terms of stored statistics DBMS_STATS will give you the same and a little
    more.
    I mean for example integral statistics for your partition tables. And you
    can analyze tables in parallel


    Regards,
    Ed


    -----Original Message-----
    Sent: 1 ???? 2001 ?. 16:55
    To: Multiple recipients of list ORACLE-L

    Since oracle seems to be pushing the dbms_stats.gather_stats procedure for
    getting table statistics. Do you run a separate analyze command to find the
    number of chained rows since gather stats does not get this value. Or are
    you still using "analyze".




    Jeffrey Beckstrom
    Database Administrator
    Greater Cleveland Regional Transit Authority
    1240 W. 6th Street
    Cleveland, Ohio 44113
    (216) 781-4204

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Shevtsov, Eduard
    INET: EShevtsov_at_flagship.ru

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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).
  • Nuno Souto at Jun 1, 2001 at 2:32 pm
    I use dbms_utility.analyze_schema. Any probs with this
    one that I'm not aware of?

    Cheers
    Nuno Souto
    nsouto_at_nsw.bigpond.net.au
    http://www.users.bigpond.net.au/the_Den
    ----- Original Message -----

    table statistics. Do you run a separate analyze command to find the
    number of chained rows since gather stats does not get this value. Or
    are you still using "analyze".

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Nuno Souto
    INET: nsouto_at_nsw.bigpond.net.au

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------

    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).
  • Mark Leith at Jun 1, 2001 at 2:54 pm
    You could just use:

    analyze table list chained rows;

    This will then store all chained rows in to the CHAINED_ROWS table, with
    their rowid's etc. - You will however have to run the utlchn1.sql file -
    found in Oracle_home/./RBMS/ADMIN on a Win2K box..

    HTH

    Mark

    -----Original Message-----
    Eduard
    Sent: Friday, June 01, 2001 03:00
    To: Multiple recipients of list ORACLE-L

    Hi Jeffrey,

    If you've decided to use dbms_stats, I don't know the reasons to use analyze
    anymore.
    In terms of stored statistics DBMS_STATS will give you the same and a little
    more.
    I mean for example integral statistics for your partition tables. And you
    can analyze tables in parallel

    Regards,
    Ed

    -----Original Message-----
    Sent: 1 ???? 2001 ?. 16:55
    To: Multiple recipients of list ORACLE-L

    Since oracle seems to be pushing the dbms_stats.gather_stats procedure for
    getting table statistics. Do you run a separate analyze command to find the
    number of chained rows since gather stats does not get this value. Or are
    you still using "analyze".

    Jeffrey Beckstrom
    Database Administrator
    Greater Cleveland Regional Transit Authority
    1240 W. 6th Street
    Cleveland, Ohio 44113
    (216) 781-4204

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Shevtsov, Eduard
    INET: EShevtsov_at_flagship.ru

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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.com
    --
    Author: Mark Leith
    INET: mark_at_cool-tools.co.uk

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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).
  • MHately_at_etech-uk.com at Jun 1, 2001 at 3:07 pm
    Hi,
    GATHER_STATS only returns statistics that Oracle considers to be useful to the
    CBO. That doesn't include information on chained rows unfortunately.

    Cheers,
    Mike Hately,
    Oracle DBA

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author:
    INET: MHately_at_etech-uk.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------

    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).
  • Jeffrey Beckstrom at Jun 1, 2001 at 4:34 pm
    from the
    docs, it states it does not compute chained row count.>>>
    EShevtsov_at_flagship.ru 6/1/01 10:00:26 AM >>>Hi Jeffrey,If
    you've decided to use dbms_stats, I don't know the reasons to use
    analyzeanymore.In terms of stored statistics DBMS_STATS will give you
    the same and a littlemore.I mean for example integral statistics for
    your partition tables. And youcan analyze tables in
    parallelRegards,Ed-----Original Message-----Sent: 1 ????
    2001 ?. 16:55To: Multiple recipients of list ORACLE-LSince
    oracle seems to be pushing the dbms_stats.gather_stats procedure forgetting
    table statistics.  Do you run a separate analyze command to find
    thenumber of chained rows since gather stats does not get this value.
    Or areyou still using "analyze".Jeffrey
    BeckstromDatabase AdministratorGreater Cleveland Regional Transit
    Authority1240 W. 6th StreetCleveland, Ohio 44113(216)
    781-4204-- Please see the official ORACLE-L FAQ: http://www.orafaq.com--" rel="nofollow">http://www.orafaq.com">http://www.orafaq.com-- Author:
    Shevtsov, Eduard  INET: EShevtsov_at_flagship.ruFat City Network
    Services    -- (858) 538-5051  FAX: (858) 538-5051San
    Diego, California        -- Public Internet
    access / Mailing

    Lists--------------------------------------------------------------------To

    REMOVE yourself from this mailing list, send an E-Mail messageto:
    ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message
    BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
    you want to be removed from).  You mayalso send the HELP command for
    other information (like subscribing).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJun 1, '01 at 12:04p
activeJun 1, '01 at 4:34p
posts6
users5
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase