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
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:
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.