RE: /usr/ucb/ps in hp unix
- From: John Kanagaraj <john.kanagaraj@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 7 Jun 2005 10:57:58 -0700
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Khemmanivanh, Somckit
Sent: Tuesday, June 07, 2005 10:48 AM
To: arunrao_oradba@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of arun chakrapani rao
Sent: Tuesday, June 07, 2005 9:53 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxx wrote:
> Try Glance. It comes with the HP9000 series.=20 =20 =20 =20 =20 =20
>=20 =20 arun chakrapani rao <arunrao_oradba@xxxxxxxxxxx>=20 Sent by:
>oracle-l-bounce@xxxxxxxxxxxxx
> 06/07/2005 12:26 PM
> Please respond to
> arunrao_oradba@xxxxxxxxxxx
>=20
>=20
> To
> oracle-l@xxxxxxxxxxxxx
> 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
> --
> //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@xxxxxxxxxx
>
************************************************************************
***********
>=20
>=20
=09
_______________________________________________________
Too much spam in your inbox? Yahoo! Mail gives you the best spam protection
for FREE! http://in.mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
