Re: 10.1.0.3.0...Lots broken.....

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 25 Jun 2005 07:59:14 -0700
Message-ID: <1119711559.759346@yasure>

Fabrizio wrote:
> 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.

Thanks for the update. But here:

SQL*Plus: Release 10.1.0.4.0 - Production on Sat Jun 25 07:58:04 2005

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> desc V$osstat

  Name                                      Null?    Type
  ----------------------------------------- -------- ------------------
  STAT_NAME                                          VARCHAR2(64)
  VALUE                                              NUMBER
  OSSTAT_ID                                          NUMBER

SQL> select count(*) from v$osstat;

COUNT(*)

SQL> All is fine.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Sat Jun 25 2005 - 09:59:14 CDT