Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2002
    Posts
    78

    Unanswered: Schema Statistics

    Hai

    My database running cbo mode ,but i want schedule to collect statistics automatically at every 4pm ,i successfully submit the job using dbms_job.How to see the "SCH

  2. #2
    Join Date
    Feb 2003
    Posts
    45
    My Octopus is pregnant too !

    The ducks fly backwards over my house ....

    What ?

  3. #3
    Join Date
    Dec 2002
    Location
    Netherlands
    Posts
    118

    URGENT!!

    Originally posted by thebap
    My Octopus is pregnant too !

    The ducks fly backwards over my house ....

    What ?
    URGENT!!

    my car broken, fix please

    remi@
    Remi Visser

    Oracle Database Administrator
    (OCP certified 8i)

    Homepage: http://home.remidian.com/

  4. #4
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Thumbs up

    If you are on Windows, create a batch file which will run the SQL script to analyze the schema. The batch and SQL files are below:

    -------------------------------------------------
    set oracle_sid=db02
    sqlplus internal @d:\oracle\scripts\analyze_schema
    -------------------------------------------------


    -------------------------------------------------
    spool d:\oracle\scripts\analyze_schema.log
    exec dbms_stats.gather_schema_stats('SCHEMA_USER', 35, FALSE, 'FOR ALL COLUMNS SIZE 1', 2, 'DEFAULT', FALSE);
    spool off

    exit
    --------------------------------------------------

    Then simpel schedule the batch file with "at" . For UNIX - small changes and cron will do the same for you.


    Hope that helps,

    clio_usa - OCP - DBA


Posting Permissions

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