Quote Originally Posted by Himaja
whats the purpose of having multi listener ???

will it increase the posting speed in server, when it receives bulk data from 2 clients ???
Certanly not! Data to be inserted/updated/deleted/retrived fint/from the database *never* goes through the listener. Database server and the client talk directly to each other, no listener is involved in that. Listener only take its part between the client and the database during the connection time. Once the session is established listener is no longer needed - you can even shut it down and the connected sessions will still happily comunicate with the database.