RE: /usr/ucb/ps in hp unix

From: Khemmanivanh, Somckit <somckit.khemmanivanh_at_weyerhaeuser.com>
Date: Tue, 7 Jun 2005 10:47:49 -0700
Message-ID: <65C0D8935651CB4D96E97CEFAC5A12B94445DB@wafedixm10.corp.weyer.pri>

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

Received on Tue Jun 07 2005 - 13:56:39 CDT