To start with run a STATSPACK report to get an overview of what extacly is proble. Read the docs below..

https://metalink.oracle.com/metalink...,1,1,helvetica

Explain Plan is for sql statement.