Below section I have tried to present all the important features in Oracle Database management
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 …
How to replace sql plan by another sql id sql plan Read More »
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 …
How to get the outline hint in oracle and use for tuning Read More »
We all know about SQL profiles in Oracle and How they add hints and scaling factors that help in the Performance of the sql in Oracle. We have two types of sql profile This is the standard one that we get from sql tuning advisor. It tunes the sql statement using hint and scaling factors. …
The STATISTICS_LEVEL parameter was introduced in Oracle version 9 (9.2) to control allmajor statistics collections or advisories in the database. The level of the setting affects a number of statistics and advisories that are enabled. These listed below are for 10g and above The TYPICAL level is recommended for most production databases to enable the …
In this post, we will check out how to move SQL Profiles from One Database to Another How to move the sql profiles in Oracle Suppose you have created a sql profile in System A and Now you want to transfer that sql profile to System B. Step 1On System A: Creating a staging table …
Move SQL Profiles from One Database to Another in Oracle Read More »
We might have a requirement to compare stats for a table between two different systems, two different statid in the user statistics table, user statistics table and dictionary. All these requirements are met by DBMS_STATS new procedure DIFF_TABLE_STATS_IN_STATTAB. In this post, we will see how to use this procedure to compare statistics How to compare …
How to compare statistics using stattab for a table in Oracle Read More »
