Explain plan is for checking each sql query How it has executed.. which plan it is used. we can check each query execution plan using Explain plan. after that we need to intrepret it wheather it is ok or not.
Sqltuning advisor automatically gives you some advices based on the sqls run on your database. you will get it from Enterprise manager.