On 2/23/06, Tanel Põder <tanel.poder.003_at_mail.ee> wrote:
>
> If you've got your alert log you could grep it for the version string and
> see when the first startup using new software version was done.
>
> Otherwise, this might help to detect last change to dba_registry:
>
> select comp_id, version,status, modified from dba_registry;
> Tanel.
>
>
>
> >
> >
> Assuming 'catpatch' (and hence catalog / catproc) was run, you could get a
good idea from looking at the LAST_DDL_TIME for some/all of the objects
owned by SYS
hth
Connor
--
Connor McDonald
===========================
email: connor_mcdonald_at_yahoo.com
web: http://www.oracledba.co.uk
"Semper in excremento, sole profundum qui variat"
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 22 2006 - 18:50:54 CST
