Database Administration (MOSC)

MOSC Banner

How to know who is connecting using db_link?

edited May 13, 2014 12:00PM in Database Administration (MOSC) 2 commentsAnswered

Hi,

There is schema (example USER4LINK) that has SELECT on other schema (same database, example DB1)

There are several databases on other hosts (example HOST1) have created database link using provided user USER4LINK.

Right now , I want to know which databases are connecting through the database link, they comes from the same USER and MACHINE.

From the view v$session, I can only know USERNAME, MACHINE. They are all the same if these connections comming from different databases but the same host.

Thanks,

Xiaogang

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center