A crucial task for any experienced Oracle DBA is performance tuning . It involves a complete approach to identifying and correcting bottlenecks that impact query execution . This often entails examining SQL statements to ensure efficient data access. Techniques employed can include statistics gathering, alongside observing critical database metrics