OraFAQ Forum: Unix

Home » Infrastructure » Unix » smon (AIX 5.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

smon [message #312797]

Wed, 09 April 2008 15:19

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

Report message to a moderator

Re: smon [message #312801 is a reply to message #312797]

Wed, 09 April 2008 16:03

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.

Report message to a moderator

Re: smon [message #317664 is a reply to message #312797]

Fri, 02 May 2008 06:16

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

Report message to a moderator

Re: smon [message #317715 is a reply to message #317664]

Fri, 02 May 2008 13:29

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 14:46:35 CST 2024