How to determine connection port in oracle database via session?

G

G

gadpaw2018-03-29 11:09:26

Oracle

gadpaw, 2018-03-29 11:09:26

How to determine connection port in oracle database via session?

Local users connect to the database on port 1521, and external users on port 15215. How can you determine from the session data which connection is local or external?

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

G

gadpaw, 2018-03-29
@gadpaw

It turns out that there is no such information.
"You cannot get the port -- the port is not necessarily known to the database."

Similar questions

D

Djasar2021-03-30 12:23:23

GROUP BY doesn't work, where is the error? 1Reply

Z

ZhanD2019-09-18 08:22:55

How to kill an active oracle session launched from a .Net web application? 2Reply

S

sitev_ru2015-05-13 07:47:24

How to stop ORACLE stored procedure execution using OCCI? 0Reply

A

Alexey M.2015-05-20 10:56:48

How to access Oracle from the command line? 1Reply

L

lohmag2017-05-10 18:33:55

Is there a way to select the code of all triggers? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question