Using Autotrace in Sqlplus
Oracle's V$ Peformance Views
Important I/O statisitcs
Using Explain Plan