OraFAQ Forum: Security » Tracking down a user

Home » RDBMS Server » Security » Tracking down a user

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Tracking down a user [message #257131]

Tue, 07 August 2007 11:16

DriveShaft
Messages: 20
Registered: August 2007

Junior Member

I'm running Oracle Database 10g Release 10.2.0.1.0 on Linux ES4

Every other day, the CPU on the linux box goes to 100% and the process that is taking all the cpu shows to be....

oraclep1 (LOCAL=NO)

This only happens on one node of the RAC and it is the same node every time.

In order to get the server and database back to being responsive we kill the process and all is better.

My question is, how would I go about tracking down the user that is causeing all this?

Thanks,
Billy Bob

Report message to a moderator

Re: Tracking down a user [message #257133 is a reply to message #257131]

Tue, 07 August 2007 11:18

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

What you want to track CPU time ?
Or user activities on DATABASE SERVER like (DML/DDL)?

Report message to a moderator

Re: Tracking down a user [message #257157 is a reply to message #257131]

Tue, 07 August 2007 12:06

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ps gives you pid
pid that you find in v$process.spid
you join with v$session on v$session.paddr=v$process.addr
then you get session id (v$session.sid), Oracle user name (v$session.username), OS user name (v$session.osuser).

Regards
Michel

Report message to a moderator

Re: Tracking down a user [message #257164 is a reply to message #257157]

Tue, 07 August 2007 12:29

DriveShaft
Messages: 20
Registered: August 2007

Junior Member

Thanks Michel....I think that is what I am looking for. I'm a newbie to Oracle and still trying to figure out little tricks.

I'm basically just trying to figure out who is causing the load and what they are doing.

I have been killing the process right away as soon as its discovered in order to bring the database back to responsive state, which limits my time to figure out what they are doing. Which leaves me trying to figure out what they WERE doing rather that what the ARE doing.

Report message to a moderator

Previous Topic:	How can I attach FGA to a schema?
Next Topic:	Password file (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 08:19:02 CST 2024