I will explain Hard Parse vs. Soft Parse and Bind Variable in Oracle Database in this post. 1,624 views last month, 2 views today
Read More »Performance Tuning
DLM cross inst call completion | enq: RO – fast object reuse wait event and _db_fast_obj_truncate parameter during Truncate Table in Oracle 19c
Hi, I will explain DLM cross inst call completion and enq: RO – fast object reuse wait event during Truncate Table in Oracle 19c in this post. 4,381 views last month
Read More »enq: TM – contention | TM Contention Wait Events in Oracle
Hi, I will explain enq: TM – contention | TM Contention Wait Events in Oracle in this post. 6,440 views last month, 2 views today
Read More »Performance Tuning with SQLTXPLAIN (SQLT) with Examples in Oracle | Oracle Database Performance Tuning Tutorial -19
Hi, I will explain SQLTXPLAIN (SQLT) Usage with Examples in Oracle in this article. 8,313 views last month, 1 views today
Read More »Oracle SQLTXPLAIN (SQLT) Tips and Tricks | Oracle Database Performance Tuning Tutorial -18
I will explain Oracle SQLTXPLAIN (SQLT) Tips and Tricks in this article. Let’s review the Oracle SQLTXPLAIN (SQLT) and SQLT Install 10,646 views last month, 2 views today
Read More »Performance Tuning and SQL Tuning Tutorial in the Oracle Database
I will share with you Step by Step Performance Tuning and SQL Tuning Tutorial in the Oracle Database in this article. 224,588 views last month, 27 views today
Read More »What is the SQL Performance Analyzer and SPA Report in Oracle | Oracle Database Performance Tuning Tutorial -17
Hi, I will explain What is the SQL Performance Analyzer and SPA Report in this article. 2,780 views last month, 2 views today
Read More »Automatic Diagnostic Repository Command Interpreter (ADRCI)
To start ADRCI in the interactive mode, type adrci at the command line, as shown here: 2,275 views last month, 3 views today
Read More »Block Change Tracking in Oracle
Block change tracking (BCT) is an oracle feature that improves the performance of incremental backups. 1,952 views last month, 2 views today
Read More »What is the Optimizer Hints and How to Use Hints in Oracle | Oracle Database Performance Tuning Tutorial -16
Hi, I will explain What is the Optimizer Hints and How to Use Hints in Oracle in this article. 3,424 views last month, 3 views today
Read More »