Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How To know who is using the DBLINK
madhusudana.reddy_at_bestbuy.com (Madhu) wrote in message news:<9dd6101c.0306100824.52d0251a_at_posting.google.com>...
> Hello All,
> I have two DBLINKS created for users 'SYS' and 'SYSTEM' and i am in
> the process of changing the passwords for both the users. Is there any
> way to know who is using the DBLINKs created for the users 'SYS' and
> 'SYSTEM' ??
If anybody is currently using the link, he's holding a DX lock shown in v$lock.
Yong Huang Received on Wed Jun 11 2003 - 12:16:21 CDT