Re: Identifying clients in 3 tier architectre

anish wrote:
> actually some users have locked certain resources in the database..i
> want to identify their session and kill them... in this system multiple
> users are getting connected to the database using the same user id thru
> forms server on AS .I know which clients have made the http request
> ,but can't identify them in database sessions since the users are
> connected using same id...so i want to know which client machine has
> started what session in the database ...i think now i have made myself
> clearer

When you say locked, are you referring to Oracle locking or something else? If Oracle locking, then use the lock manager of OEM or the scripts in $ORACLE_HOME/rdbms/admin/*lock* or one of the many scripts online that look at v$lock. If something else, desc v$session and see what you can get, some apps are nice enough to load machine, osuser, program or something. How do you know which clients made the request?

jg

-- 
@home.com is bogus.
Search for perticular on metalink.