Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Saturday, January 26, 2013

Change EXADATA explain plan to Traditional Oracle explain plan

In EXADATA explain plans you will see "storage" and this sometimes is diffcult to compare with traditional oracle explain plan.
In EXADATA parameter CELL_OFFLOCAD_PLAN controls this behaviour.






Ex:-
SQL> show parameter cell_offload_plan_display

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cell_offload_plan_display            string      AUTO

SQL> select * from dual;

 



SQL> alter session set cell_offload_plan_display=NEVER ;

Session altered.

SQL> /

Session altered.

SQL> select * from dual;
 






SQL> show parameter cell_offload_plan_display

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cell_offload_plan_display            string      NEVER
SQL>

No comments: