Performance tuning is one area where most Junior DBAs face those tough-to-break problems. The kind of problems which require deep understanding of the concepts before…
1 CommentCategory: Tuning Basics
There are a number of factors that we need to keep in mind to be able to successfully tune a GoldenGate Setup. If you carefully design your system keeping in mind the end goal and apply some proven performance tuning measures you should be able to get real time replication from your GoldenGate setup.
3 CommentsSome of the key reasons which attributes to database performance issues are mentioned below:
Below post is based on Oracle Documentation
1.Bad connection management
The application connects and disconnects for each database interaction. This problem is common with stateless middleware in application servers. It has over two orders of magnitude impact on performance, and is totally unscalable.
Leave a CommentWhen you are faced with any database related performance issue before you begin troubleshooting it is important to first have some basic ground work done. Below are some key points which should be thought upon before doing actual troubleshooting
2 CommentsA normal SQL statement go through below phase before producing results.
1) PARSE PHASE
Parsing stage will tell what does the statement mean and how best to run it
2 Comments Posted by Arindam Mukherjee Recently I encountered an interesting performance issue while working with Oracle EBS seeded components and these issues are tied to wrong use…
Leave a Comment