Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 555 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 468 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
connect/disconnect issue

MagnusJohanssonDBA
Member Posts: 146 Bronze Badge
Hello all,
Helping a customer looking into slowness of an application after upgrade from 12.1 to 19c
We have identified and fixed several issues, found one issue in the addm report
This is a batch job running at night.
Finding 1: Session Connect and Disconnect Impact is 4.25 active sessions, 37.83% of total activity.
---------------------------------------------------------
Session connect and disconnect calls were consuming significant database time.
Recommendation 1: Application Analysis Estimated benefit is 4.25 active sessions, 37.83% of total activity.
--------------------------------------------------------------------
Action Investigate application logic for possible reduction of connect and disconnect calls.
For example, you might use a connection pool scheme in the middle tier.
Developers are aware of frequent connect/disconnect in the code and will address it.
But it will take some time to fix.
Wondering if setting up shared servers and use them for the batch job could ease the connect/disconnect issue
what do you think ?
anyone having experience of the same ?
Appreciate your comments !
Best Regards
Magnus Johansson