Manage the SQL Profile in the Oracle Database
Manage the SQL Profile in the Oracle Database
SQL Profile is used by Optimizer for use more efficient execution plan for the SQL Query to make in accepted State. It is found in DBA_SQL_PROFILES view. It used to choose better plan by optimizer if the sql profile plan is having low cost then optimizer use it.
Check the SQL Profile in the Database. select name, type, status, sql_text from…
View On WordPress














