Home » Page 118

how to find session generating lots of redo in Oracle database

To find sessions generating lots of redo in Oracle database , you can use either of the following methods. Both methods examine the amount of undo generated. When a transaction generates undo, it will automatically generate redo as well. How to find session generating lots of redo in Oracle database 1) Query V$SESS_IO. This view …

how to find session generating lots of redo in Oracle database Read More »

Oracle Concurrent Manager – CP Analyzer for E-Business Suite

The Concurrent Processing Analyzer is a Self-Service Health-Check script which reviews the overall Concurrent Processing Footprint(Oracle Concurrent manager) , analyzes the current configurations and settings for the environment providing feedback and recommendations on Best Practices. This is a non-invasive script which provides recommended actions to be performed on the instance it was run on and …

Oracle Concurrent Manager – CP Analyzer for E-Business Suite Read More »

Oradism Oracle

DISM usage is Oracle Oracle database uses shared memory segment to facitilate many things in the database. Shared memory segment consist of SGA which has buffer cache ,shared pool etcThe shared memory segments is managed either using ISM or DISM in Solaris and Linux ISM stands for Intimate Shared Memory DISM stands for Dynamic Intimate …

Oradism Oracle Read More »

Scroll to Top