Below section I have tried to present all the important features in Oracle Database management
What is DBMS_STATS The DBMS_STATS package was introduced in Oracle 8i and is Oracle’s preferred method of gathering object statistics. DBMS_STATS is a package in Oracle Database that provides procedures to manage statistics for database objects. Statistics are essential for the optimizer to make efficient execution plans for SQL statements. The package offers procedures to …
How to gather Statistics with DBMS_STATS Procedures Read More »
What is Oracle Database cloning: A database clone is a complete and separate copy of a database system that includes the business data, the DBMS software, and any other application tiers that make up the environment. The cloning can be done on the same host or a separate host. What is the need for Database …
Often we set some parameters at the session level and run some commands. Now DBA may want to know what has been set in that session. In this post, we will check out How to list parameter set at the session level in Oracle How to list parameter set at session level using oradebug Using …
How to list parameter set at session level in Oracle Read More »
We often experience performance issues because of the inaccurate statistics for the objects involved and we want to know what the difference is between the statistics of good time and bad time With 12c, we can use the DBMS_STATS procedure to find the difference between the statistics How to compare statistics using history for a …
How to compare statistics using history for a table in Oracle Read More »
Here are some beneficial Queries on Sqlplan Management in oracle How to check the sql plan parameter show parameter sql_plan How to check the settings for Automatic plan capture If OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=true, then we can use the below query to find out the settings of the automatic plan capture How to check the sql baseline for …
We must have felt the pain when you have applied multiple patches and each time you have to give Y to the prompt in opatch. There is a solution available to this problem How to run Opatch in a non-interactive form We can run the opatch apply, napply, rollback and nrollback commands in non-interactive mode …
How to run Opatch in non interactive form Read More »
