Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 10.1.0.3.0...Lots broken.....
oracle_man wrote:
> Here is one of the basic problem: ADDM is broken(maybe just for my
> platform AMD64,RHEL)
>
> Running the ADDM analysis on the specified pair of snapshots ...
>
> begin
> *
> ERROR at line 1:
> ORA-13711: Some snapshots in the range [1945, 1946] are missing key
> statistics.
> ORA-06512: at "SYS.PRVT_ADVISOR", line 1283
> ORA-06512: at "SYS.DBMS_ADVISOR", line 190
> ORA-06512: at line 27
>
Got the same problem on different platform (10.1.0.4 on linux x86), opened a tar and they filled a new bug (4428367).
It seems the V$OSSTAT is not updated correctly (try a select * from V$OSSTAT and see if no rows are returned).
ADDM stopped working suddenly (without apparent reasons) then came back to life last sunday when I had to shut the database down for maintenance.
Tar is still open and assigned to development.
-- Fabrizio Magni fabrizio.magni_at_mycontinent.com replace mycontinent with europeReceived on Sat Jun 25 2005 - 00:21:52 CDT