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.
Read More »Oracle
Alter System Flush Buffer Cache in Oracle
Hi, I will explain Alter System Flush Buffer Cache in Oracle in this post.
Read More »Alter System Flush Shared pool in Oracle
I will explain Alter System Flush Shared pool in Oracle in this post.
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.
Read More »How to Add Datafile to Tablespace and Tablespaces Usage , Tablespace Size Check
Hi, I will explain How to Add Datafile a Tablespace and Tablespaces Usage , Size Check in this post.
Read More »RMAN Catalog start with Command Tips in Oracle
I will explain RMAN Catalog start with Command tips in Oracle in this post.
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.
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
Read More »Change Memory_max_target and memory_target in Oracle
MEMORY_TARGET is a database initialization parameter that can be used for automatic PGA and SGA memory sizing. MEMORY_TARGET provides the following: A single parameter for total SGA and PGA sizes Automatically …
Read More »Oracle 19c Database Upgrade From 18.9 to 19.8.0.0 on Exadata X7 | Oracle 19c Database Upgrade Manual Method
Hi, I will explain Oracle 19c Database Upgrade From 18.9 to 19.8.0.0 on Exadata X7 in this article.
Read More »
IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial