Home » Infrastructure » Unix » Oracle Profile for Unix user
Oracle Profile for Unix user [message #199451] Tue, 24 October 2006 07:42 Go to next message
shyamprabhu
Messages: 2
Registered: October 2006
Junior Member
Hi All,
I am new to this forum. I have a question
regarding Oracle profile.

I am connecting to Oracle using one Oracle user id
for example user1

I want to kill the queries running more than
7 mins. To achieve this, I have written an oracle
profile which will kill the query executed by
user1 userid.

Now I want to check the unix user id before
killing the oracle query.

Can anyone please let me know how to do this
in Oracle profile

ver: Oracle 8

You can reach me at sjayaprakash@inautix.com

Re: Oracle Profile for Unix user [message #199664 is a reply to message #199451] Wed, 25 October 2006 12:17 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Both links highly reputable
http://www.jlcomp.demon.co.uk/guilty.html
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:497421739750
Re: Oracle Profile for Unix user [message #202468 is a reply to message #199664] Thu, 09 November 2006 23:41 Go to previous message
shyamprabhu
Messages: 2
Registered: October 2006
Junior Member
Sorry, I am not able to get the information. Can you please
help me in getting it.
Previous Topic: AIX-xlC upgrade
Next Topic: Unix error: Not enough space, oracle not started
Goto Forum:
  


Current Time: Thu Mar 28 23:41:36 CDT 2024