EXPLAIN PLAN USING SQL_ID

 We can extract the explain plan using sqlid

command
=======

select * from TABLE(dbms_xplan.display_awr('0srj720xy3mx7'));

PLAN_TABLE_OUTPUT


--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

SQL_ID favqakzqswx1q

--------------------

SELECT cd.Id, cd.TypeNum AS CxnType, od.Id, od.GUID, od.Version,

oda.ShortPlainString, od.TypeNum, od.GroupId, od.RefGlobalId,

od.SubTypeNum, od.DefSymbolNum, od.SymbolGuid FROM e151_cxndef cd JOIN

e151_objdef od ON cd.FromObjDefId = od.Id LEFT OUTER JOIN

e151_objdefattr oda ON (od.Id = oda.ParentItemId AND oda.AttrTypeNum =

1 AND oda.LocaleId = :1 ) WHERE cd.ToObjDefId = :2 AND EXISTS (SELECT

'X' FROM e151_visibleobjdef v WHERE v.ObjDefId = od.Id AND

v.UserGroupId = :3 AND v.Filter = :4 )





PLAN_TABLE_OUTPUT

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Plan hash value: 1195989455



-------------------------------------------------------------------------------------------------------


Id
Operation
Name
Rows
Bytes
Cost (%CPU)
Time


-------------------------------------------------------------------------------------------------------


0
SELECT STATEMENT



14 (100)




1
NESTED LOOPS OUTER

1
243
14 (0)
00:00:01



2
NESTED LOOPS SEMI

1
198
11 (0)
00:00:01



3
NESTED LOOPS

3
411
8 (0)
00:00:01



4
TABLE ACCESS BY INDEX ROWID
E151_CXNDEF
3
120
5 (0)
00:00:01



5
INDEX RANGE SCAN
E151_CXNDEF_FK_2I
3

3 (0)
00:00:01




PLAN_TABLE_OUTPUT

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


6
TABLE ACCESS BY INDEX ROWID
E151_OBJDEF
1
97
1 (0)
00:00:01



7
INDEX UNIQUE SCAN
SYS_C00336210
1

0 (0)




8
INDEX UNIQUE SCAN
E151_VISIBLEOBJDEF_1
10028
597K
1 (0)
00:00:01



9
TABLE ACCESS BY INDEX ROWID
E151_OBJDEFATTR
1
45
3 (0)
00:00:01



10
INDEX RANGE SCAN
E151_OBJDEFATTR_1
1

2 (0)
00:00:01


-------------------------------------------------------------------------------------------------------