Category: Performance Tuning
contains posts related to performance tuning
performance tuning – understanding explain plan – for the new oracle dba career
understanding explain plan and its interpretation – helps the new dba in performance tuning
Performance tuning overview for the new oracle dba
performance tuning overview for the new dba and what the new dba should do to troubleshoot performance issues with sql queries
How oracle reads Block from disk into Buffer Cache
How does oracle read a block from disk into memory/buffer cache?
Differences – consistent gets , physical reads and db block gets
consistent gets,physical reads and db block gets and their relevance in performance tuning.
