Skip to content
January 27, 2023
Oracle World :: Developer's Cheat Sheet

Oracle World

Developer's Guide

  • Home
  • SQL
    • SQL Basic
    • SQL Advanced
    • SQL Tips&Tricks
  • PL/SQL
    • PL/SQL Basic
    • PL/SQL Advanced
    • PL/SQL Tips&Tricks
  • DBA
    • DBA Basic
    • DBA Advanced
    • DBA Tips&Tricks
  • Architecture
  • Practice
  • Resources

Architecture

Architecture

Multi-User Concurrent Transactions

January 28, 2019November 10, 2020 - by OracleWorld

I have explained in previous articles what is happening in the database when a single user performs a particular query. However, you will hardly see an application serving for one …

Multi-User Concurrent Transactions Read More
Architecture

Redo Log

January 17, 2019August 19, 2020 - by OracleWorld

As I said before, REDO Log’s purpose is to store all transactions in case of emergency (data corruption, instance failure, recovery) or other purposes such as performance optimization or data …

Redo Log Read More
Architecture

DDL processing

October 10, 2018February 5, 2019 - by OracleWorld

DDL processing is very simple. It is just a DML operation on system metadata. You actually change system data files via Data Dictionary Cache. All DDL commands have implicit commit, …

DDL processing Read More
Architecture

DML Processing

October 9, 2018November 10, 2020 - by OracleWorld

Stages for DML processing are the same as for SELECT processing except for the last step (=FETCH) PARSE BIND EXEC I will skip the first stages because the principle is …

DML Processing Read More
Architecture

SELECT Statement Processing

October 8, 2018November 10, 2020 - by OracleWorld

Every SQL query you send to a server has to go through three  (four – in case of SELECT) stages. First of all, Oracle will search for a matching SQL hash …

SELECT Statement Processing Read More
Architecture

Database Files

October 7, 2018November 10, 2020 - by OracleWorld

Database files play an essential role in the Oracle architecture. They physically store all data necessary to run the database successfully. Data files Every tablespace consists of one or more …

Database Files Read More
Architecture

Instance Architecture

October 6, 2018November 10, 2020 - by OracleWorld

I will describe in this article what are the components of Oracle Instance architecture in detail. You might have thought that you connect to a database but that is not …

Instance Architecture Read More
Architecture

Instance and Storage

October 5, 2018November 10, 2020 - by OracleWorld

In this article, I will tell you about the basic components of Oracle database (storage) and instance and their architecture. Instance Instance consists of two components SGA Processes SGA SGA …

Instance and Storage Read More
Architecture

Computing Architecture

October 4, 2018November 10, 2020 - by OracleWorld

There are three major components without which any computer cannot operate. Memory Processor / CPU Storage Memory The major feature of memory is speed; it is very fast. That means …

Computing Architecture Read More

Recent Posts

  • How To Cache Oracle Database
  • How To Trace Queries in Oracle with AUTOTRACE
  • PL/SQL Nested Blocks
  • How To Find Invalid Hints
  • Long Running Queries Monitoring

Most popular posts

  • How To Read AWR Report
  • Multidimensional Arrays In Oracle PL/SQL
  • DBMS Scheduler – Chains
  • Chained Rows – Problems And How To Fix Them
  • SELECT Statement Processing

About Me

Hello, my name is Petr Hybler and I am an Oracle enthusiast and a professional Data whisperer. My journey started even before …

read more

Copyright © 2023 Oracle World.