Home » RDBMS Server » Enterprise Manager » No data for ADDM (10.2.0.3)
No data for ADDM [message #306454] Fri, 14 March 2008 05:48 Go to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Hi!

A strange thing have happend in one of our DBs. It seems that ADDM have stopped collecting data. So I cant run ADDM. There are no data!

Any ideas on where to start looking?

Regards
Hristo

Report message to a moderator

Re: No data for ADDM [message #306470 is a reply to message #306454] Fri, 14 March 2008 07:34 Go to previous message
mmee
Messages: 38
Registered: July 2007
Member
hi#..

i think your Snapshot Collection is turn off.

you can execute this procedure...(one hour snapshot collection)

SQL> exec DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(10080,60);

PL/SQL procedure successfully completed.


and

also set/CHECK your parameter file statistics_level = "TYPICAL" or "ALL"

WITH REGARDS..

Report message to a moderator

Previous Topic: Local Security Policies
Next Topic: status AGENT UNREACHABLE
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 18:03:58 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.