Re: /usr/ucb/ps in hp unix

I typically use the tool interactively, but I know it has a recording 
option and can run in the background. 
Maybe this link will help.
http://docs.hp.com/en/5971-2523/apas02.html









arun chakrapani rao <arunrao_oradba@xxxxxxxxxxx> 
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
06/07/2005 12:53 PM
Please respond to
arunrao_oradba@xxxxxxxxxxx


To
oracle-l@xxxxxxxxxxxxx
cc

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=`echo $p|cut -d: -f1`
c=`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= $c '
"USR_M/C_OSUSR_SQLADDR_PROG_CPU"  from v\$session a,v
\$process b, v\$session_wait c  where a.PADDR=b.addr
and  a.sid=c.sid and b.spid=$r;
exit;
EOF
done


--- KATHERINE_KAYLOR@xxxxxxxxxx wrote:

> Try Glance.  It comes with the HP9000 series. 
> 
> 
> 
> 
> 
> 
> 
> arun chakrapani rao <arunrao_oradba@xxxxxxxxxxx> 
> Sent by: oracle-l-bounce@xxxxxxxxxxxxx
> 06/07/2005 12:26 PM
> Please respond to
> arunrao_oradba@xxxxxxxxxxx
> 
> 
> To
> oracle-l@xxxxxxxxxxxxx
> cc
> 
> Subject
> /usr/ucb/ps in hp unix
> 
> 
> 
> 
> 
> 
> 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
> 
> 
> 
> 
> 
> 
>
__________________________________________________________
> 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
> 
> 
>
*************************************************************************************************
> The following message has been automatically added
> by the Internet mail 
> gateway 
> to comply with Royal & SunAlliance IT Security
> Policy.
> 
> "This e-Mail has arrived via the Internet and,
> therefore, you should be 
> cautious 
> about its origin and content.  Replies which contain
> sensitive information 
> or 
> legal/contractual obligations are particularly
> vulnerable.  In these cases 
> you should
> not reply unless you are authorized to do so."
> 
> 
> If you have any questions, please speak to your
> local desktop support team 
> or IT 
> security contact.
> 
>
*************************************************************************************************
> 
> 
> 
> 
>
***********************************************************************************
> Notice of Confidentiality 
> 
> This transmission (including attachments) contains
> information that 
> may be privileged, confidential and protected from
> disclosure. Unless 
> you are the intended recipient of the message (or
> authorized to receive 
> it for the intended recipient) you may not copy,
> forward, or otherwise 
> use it, or disclose it or its contents to anyone. If
> you received this 
> transmission in error please notify us immediately,
> permanently delete 
> the transmission(including attachments) from your
> system, and destroy 
> all hard copies.  Thank you.
> 
> 
> Email: security_usa@xxxxxxxxxx
>
***********************************************************************************
> 
> 



 
_______________________________________________________
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


*************************************************************************************************
The following message has been automatically added by the Internet mail 
gateway 
to comply with Royal & SunAlliance IT Security Policy.

"This e-Mail has arrived via the Internet and, therefore, you should be 
cautious 
about its origin and content.  Replies which contain sensitive information 
or 
legal/contractual obligations are particularly vulnerable.  In these cases 
you should
not reply unless you are authorized to do so."


If you have any questions, please speak to your local desktop support team 
or IT 
security contact.

*************************************************************************************************




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

Other related posts: