IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
Hi, I will explain How to Interpret an Execution Plan in this article.
Read More »How to Read or Interpret an Execution Plan in Oracle | Oracle Database Performance Tuning Tutorial -5
Tag Archives: Oracle architecture
What is the Execution Plan and How to View Execution Plan in Oracle | Oracle Database Performance Tuning Tutorial -4
Hi, I will explain What is the Execution Plan and How to Generate Execution Plan in this article.
Read More »What is the Oracle Optimizer and How Cost-Based Optimizer Works ? | Oracle Database Performance Tuning Tutorial -3
Hi, I will explain What is the Oracle Optimizer and How Cost-Based Optimizer Works in this article.
Read More »SQL Statement Processing in Oracle Database
Hi, I will explain SQL Statement Processing in Oracle Database in this article.
Read More »Oracle Database Architecture -3 SMON, PMON, DBWR,CKPT and LGWR Processes
Hi, I will continue to explain Oracle database architecture in this article. I’m adding the following image to be memorable. If you didn’t read the previous articles, I suggest you …
Read More »Oracle Database Architecture -2 Buffer Cache, Redolog Buffer, Onlinelog and Archivelog
Hi, I will continue to explain Oracle database architecture in this article. I’m adding the following image to be memorable. If you didn’t read the first article, I suggest you …
Read More »Oracle Database Architecture -1 Controlfile, Datafile, SGA and PGA
In this article I will explain the Oracle Database Architecture. Let’s review the Controlfile Datafile SGA and PGA | Oracle Architecture detailed.
Read More »