What is result cache in oracle Database with use case example?
In Oracle Database, the Result Cache is a feature that allows the caching of the results of SQL queries in memory. This caching mechanism can…
Category: Architecture
Oracle Background Processes
An Oracle instance runs two types of processes – · Server Process · Background Process Before work user must connect to an Instance. When user…
Starting up a database
This article explains the procedures involved in starting an Oracle instance and database. First Stage: Oracle engines start an Oracle Instance When Oracle starts an…
Basics of Oracle Architecture
Basics of Oracle Architecture As an Oracle DBA, you must be able to understand the concepts of Oracle architecture clearly. It is a basic step…
HOW ORACLE WORKS?
An instance is currently running on the computer that is executing Oracle called database server. A computer is running an application (local machine) runs the…