V$Product_component_version is also a Good Place to Look at for Individual Components. HTH Cheers Ganesh R On Thu, 2 Sep 2004 09:46:57 +0530, pawan.dalmia@xxxxxxxxxxxxxxxxxxx <pawan.dalmia@xxxxxxxxxxxxxxxxxxx> wrote: > V$version is the right place where u can find information about the = Oracle > version fourth number represnt the patch number > for example Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit > Production > above indicates it is patchset 4 for base Release 9.2.. > I am not sure about java version but feel u can find in JAVA_HOME/bin > there is command which or version i am not sure about this > Regards > Pawan Dalmia > Oracle DBA-Business Intelligence > Desk-566 > Cell 9819588788 >=20 > "+ACI-Nguyen, David M+ACI-" <david.m.nguyen@xxxxxx> > Sent by: oracle-l-bounce@xxxxxxxxxxxxx > 09/02/2004 01:34 AM > Please respond to oracle-l >=20 > To: <oracle-l@xxxxxxxxxxxxx> > cc: > Subject: How to check what oracle patches is installed >=20 >=20 > I am running oracle 8.0.5 on solaris8, I need to check what oracle = patches > is installed and if java, JDK software is installed with its version. = How > do I check them? >=20 > V$version is not giving me enough information. >=20 > Thanks, > David > --- To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe To read recent messages - //freelists.org/archives/oracle-l/09-2004