We have our Oracle 8.1.7 production instance on Solaris 2.6. When a ps -afe is done on my database server, the multiple process names are oracledbname (LOCAL=NO). What are these processes? Does they cost a lot of system resources (e.g. memory)? Is there any way to prevent them to be started?
They are all the processes that are getting connected to the database server from a remote client. It also means the connection between the remote client and the server is still alive. If they are inactive, yes they would cost you the resources. As you may see, they would be holding a good amount of memory. You can do the top and see, how much of memory is used and how much they are entitled for. Normally they would go off if the user gets to close the connection. other wise, you can set the max idle time on the database, and clean them up, instead of killing them one by one manually.