DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: dbms_workload_repository.create_snapshot()

Threaded View

  1. 11-22-2009, 11:40 AM #9
    Rayyah's Avatar
    Rayyah
    Rayyah is offline Junior Member
    Join Date
    Aug 2009
    Posts
    21
    This job is enabled by default

    exec dbms_scheduler.enable('GATHER_STATS_JOB')
    and disable by exec dbms_scheduler.disable('GATHER_STATS_JOB')
    DBA_HIST_WR_CONTROL - To see the snapshot interval and retention period
    dba_hist_snapshot -Display a list of snapshots
    Last edited by Rayyah; 11-22-2009 at 11:52 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width