Oracle Technology Blog

OraTech Blog provides tips,tricks,scripts and how-to type answers for Oracle related technologies. I use these commands very often, so I thought it would be useful to share with everybody. Please feel free to include your comments/corrections/questions.

Tuesday, May 30, 2006

Explain Plan in table format

SQL> select * from table(dbms_xplan.display);

| Id | Operation | Name | Rows | Bytes | Cost | Pstart|Pstop |
----------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 21 | 2 | ||
|* 1 | TABLE ACCESS FULL | SALES | 1 | 21 | 2 | 2 |2 |
----------------------------------------------------------------------------

0 Comments:

Post a Comment

<< Home