I'm working on a client-server application that uses OCI to communicate with Oracle. In the past our application often treated sessions as an infinite resource, quite possibly to the detriment of other applications that are sharing that Oracle server.
I'm trying to convince my fellow developers that it is important for our application to play nice with others and not be such a resource hog.
At what point would you Oracle DBAs consider an application to be using (or abusing) sessions excessively?
EDIT: Currently one of the biggest consumers of sessions is this one component that uses direct path loading to bulk load several (20-30) tables in parallel.