Tag Archives: listener

sqlnet.expire_time – to restart or not to restart

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

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