RE: /usr/ucb/ps in hp unix

From: John Kanagaraj <john.kanagaraj_at_hds.com>
Date: Tue, 7 Jun 2005 10:57:58 -0700
Message-ID: <960A9B249C99994AA3C7FCA016A0DA8902AA0A06@ussccem08.corp.hds.com>

Arun, I seem to remember an environment setting that 'switched' the behavior of certain utilities to Berkeley mode - or it may have been a PATH settings. I had exactly the same issue you had and was able to run a 'ps' version that gave me what you are looking for...

This was about 8 years ago and on HPUX 10, so I may be mistaken. Blame it on loss of memory as we all get older, but this is a path worth pursuing.

Regards,
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)  

Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com  

• The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Khemmanivanh, Somckit
Sent: Tuesday, June 07, 2005 10:48 AM
To: arunrao_oradba_at_yahoo.co.in; oracle-l_at_freelists.org Subject: RE: /usr/ucb/ps in hp unix

Try this:

glance -adviser_only -syntax -f sk.out -j 1 -iterations 5 &

more sk.out
YELLOW ALERT 06/07/05 10:37:42 Network Bottleneck probability=3D 80.00% END ALERT 06/07/05 10:37:47 End of Network Bottleneck Alert

man glance for details on the -syntax switch... =20

Thanks!=20
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of arun chakrapani rao Sent: Tuesday, June 07, 2005 9:53 AM
To: oracle-l_at_freelists.org
Subject: Re: /usr/ucb/ps in hp unix

I tried glance
but how do we put this into a flat file or output so that i can used it to link to the database If you have any information on this please let me know thanks for the info Arun This is how i am doing on the sun and linux boxes this fires only when there is a high cpu utilization.

for p in `/usr/ucb/ps auxw|head -10|awk '{print $2":"$3}'|grep -v PID` do r=3D`echo $p|cut -d: -f1` c=3D`echo $p|cut -d: -f2` sqlplus -s / << EOF set heading off; set line 1000 select 'SPID '||b.spid||' with userid '||a.sid||'

is running '||c.event||' his usr,os,m/c,addr,prg is '|| a.username||' '||a.
machine||' '||a.osuser||' '||a.SQL_ADDRESS||'
'||a.program||' CPU=3D $c '

"USR_M/C_OSUSR_SQLADDR_PROG_CPU" from v\$session a,v \$process b, v\$session_wait c where a.PADDR=3Db.addr and a.sid=3Dc.sid and b.spid=3D$r; exit; EOF done

• KATHERINE_KAYLOR_at_rsausa.com wrote:

> Try Glance. It comes with the HP9000 series.=20 =20 =20 =20 =20 =20

>=20 =20  arun chakrapani rao <arunrao_oradba_at_yahoo.co.in>=20  Sent by: 
>oracle-l-bounce_at_freelists.org

> 06/07/2005 12:26 PM
> Please respond to
> arunrao_oradba_at_yahoo.co.in

>=20
>=20

> To
> oracle-l_at_freelists.org
> cc

>=20

> Subject
> /usr/ucb/ps in hp unix

>=20
>=20
>=20
>=20
>=20
>=20

> Hi Gurus,
> in sun solaris we have /usr/ucb/ps auxw which does tells us the top

>cpu,mem and the applications  running  it  but is there any command 
>which is similar in HP  unix.

> the /usr/bin/ps auxw does not give any information or i might be

>wrong in this.

> if anybody has any information please do let me know I have been

>trapping this information on sun and  linking this to the database sid 
>when there is high  cpu, I am planning to do the same on HP.

> thanks in advance
> Arun

>=20
>=20

> =20

>=20

> =20
> =20

>

---

> Free antispam, antivirus and 1GB to save all your messages Only in

>Yahoo! Mail: http://in.mail.yahoo.com

> --
> http://www.freelists.org/webpage/oracle-l

>=20
>=20
>
************************************************************************
*************************

> The following message has been automatically added by the Internet

>mail=20  gateway=20  to comply with Royal & SunAlliance IT Security  
>Policy.
>=20

> "This e-Mail has arrived via the Internet and, therefore, you should

>be=20  cautious=20  about its origin and content.  Replies which 
>contain  sensitive information=20  or=20  legal/contractual obligations 
>are particularly  vulnerable.  In these cases=20  you should  not reply 
>unless you are authorized to do so."
>=20
>=20

> If you have any questions, please speak to your local desktop support

>team=20  or IT=20  security contact.
>=20
>
************************************************************************
*************************
>=20
>=20
>=20

>=20
>

---

---

> Notice of Confidentiality=20

>=20

> This transmission (including attachments) contains information

>that=20  may be privileged, confidential and protected from  
>disclosure. Unless=20  you are the intended recipient of the message 
>(or  authorized to receive=20  it for the intended recipient) you may 
>not copy,  forward, or otherwise=20  use it, or disclose it or its 
>contents to anyone. If  you received this=20  transmission in error 
>please notify us immediately,  permanently delete=20  the 
>transmission(including attachments) from your  system, and destroy=20  
>all hard copies.  Thank you.
>=20
>=20

> Email: security_usa_at_rsausa.com

>

---

---

>=20
>=20

        =09

---

Too much spam in your inbox? Yahoo! Mail gives you the best spam protection for FREE! http://in.mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 07 2005 - 14:08:34 CDT