ADDM/AWR Reports not loading instance data (24.2.232.4536)

Toad for Oracle - Beta
1

Reports do not work, since no Instance can be selected:

image

The old version runs this query that I don't see with the current beta:

select distinct h.instance_number, h.db_name, p.pdb_name as instance_name
from   CDB_HIST_DATABASE_INSTANCE h, dba_pdbs p
where  h.dbid = :dbid
and    h.dbid = p.dbid
order by 1;
2

Hi Peter,

I don't have any problem running AWR report here.

That exact query only runs if you are connected as sysdba to a pluggable db. But connecting as sysdba is not a requirement to run the report.

Based on the symptoms you're describing (and looking at the code) I suspect there was some error as the window was opening. Maybe connection was lost and then restored? Does closing/reopening the window fix it?

-John

3

Hi John,

I'm connecting to a 19c PDB as a non-SYS user without Oracle client.
Comparing a fresh (thus also new connection) instance of 24.2.232.4536 to 17.1.717.3711.

I had a closer look now, and it seems that the PDB does not get pre-selected here:
image

Once I select the PDB, the instance dropdown gets populated:

----------------------------------
select distinct  instance_number, instance_name
from   sys.DBA_HIST_DATABASE_INSTANCE
where  dbid = :dbid
order by 1;
:dbid(FLOAT,IN)=3339677521

----------------------------------
select snap_interval, retention, topNSQL
from   sys.dba_hist_wr_control
where  dbid = :dbid;
:dbid(FLOAT,IN)=3339677521

It's also interesting the the new beta does not show the DB type which might be related:
image

It looks like this in the previous release:
image

Thanks, Peter

4

Hi Peter,

I found the problem and will fix. The changes were not intentional.

Thanks for reporting it.

-John

1 Like