exec DBMS_STATS.GATHER_DATABASE_STATS;
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: exec DBMS_STATS.GATHER_DATABASE_STATS;

Hybrid View

  1. #1
    Join Date
    Jul 2001
    Posts
    181

    exec DBMS_STATS.GATHER_DATABASE_STATS;

    when you execute this where is the output displayed..


    Thanks

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    hmm what output, do you know what is used for?!?!?

  3. #3
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    Re: exec DBMS_STATS.GATHER_DATABASE_STATS;

    Originally posted by netbar
    when you execute this where is the output displayed..
    TST: SYS> exec DBMS_STATS.GATHER_DATABASE_STATS;

    PL/SQL procedure successfully completed.

    TST: SYS>
    HTH.

  4. #4
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448

    Re: exec DBMS_STATS.GATHER_DATABASE_STATS;

    Originally posted by netbar
    when you execute this where is the output displayed..


    Thanks
    Hi,
    if you want to monitor the progress of sampling statistics then
    select the last_analyzed-column in dba_indexes/dba_tables.

    Code:
    SELECT count(dt.*) from dba_tables dt where dt.last_amalyzed > TRUNC(SYSDATE);
    Normally the sys-packages do not make an output to console for viewing the progress of an operation;

    Orca

  5. #5
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    Re: Re: exec DBMS_STATS.GATHER_DATABASE_STATS;

    Originally posted by Orca777
    Code:
    SELECT count(dt.*) from dba_tables dt where dt.last_amalyzed > TRUNC(SYSDATE);
    Correction...

    Code:
    SELECT count(*) from dba_tables dt where dt.last_aNalyzed > TRUNC(SYSDATE);
    HTH.

  6. #6
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi, thenks for correction!
    Orca

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width