Tag Archives: listener

sqlnet.expire_time – to restart or not to restart

Posted on September 4, 2011 by marcel

We had a situation where we had to set the sqlnet.expire_time parameter in the sqlnet.ora file to avoid firewall dropping “inactive” sessions. The only problem was that we were not allowed to restart the listener or the database instance. Searching … Continue reading →

Posted in Database | Tagged , , , , , , | 6 Comments

A listener and its children

Posted on March 27, 2011 by marcel

Until last week I din’t know about a listener process having one or more childrens (a child process has exactly the same name as its parent but have their parent-pid set to the parent listener pid). Trying to find information … Continue reading →

Posted in Database | Tagged , , , , , , | 1 Comment