Monday, 1 April 2019

Explain Plan for Oracle Query

Process 1

select * from table(dbms_xplan.display_cursor('SQL_ID'));


Process 2
explain plan for Query

@?/rdbms/admin/utlxpls

Process 3

select * from table(dbms_xplan.display('SQL_ID'));

-

How to login on Oracle Cloud Console?

Login Steps for Oracle Cloud Console To sign in to Oracle Cloud Console, We need to open up the corresponding region console URL for Free Ti...