Oracle Profile for Unix user [message #199451] |
Tue, 24 October 2006 07:42 |
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
|
|
|
|
|