Re: How to find out which patches are installed

From: Chuck <chuckh_at_softhome.net>
Date: 27 Feb 2003 16:10:28 GMT
Message-ID: <Xns932F71ABDF5FBchuckhsofthomenet@130.133.1.4>

Marc Eggenberger <marc.eggenberger_at_power.alstom.com> wrote in news:MPG.18c808b499b7e58498969d_at_localhost:

> Hi there.
>
> I had to take over a series of Oracle databases. The problem is there is
> no documentation ... One point I have to take care is that all needed
> patches are installed ... the systems are 8.0.6 and 8.1.7 ... how do I
> find out which patches are installed?
>

Select version from v$instance;

That should show which patch level you are at, though I've found that the 8.1.7.4.6 patch does not update this value. It still shows 8.1.7.4.1. Received on Thu Feb 27 2003 - 10:10:28 CST