Home » Infrastructure » Unix » smon (AIX 5.2)
smon [message #312797] Wed, 09 April 2008 15:19 Go to next message
talashil
Messages: 8
Registered: April 2008
Junior Member
If I issue ps-aef | grep smon and output is

oracle 1130526 ora_smon_TSTRR
oracle 1163360 ora_smon_IRMD115
oracle 1220632 ora_smon_TEST01

is there a way to know if it is 9i smon ot 10g smon ..

Thanks
Re: smon [message #312801 is a reply to message #312797] Wed, 09 April 2008 16:03 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>is there a way to know if it is 9i smon ot 10g smon
but not very easily.
By querying each of the instances, you can SELECT for the "OS ProcessID".
In each case you'll only ever get back 1 row.
Then you'll know "this version" matches which SID & SMON process.
Re: smon [message #317664 is a reply to message #312797] Fri, 02 May 2008 06:16 Go to previous messageGo to next message
smuqtaderali
Messages: 1
Registered: August 2005
Location: Saudi Arab
Junior Member

select name from V$version will show you the oracle version name and match with your smon output

cheers
Re: smon [message #317715 is a reply to message #317664] Fri, 02 May 2008 13:29 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Never used AIX, but on Solaris, you may get some useful info using:
/usr/ucb/ps -auxeww | grep smon | grep ORACLE_HOME

[Updated on: Fri, 02 May 2008 13:30]

Report message to a moderator

Previous Topic: Oracle 8.1.7.4 on Solaris 10?
Next Topic: Append Option
Goto Forum:
  


Current Time: Fri Mar 29 08:17:23 CDT 2024