Bset practises about Oracle database
We've just migrated PEGA database from DB2 to Oracle, and currently facing problems as below.
Would appreciate a lot if anyone can provide some advise.
1. Long time network waiting/table lock - SQL*Net more data from client.
Form the Oracle EM, we can see long time network waiting/table lock events.
These sessions cannot be endded automically, has to be killed manually.
And the Weblogic datasources have to reset manually at the same time.
2. Poor performance after a certain idle time.
Firt time excution of some the SQL query probably will take more than 30s (even more than 100s sometime), and then spped up to under 1s.
After a while, the execution slowed down again - with excatly the came query SQL.
3. Any other best practises about PEGA running with Oracle database?
The versions:
PEGA 23.1.4
Oracle 19c (not RAC)
Weblogic Proprietary information hidden.0
JDBC dvier Proprietary information hidden.0
We've checked instllation guide as below, seems no such information mentioned.
https://docs.pega.com/bundle/platform-88/page/platform/deployment/DB/co…
Updated: 3 Feb 2026 7:57 EST
Pegasystems Inc.
US
@GAVINHSU Are the DB server(s) and the App servers using the same network? Hopefully not a lot of network hops separating them.
Also unable to see your versions (blocked with "Proprietary information hidden"), maybe if you took a screenshot of them then you could post that image here?