Operating System - HP-UX
1834568 Members
3624 Online
110069 Solutions
New Discussion

Re: How to differentiate oracle applications from UNIX side?

 
Zhang Zhao gui
Frequent Advisor

How to differentiate oracle applications from UNIX side?

I need to find out which processes belong to which oracle applications. But
all I got from "ps -ef" and
the accounting data through acctcom are shown as "oracle" in terms of User IDs
and command names. Let's
assume there are a number of Oracle applications like
"AP", "AR", "Finance", "Purchase&Store", how can I categorize all oracle
processes into these different
application groups so that I can find out how much resources(CPU,MEM,DISK
usages) each application consumed ? Usually I can get resource usage from raw
accounting data via "/usr/lib/acct/acctcom", but don't know how to
differentiate them. Anybody got any
idea?
1 REPLY 1
Anthony Goonetilleke_1
Regular Advisor

Re: How to differentiate oracle applications from UNIX side?

There are tools that can be used within Oracle to get instance data of the
various systems resources used within the machine (cpu/memory/io etc) these are
then stored in an Oracle table and can be pulled out for each instance i.e HR,
finance etc. put this info together with measureware and you have your answer.