DB이야기/ORACLE

sql_id를 RAC 노드에 관계 없이 조회하기

뉴예맥 2023. 1. 20. 16:12
728x90

예) SQL) @x1 1xdkdjfkdl(sql_id)
x1.sql
-------------------------------------------------------------------------------------------------------------------------------------------------------
SELECT t.plan_table_output
FROM gv$sql v,
TABLE(DBMS_XPLAN.DISPLAY_CURSOR('gv$sql_plan_statistics_all', NULL , 'ADVANCED ALLSTATS LAST',
'inst_id = '||v.inst_id||' AND sql_id = '''||v.sql_id||''' AND child_number = '||v.child_number )) t
WHERE 1=1
AND v.sql_id = '&1'
AND v.loaded_versions > 0
;

728x90