Oracle DBA – A lifelong learning experience

Using Glance to see Oracle process usage

Posted by John Hallas on December 8, 2009

With a little configuration Glance can be made to show oracle process usage where the processes are grouped by SID or by user processes or even by applications such as agent usage. This is based on HPUX experience and whilst I know there are Glance ports for other platforms I do not know if they contain the same functionality.

Using Glance select A (for Application) and you see how the applications have been grouped

Then S and select 2 which shows the breakdown of the background processes we have associated with the SID  PGSAWM1A

If we then want to see how many user processes are connected to that SID we select option 5 from the previous screen

We are using various versions of Glance all around the version 4.73 and the functionality seems to work in them all. The key to getting this to work is creating an applications file. Rules are held in a flat file(/var/opt/perf/parm) that can only be modified by the root user. Care should be taken to ensure that the configuration information remains unchanged. Applications are defined as follows

application = <Application Name>
<criteria> = <criteria rules>

Example

application = db_SID1A
file = ora_*SID1A*

In this example an application db_SID1A is defined that consists of all processes matching the file criteria ora_*SID1A*. It is also possible to define a user based criteria (see below) that will consolidate process information based on the owner of the UNIX process.

application = Appworx_User
user = apxprdco

In this example the Appworx_User application consists of all processes owned by the apxprdco user.

As stated above the Application criteria are hierarchical and therefore care needs to be taken to ensure that the application criteria are selective otherwise unexpected results can be obtained.

The file must terminate with a default application (see below) that is already part of the deployed file.

# Note: this generic root user entry should be specified at the end of your
# application definitions, if you choose to keep it, because it will
# pick up all processes owned by root which were not included in preceeding
# application definitions.
application = other_user_root
user = root
About these ads

3 Responses to “Using Glance to see Oracle process usage”

  1. coskan said

    This is cool. Thank you for sharing John.

  2. [...] Hallas gives a lesson on using glance to see Oracle process usage on [...]

  3. [...] John Hallas-Using Glance to see Oracle process usage [...]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 195 other followers

%d bloggers like this: