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 … Continue reading Example of using sql profile to use switch to a different execution plan
Tag: profile
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. … Continue reading Information on “RESOURCE_LIMIT” parameter
alexlima.com 