- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle process
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-30-2001 12:51 PM
тАО10-30-2001 12:51 PM
Oracle process
Is there a way to find out stale orcale process or runaway oracle process?? Basically I want to know which oracle process is eating up the resource
Thanks in advance
Rush.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-30-2001 01:07 PM
тАО10-30-2001 01:07 PM
Re: Oracle process
# top
# ps -ef|grep oracle
Regards!
...JRF...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-30-2001 01:09 PM
тАО10-30-2001 01:09 PM
Re: Oracle process
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-30-2001 01:15 PM
тАО10-30-2001 01:15 PM
Re: Oracle process
It's difficult to find a runaway process unless you know about the processes and how they behave. There is nothing like a ps -ef|grep runaway and find the processes.
One way is to use the XPG4 ps with pcpu output and get the processes that have been constantly consuming CPU and then verify whether those processes really needed to be running and then killing them if not. Examples are oracle connections.
UNIX95= ps -e -o "pcpu args" |sort -n |tail -10
gives top ten processes with high cpu utilization. Then you can verify each process and kill the ones that are runaway.
-Sri
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-30-2001 01:37 PM
тАО10-30-2001 01:37 PM
Re: Oracle process
UNIX95= ps -e -o ruser,vsz,pid,args | sort -rnk2 | more
This gives me number of oracle process that are running but I am not able to make out which one is *NOT* required..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-30-2001 07:18 PM
тАО10-30-2001 07:18 PM
Re: Oracle process
live free or die
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-31-2001 05:07 AM
тАО10-31-2001 05:07 AM
Re: Oracle process
However be *very* carefull and do not terminate a process unless you are absolutely sure that it is indeed 'left-over'.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-31-2001 12:05 PM
тАО10-31-2001 12:05 PM
Re: Oracle process
<< This gives me number of oracle process that are running but I am not able to make out which one is *NOT* required..>>
->One way to track is to
run TOP utility and see
which process is *constantly*
on the top five list of processes. Then, do a
ps on those pids to see
how soon their CPU usage time
changes. A process which
takes cpu time rapidly without
seeming to do anything is
a big suspect. You notice
this usually with broken
client connections or
Xwindown emulators run from
the PC, but not closed properly, or broken sql scripts.
To track the process further, take the pid and
check in glance , what
exactly it is doing (system
calls, wait states).
Finally, check with the
owner of the process, before
killing it. There is always
a probability that it is
a valid process.
-raj