Oracle 11g database- performance enhancement and sql tuning methods
I'd recommend reading Oracle's official performance tuning guide for 11g:

https://docs.oracle.com/cd/E11882_01/server.112/e41573/toc.htm