OraFAQ Forum: Server Administration » AWR - oracle 10g is not running.. please help (2 threads merged by bb)

Home » RDBMS Server » Server Administration » AWR - oracle 10g is not running.. please help (2 threads merged by bb)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

AWR - oracle 10g is not running.. please help (2 threads merged by bb) [message #352981]

Fri, 10 October 2008 06:59

mdvreddy
Messages: 17
Registered: November 2007
Location: x

Junior Member

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

thanks in advance

Report message to a moderator

Re: AWR - oracle 10g is not running.. please help [message #352985 is a reply to message #352981]

Fri, 10 October 2008 07:07

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Why this question is posted in "Text & interMedia" forum?

please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Regards
Michel

Report message to a moderator