• Kerry Osborne’s Oracle Blog » Blog Archive » Flush A Single SQL Statement – Kerry Osborne’s Oracle Blog
  Flush A Single SQL Statement DBMS_SHARED_POOL.PURGE
  in Oracle > DB 11g with advisor execution flush osborne plans single sql statement tuning
• sqlmonitor.html
  Oracle Database 11g: Real-Time SQL Monitoring Real-Time SQL Monitoring, introduced in Oracle Database 11g, provides a very effective way to identify run-time performance problems with resource intensive long-running and parallel SQL statements. Interactive Enterprise Manager screens display details of SQL execution using new, fine-grained SQL statistic that are tracked out-of-the-box with no performance penalty to production systems. Statistics at each step of the execution plan are tracked by key performance metrics, including elapsed time, CPU time, number of reads and writes, I/O wait time and various other wait times. This allows DBAs to analyze SQL execution more deeply than pre
  in Oracle > DB 11g with 11g database display enterprise execution manager monitoring oracle performance real-time run-time sql statements statistic
• How Parallel Execution Works
  Oracle doc
  in Oracle > DB 11g with controlling execution oracle parallel

execution from all users