Announcements

Oracle training based on real-time expertise as per industry standards. Upcoming batch details are here.

View batch schedule

Free Oracle mock interview. Register using the link.

Register

#DBAchallenge: submit your questions.

Ask questions
Swipe for more →
Browse by Topic
Latest Posts

    Thursday, March 7, 2024

    How to generate and display the execution plan

    How to generate and display the execution plan:
    ========================================================
    Option 1: Generating and displaying the execution plan for the last SQL statement executed in your session:
    select * from MALLIK.STUDENT;

    SET LINESIZE 150 
    SET PAGESIZE 2000 
    SELECT * FROM table (DBMS_XPLAN.DISPLAY_CURSOR); 

    select plan_table_output from table(dbms_xplan.display_cursor(null,null,'basic'));


    Option 2: Generating and displaying the execution plan from SQL_ID
    SET LINESIZE 150 
    SET PAGESIZE 2000 
    SELECT * FROM table (DBMS_XPLAN.DISPLAY_CURSOR('atfg645km3ykp'));

    SELECT * FROM table(dbms_xplan.display_cursor('fnrtqw9c233tt',null,'basic'));

    Regards,
    Mallik

    No comments:

    Post a Comment

    🌟 Proud to be an Oracle ACE Pro! 🚀

    🌟 Proud to be an Oracle ACE Pro! 🚀 I’m excited to share my official Oracle ACE Profile with the Oracle community. 👨‍💻 Mallikarjun ...