Serhan Eroğlu

Posts Tagged ‘xplan

explain plan script

Posted by: eserhan on: February 19, 2009

this is a small hint to get a guick EXPLAIN PLAN when your ambulance button is not working at TOAD and you have limited time   EXPLAIN PLAN FOR SELECT * from something;       set pagesize 25  set linesize 121 SELECT * FROM TABLE(dbms_xplan.display);   just run this as script..


Follow

Get every new post delivered to your Inbox.