1 Reply Latest reply: Dec 6, 2012 1:05 PM by moreajays RSS

    What is the use of dbms_stats.GATHER_SCHEMA_STATS and DBMS_WORKLOAD_REPOSIT

    SShubhangi
      What is the use of dbms_stats.GATHER_SCHEMA_STATS and DBMS_WORKLOAD_REPOSIT ?

      In which condition we do this analysis ?

      Please explain with real time example

      Thanks in adavance,
      Shubhangi
        • 1. Re: What is the use of dbms_stats.GATHER_SCHEMA_STATS and DBMS_WORKLOAD_REPOSIT
          moreajays
          Hi Shubhangi,

          DBMS_STATS package contains various procedure to manage statistics of the DB objects , GATHER_SCHEMA_STATS is one of the DBMS_STATS procedure used to gather current statistics ob the database objects/tables hold by the owner/shema. Statistics are nothing but metadata of the objects , stats gathering populated x$ & v$ view related to objects which helps oracle optimizer to picked up the good execution plan for the sql query

          DBMS_WOKLOAD_REPOSITORY package is used to manage Automatic Workload Repository feature (10g onwards) to manage the database workload snap collection
          the snaps taken using these package help to compare performance of the database over particular time period


          Thanks,
          Ajay More
          http://moreajays.blogspot.com

          Edited by: moreajays on Dec 7, 2012 12:34 AM