find database upgrade dates in AWR

Just a really tiny quick tip. Today I was wondering when exactly we performed upgrades on a particular database. Luckily, there is a view in AWR for that.

SQL> select version, min(startup_time) from dba_hist_database_instance group by version order by 1 desc;

VERSION           MIN(STARTUP_TIME)
----------------- --------------------------
11.2.0.4.0        09-APR-14 07.40.14.000 AM
11.2.0.3.0        16-JAN-13 04.08.53.000 PM
11.2.0.2.0        09-MAY-11 03.35.26.000 PM
10.2.0.4.0        22-JAN-10 01.39.35.000 PM

3 thoughts on “find database upgrade dates in AWR

  1. I think this depends on if you have all that history in your AWR.

  2. Yes, you are absolutely right. But I try to convince everybody that keeping at least a few old AWR snapshots around for as long as possible is a good idea. So in most of “my” systems we keep snapshots of at least a few hours of a certain day each month forever. Like 2-4pm of each first Tuesday in the month.

    This data will allow you to perform queries like the above or look at the performance of a certain SQL statement historically.

  3. I have realized some new items from your web-site about desktops. Another thing I have always presumed is that computers have become an item that each family must have for most reasons. They provide convenient ways in which to organize the home, pay bills, search for information, study, tune in to music and in many cases watch tv programs. An innovative strategy to complete every one of these tasks is a mobile computer. These pc’s are portable ones, small, powerful and convenient.

Leave a Reply

Your email address will not be published. Required fields are marked *