No graphs in Cloud Control - Top Activity

This morning I had no graphs in my Top Activity on Cloud Control 12.1.0.2. Very strange, but cleaning the history of the browser (Chrome) with Ctrl-Shift-Del worked for me...
    

Hope this fixes your problem if you have it too.

Report with backups - created from Grid Control

Today I wanted to create a report from Enterprise Manager Grid Control 11g. We have about 40 databases here (mixed, 9i/10g/11g). I would like to have a daily report of the last database backup date.

The view SYSMAN.MGMT$HA_BACKUP provides a very usefull report for backups. But there is a drawback it seems.

For 9i databases most columns are null (start_time, end_time, status, output_bytes_display etc.). So there is no usefull information on these databasebackups for 9i database (9.2.0.8 to be precise).

Enterprise Manager 12c overview

I've been to a demo-day in Hilversum. Really cool stuff. 
This movie will give a short overview of EM12c:

Flashback package source in Oracle 9.2

A developer came to me that he messed up his package source he was working on.

He asked me if we could retrieve it from backup, preferable from an hour ago. This is typical a flashback scenario, but he was working on 9.2. Is this a problem? No, we can use Flashback Query in 9.2. We just have to query the dba_source view.

The database (development) is not running in archivemode, so we can flash back to any point within the redo logs. This time we flash back to about half an hour ago.

The output is saved in a spool file.

ALTER SESSION 
   SET NLS_TIMESTAMP_FORMAT = 
   'DD-MON-YYYY HH24:MI:SS.FF3';

set lines 9999

set trimspool on

set pages 9999

set heading off

spool old_version.sql

select text from dba_source  

       as of timestamp to_timestamp('22-SEP-2011 07:30:00.000')

 where owner='SCOTT'

   and name='MYPACKAGE'

 order by type, line;

spool off