This topic summarizes hints for tuning different components of your parallel server database.
Data Separation
Follow these rules for separating data:
If at all possible, ensure that database instanc...
Introduction
In my previous articles I explained two very important concepts about Undo Data; one is how Oracle manages the retention time and the other is how Oracle reuses the undo extents. You can ...
Just another day while doing performance tuning engagement, Senior DBA of the organization and I both noticed that one of the SP sp_readrequest is continuously listed as long running SP. Well, the go...