ROOTVG - AIX & POWER Portal

Tracking the files and sockets of an Oracle process

Home

Help

Login

Register

	Welcome, Guest. Please login or register.	January 09, 2009, 11:21:10 PM
		Login with username, password and session length

ROOTVG > AIX > Administration > Tracking the files and sockets of an Oracle process

Pages: [1] Go Down

« previous next »

Print

	Author	Topic: Tracking the files and sockets of an Oracle process (Read 636 times)
0 Members and 1 Guest are viewing this topic.

Michael

Administrator
Hero Member

Posts: 539

Re: Tracking the files and sockets of an Oracle process

« Reply #1 on: September 20, 2007, 05:56:37 PM »

Depending on how Oracle is running, you could try the command P (capital P) to the topas Process page (just type h for help).

If you need something other, different, better, etc. look for nmon.

p.s. I assume you mean 5.3 TL04 (oslevel -s and oslevel -r give the best indication. Note: they should both be saying the same roughly the same thing. If not you are missing one or two filesets.)


« Last Edit: September 20, 2007, 05:58:14 PM by Michael »	Logged

Jim

Full Member

Posts: 16

Tracking the files and sockets of an Oracle process

« on: September 20, 2007, 04:19:33 PM »

We just implemented a new ERP system, running Oracle 10g on AIX 5.3.4.
Using topas, I am keeping an eye on overall system load and resources, and when an Oracle process climbs way up above the others (over 20% cpu sometimes) I would like to trace back to which network connection and/or which files this process has open.
Does anyone know of a way to do this with AIX commands/resources or Oracle tools - either Spotlight or OEM?

Thanks,
Jim