title: Does Oracle have a means to show query execution plans like Sybase 'showplan'?
body: <p>I am a Sybase DBA/performance optimizer and was asked to look into the performance of some SQL queries on Oracle and see what the problems are and why it is slow.  Is there a showplan similar to Sybase?  I need to get the number of physical i/o's and logical i/o's, table scans and indexes the query or stored procedure uses.</p>
  
  <p>I used to use Embarcadero and I don't have that anymore.</p>