Techgoeasy

SQL Plan Baselines in Oracle Database are a method for maintaining the consistency of SQL statements’ performance.SQL baseline can be created from cursor cache, AWR, Sql tuning set etc. In this post, We will be looking at How to create sql baseline from the cursor cache in Oracle If you want to create a SQL […]

What is sql baseline? SQL Plan Baselines in Oracle Database are a way to maintain the performance stability of SQL statements. When an SQL statement is executed, the Oracle optimizer determines the optimal execution plan for that statement based on various factors such as statistics, system settings, and bind variables. However, sometimes the optimizer might […]

Sometimes, you want to modify the statistics for testing purposes or some other things. Oracle has provided a standard procedure to set the statistics for the Table/index/column. In this post, we will check out how to do it How to set statistics for Table This is done using the SET_TABLE_STATS procedure of the DBMS_STATS package […]

We may sometimes need to delete the statistics on the Table/index/column in Oracle. In this post we will check out how we can do it with standard oracle defined procedures How to delete statistics from Table Oracle has provided a procedure in DBMS_STATS Package Here cascade parameters are default true which means when table stats […]

We have a condition where a query is performing poorly and sql tuning advisor is not helping, we dont have a good plan also, so a custom sql profile can also not be created. The only solution is adding manual hints in the query but it is not possible to change the code. In this […]

Outline hints of the sql statement are the hints which are required to reproduce the same plan.This can be useful in many ways(a) You can enforce the same plan on the same query with different literal(b) we could use them between two slightly different queries also(c) These are the same hints used in the custom […]