Performance Tuning

Hi Team,

I'm in a process of learning stuffs related to performance tunings.

eg: troubleshooting job/program/batch jobs running slow, programs getting stuck, how does optimizer works to generate the PLAN, how the plan works and how to know if there is any requirement to make the job to adapt a different plan, dynamic sampling, how does Indexes affect the running of program/job, BITMAP vs BINARY indexes, partitions,parallel query, hints.

I have downloaded few Oracle documents to investigate on this as a preliminary step.

But requirement is to learn performance tuning in depth, both for learning purpose and requirement in my current project in the future.