You can use either the line item profiler or the hierarchical profiler (Oracle 11g and up).

 

 

Related Information