STAT Gathering

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jainare
    New Member
    • Aug 2007
    • 1

    STAT Gathering

    Can any one help me to find answer for problems given below.

    1.How to find about the statistics jobs being run on a server.

    2.If it is currently using ANALYZE, how to change it to dbms_stats.

    3.How often the statistics were being run. How to check that the statistics are being run very often than really needed.
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    As you have posted a question in the articles setion it is being moved to Oracle Forum.

    MODERATOR.

    Comment

    Working...