Example of using sql profile to use switch to a different execution plan

Below are the 2 SQL statements, the first one uses the index AAA_IDX and then second one does a full table scan and in this case we want to make the first one that uses the index use the same execution plan as the 2nd one. SQL statement: select * from aaa e where ename = 'aaa'; select /*+ FULL(e) */ * from aaa e … Continue reading Example of using sql profile to use switch to a different execution plan

Information on “RESOURCE_LIMIT” parameter

“RESOURCE_LIMIT” parameter is used to enable/disable “KERNEL” resource type profiles. Password parameters are part of profiles but they are controlled by this parameter. This parameter is a SYSTEM level parameter so it can be changed using “ALTER SYSTEM” and can be changed on the fly. Possible values are true/false and the default value is false. Example: To set resource_limit sys@TESTDB> alter system set resource_limit = … Continue reading Information on “RESOURCE_LIMIT” parameter