OraFAQ Forum: Performance Tuning » why AWR don't collect statistics information?

Home » RDBMS Server » Performance Tuning » why AWR don't collect statistics information?

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

why AWR don't collect statistics information? [message #144992] Sun, 30 October 2005 21:58

Teddyboy
Messages: 8
Registered: September 2005

Junior Member


<?php
SQL> show parameter statistics



NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

statistics_level                     string      TYPICAL

timed_os_statistics                  integer     0

timed_statistics                     boolean     TRUE



SQL> select count(*) from DBA_HIST_SNAPSHOT;



  COUNT(*)

----------

         0



Elapsed: 00:00:00.00

SQL>
?>

please anyone can help me?

regards

teddy

Report message to a moderator

Re: why AWR don't collect statistics information? [message #145077 is a reply to message #144992]

Mon, 31 October 2005 14:58

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

The default snapshot interval in 1 hour - wait 1 hour and try again.

If it doesn't help, check your interval:

SQL> SELECT snap_interval FROM dba_hist_wr_control;

SNAP_INTERVAL
---------------------------------------------------------------------------
+00000 01:00:00.0

Best regards.

Frank

Report message to a moderator

Re: why AWR don't collect statistics information? [message #145267 is a reply to message #145077]

Wed, 02 November 2005 01:47

Teddyboy
Messages: 8
Registered: September 2005

Junior Member

Frank Naude wrote on Mon, 31 October 2005 14:58

The default snapshot interval in 1 hour - wait 1 hour and try again.

If it doesn't help, check your interval:

SQL> SELECT snap_interval FROM dba_hist_wr_control;

SNAP_INTERVAL
---------------------------------------------------------------------------
+00000 01:00:00.0

Best regards.

Frank

SQL> select * from dba_hist_wr_control;

      DBID
----------
SNAP_INTERVAL
---------------------------------------------------------------------------
RETENTION
---------------------------------------------------------------------------
2323471823
+00000 01:00:00.0
+00007 00:00:00.0

the database has running for a long time, but no any awr statistics information.

thanks for your help.

Teddy

Report message to a moderator

Previous Topic:	issue in temporary tablespace
Next Topic:	partition-wise join in different cases

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 17:22:06 CST 2024