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

A

Andrey Strelkov2020-11-03 11:49:06

How can md5 hash sum be calculated in Oracle 11g for text strings of 5000 or more characters? 3Reply

M

Michael2019-02-06 13:13:20

How to forbid passing empty arguments to a procedure? 2Reply

M

marselabdullin2020-11-18 17:02:52

How to write nested query in select? 1Reply

M

Maxim Gerasimov2019-02-20 10:58:37

Why do sessions hang in the killed status for a long time in Oracle 12.2.0.1? 2Reply

Z

zotovby2014-09-26 12:48:25

how to calculate sequence using oracle? 3Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question