Related Articles
Oracle Identifying and Reducing Redo Allocation Latch Contention
Identify Contention The following query determines the miss ratio and the "immediate" miss ratio for redo log latches. Col MISS_RATIO format 999.99Col IMM_MISS_RATIO format 999.99 SELECT substr(ln.na...
How to Keep Certain Records on Top While Ordering Data? – Interview...
Question: How to Keep Certain Records on Top While Ordering Data? Let me elaborate this question as it is originally received. “Hi Pinal, I just returned from an interview and I faced a very strange ...
Oracle 11g/12c Client Install on Windows: Lightweight and Locked Down
Concerned about risks and want to lock down your Oracle client for end user Windows PCs? Have a need for the ‘cross connection query’ feature of Toad Data Point? The solution is within your grasp! Let...
