Oracle

Hi, I will explain What is the SQL Access Advisor and How to Run SQL Access Advisor in this article.

Hi, I will explain what is the SQL Tuning Advisor and how to use it in this Article.

Hi, I will explain What is the SQL Tuning Set and How to Create the SQL Tuning Sets in this article.

Hi, I will explain Optimizer Access Paths & Join Operators in this article.  

Hi, I will explain Optimizer Access Paths (Table and Index Scan) in this article.

If you start long operations such as RMAN Backup and Datapump Export in Oracle database, probably you want to see progress of these operations. Let’s review the RMAN Backup and …

I will explain How to Use SQL Trace , Trcsess and TKPROF in Oracle in this article.

Hi Just now I was working on one issue and wanted to share solution ; First of all this is very common error if you have custom top on your …

Hi, I will explain you about Oracle Database Security , Database and Profile Security Parameters in this article.  

Hi, I will explain How to Interpret an Execution Plan in this article.