Developer's Guide
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 MoreAs 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 MoreDDL 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 MoreStages 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 MoreEvery 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 MoreDatabase 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 MoreI 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 MoreIn 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 MoreThere 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