Hi all,

Issue:
Large number of opening and closing Oracle database sessions (on average 100k per hour).App is loading files into database by using sqlldr and for each file creating a new session. After loading session is closed. Probably it has no major impact to resources and performance of Oracle database
however KPI does not look satisfactorily. Important ! - App cannot be modified.

Is there any way to somehow reduce that number (only on Oracle side) so that app will load files by using some pool of connections instead of creating every time a new one and so on? Perhaps there is a module or mechanism that would be appropriately configured to be useful?

Let's assume the best scenario:
App first check if there is some active available session (for this process), if so then use it, if not then create a new one. It will definitely decrease the number of opening and closing session per hour.

Regards,
MS

SQL> exec dbms_connection_pool.start_pool;

PL/SQL procedure successfully completed.