Question: what is extproc in listener in oracle?
Answer: Oracle lets listener to spawn a new process by calling extproc (or extproc32 ). This process loads the shared library and the rest of the database talks to this process via IPC. This approach is safer, because the external library can not crash the database nor corrupt data.