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

Other related posts: