Tuning indexes on RAC environments-2

Globally busy buffers due to contention for index leaf and branch blocks As we discussed in previous sessions, because of batch INSERT high concurrency could occur for a relatively small set of index leaf and branch blocks, where index keys are populated with monotonically ascending values.The symptoms are increased frequencies and wait times for a […]

Read the rest of this entry »

Tuning indexes on RAC environments-1

Introduction and Significance of tuning indexes in RAC environments. Oracle E-Business environment with financial modules like AP and GL having large scale payment invoices transaction. Let me take example of one my public sector clients, they do process of 3 million payment instructions every night. Such most insert intensive applications running on RAC the frequency […]

Read the rest of this entry »

Index Performance Tuning Techniques for RAC

It’s been quite some time since my readers are requesting to see some posts on RAC performance tuning concepts and practices. In the process of testing some of the tuning techniques, as well as discussing and interpreting the results, I am preparing a four-day in depth session to understand index performance tuning techniques for RAC. […]

Read the rest of this entry »

adpatch options

adpatch options Few of our dbas are still not clear about the helpful features of adpatch utility with command line options.If you are in a production downtime to do some patching activity, especially for some rollup upgrade, your downtime will end up with series of pre and post patches. In Such a scenario, it is […]

Read the rest of this entry »
|