AWR - oracle 10g is not running.. please help
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: AWR - oracle 10g is not running.. please help

  1. #1
    Join Date
    Dec 2007
    Posts
    82

    AWR - oracle 10g is not running.. please help

    Hi,

    there are no awr snapshots and i investigated and found the following.. can you please suggest how to make GATHER_STATS_JOB run frequently?
    SQL> select job_name,STATE,ENABLED, START_DATE from dba_scheduler_jobs;
    JOB_NAME STATE ENABL START_DATE
    --------------- ---------------------------------------------------------------------------
    PURGE_LOG SCHEDULED TRUE 15-FEB-06 03.00.00.100000 AM -01:00
    GATHER_STATS_JOB SCHEDULED TRUE
    SQL> select * from dba_hist_snapshot;
    no rows selected
    DB: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - 64bit
    OS: SunOS 5.8
    thanks in advance

  2. #2
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    Can you tell us what you expecting stats frequency (day,week) and why you need to gather stats frequently?

    Regarding AWR you need to configure it.
    http://www.perf-engg.com
    A performance engineering forum

  3. #3
    Join Date
    Dec 2007
    Posts
    82
    Quote Originally Posted by malay_biswal
    Can you tell us what you expecting stats frequency (day,week) and why you need to gather stats frequently?

    Regarding AWR you need to configure it.
    i need to configure once every hour and kept for 7 days.. the thing is that AWR not taking place in spite of all , could you please provide me solution!

  4. #4
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    Last edited by malay_biswal; 10-13-2008 at 08:33 AM.
    http://www.perf-engg.com
    A performance engineering forum

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