Skip to content
Knowledge Center
Login
Knowledge Cards
All
Performance
Do’s and Dont’s
Learning Places
About
Delivery Network
Knowledge Library
Future Plans
Guiding Principles
Search
Results for
{phrase}
(
{results_count}
of
{results_count_total}
)
Displaying
{results_count}
results of
{results_count_total}
More results...
Benefit: Performance
DOs And DONTs
Avoid selects on big tables in TSA.SERVICES that run all day in AUTO mode
TSA.SERVICEs that run on AUTO mode all day must have light select queries ,otherwise this can be troublesome
2
0
0
0
A.S. Harish
November 6, 2022
DOs And DONTs
Oracle cookbook for 9i and 19g
This article discusses Red Hat Enterprise Linux optimizations running oracle database
2
0
0
0
A.S. Harish
November 6, 2022
DOs And DONTs
Setting up hardware based on real data is critical from a system architecture point of view
This card provides an example of hardware recommendations for a 5 year projection of the bank’s transactional volumes
0
0
0
0
A.S. Harish
November 6, 2022
DOs And DONTs
Handy hardware recomendations for optimal performance
The attached document provides hardware recomendations for a based on defined transaction volumes
2
0
0
0
A.S. Harish
November 6, 2022
DOs And DONTs
Oracle health checks should be done periodically to keep things in check
The attached document is a holistic oracle health check guide that helps in tuning various oracle parameters
2
0
0
0
A.S. Harish
November 6, 2022
DOs And DONTs
Use database triggers with caution. Avoid triggers on large T24 tables
Avoid database triggers on big tables like
STMT.ENTRY,CATEG.ENTRY&
RE.CONSOL.SPEC.ENTRY
2
0
0
0
A.S. Harish
November 6, 2022
DOs And DONTs
Database Indexes must be created the correct way to avoid performance impacts
Surprisingly indexes created the incorrect way can cause performance issues and slowness.
4
0
0
0
A.S. Harish
November 6, 2022
DOs And DONTs
No Journal.Update calls should be done in version routines(valid for older T24 releases)
L3 routines attached to version should not call JOURNAL.UPDATE.This will destroy transaction integrity.
1
0
0
0
A.S. Harish
November 6, 2022
DOs And DONTs
T24 screens(versions) for high volume applications can switch of lock reporting
REPORT.LOCKS field can be set to NO in the VERSION application for high volume application versions.
2
0
0
0
A.S. Harish
November 6, 2022
DOs And DONTs
Configure your T24 application servers and oracle db with this guide
Many best practices have been covered in this document in relation to T24 application servers and oracle db
4
0
0
1
A.S. Harish
November 6, 2022
DOs And DONTs
Oracle database best practices can help in tuning your database the right way
Understanding how to tune your oracle database is crucial in avoiding performance degradation
2
0
0
0
A.S. Harish
November 6, 2022
DOs And DONTs
Cob jobs with multiple selects can be split and run separately for performance benefits
COB jobs with more than 1 SELECT need to be split into 2 and run separately(in the same batch)
4
0
0
0
A.S. Harish
November 6, 2022
loading more results
