sql id

Different ways to get the Explain Plan for a SQL ID 

1.To Display the execution plan of the last SQL statement executed by the current session  SET LINESIZE 150  SET PAGESIZE 2000  SELECT * FROM table (DBMS_XPLAN.DISPLAY_CURSOR);  2.To display the execution…

Read More

Query to get the baseline for an sql id

Please use below query.   col sql_text for a60 wrap set verify off set pagesize 999 set lines 155 col username format a13 col prog format a22 col sid format…

Read More