Home » RDBMS Server » Server Administration » AWR - oracle 10g is not running.. please help (2 threads merged by bb)
AWR - oracle 10g is not running.. please help (2 threads merged by bb) [message #352981] Fri, 10 October 2008 06:59 Go to next message
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
Re: AWR - oracle 10g is not running.. please help [message #352985 is a reply to message #352981] Fri, 10 October 2008 07:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
AWR - oracle 10g is not running.. please help [message #353004 is a reply to message #352981] Fri, 10 October 2008 08:54 Go to previous messageGo to next message
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

DB: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - 64bit
OS: SunOS 5.8

thanks in advance
Re: AWR - oracle 10g is not running.. please help [message #353351 is a reply to message #353004] Mon, 13 October 2008 08:33 Go to previous messageGo to next message
mdvreddy
Messages: 17
Registered: November 2007
Location: x
Junior Member
no one knows how to solve this?!!.. Sad
Re: AWR - oracle 10g is not running.. please help [message #353548 is a reply to message #353351] Tue, 14 October 2008 02:54 Go to previous message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14211/stats.htm

Take a look in the above and below links

http://www.oracle-base.com/articles/10g/AutomaticSQLTuning10g.php
Previous Topic: How to install oracle 10g software in a windows platform server
Next Topic: A row of table is in which tablespace?
Goto Forum:
  


Current Time: Sat Dec 03 10:16:36 CST 2016

Total time taken to generate the page: 0.15664 seconds