Connor and Chris will both be at AI World from October 12 to October 17 , the premier Oracle conference of 2025. If you're in Vegas, please come say Hi or pop into our sessions
Thanks for the question, Shibaji.
Asked: March 24, 2017 - 3:29 am UTC
Last updated: March 28, 2017 - 12:23 pm UTC
Version: 11G
Viewed 1000+ times
variable pls number begin :pls := dbms_spm.load_plans_from_cursor_cache( attribute_name => 'SQL_ID', attribute_value => '[your SQL ID]'); end;
variable pls number begin :pls := dbms_spm.load_plans_from_cursor_cache( attribute_name => 'SQL_TEXT', attribute_value => '%select%from%my_table%where%'); end;
A reader, March 28, 2017 - 10:41 am UTC
More on PL/SQL routine DBMS_SPM here