Toad World® Forums

Zählen der Listenerverindungen

Hallo,

gibt es eine Möglichkeit herauszufinden, wieviele Verbindungsanfragen an den Listener gestellt wurden/werden ?

Konkret geht es um ORACLE 12c .

Es geht nicht um die Aussagen aus der View v$session !

Gruß Karsten

My best attempt at translation;

Hello,

Is there a way to find out how many connection requests were sent to the Listener? Specifically for Oracle 12. I can not rely on the view v$session!

My answer:

I don’t know of a way. What is wrong with the numbers reported by v$session?

The only relevant thing that I find is that you can limit the number of new connections with parameters in listener.ora:

Connection Rate Limiter Parameters

Hello,

the v$session-view reported only the active sessions in the database.

On oracle 12.1.0.1.0 (german windows and german oracle installation) the listener hang after 2048 requests… ! A newstart of the listener is only a temporary solution.

The workaround is the create an group “Administrators” on the server….

but I want to know the number of connectivity on the listener !

Greetings Karsten

Von: jacquesrk [mailto:bounce-jacquesrk@toadworld.com]
Gesendet: Donnerstag, 3. September 2015 21:13
An: toadoracle@toadworld.com
Betreff: RE: [Toad for Oracle - Discussion Forum] Zählen der Listenerverindungen

RE: Zählen der Listenerverindungen

Reply by jacquesrk

My best attempt at translation;

Hello,

Is there a way to find out how many connection requests were sent to the Listener? Specifically for Oracle 12. I can not rely on the view v$session!

My answer:

I don’t know of a way. What is wrong with the numbers reported by v$session?

The only relevant thing that I find is that you can limit the number of new connections with parameters in listener.ora:

Connection Rate Limiter Parameters

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.

listener writes every client connection to it to the listener log file.

you might check it there.

emha.