What is the best way to learn SQL OPTIMIZER?
read dedicated books about Oracle optimization
have wild environment where you’ll be forced to act very often saving your database. Only practice will make your skills better.
Please take a look at the SQL Optimizer for Oracle community on Toad World. You will be able to find blog articles and videos that can help you get started with SQL Optimizer.