Explain Oracle instance.
Posted On: Feb 22, 2018
Each operating Oracle database is associated with an Oracle instance. As soon as a database server starts the database, it is assigned a memory area by Oracle called System Global Area (SGA) and starts one or more than one processes. The SGA and Oracle processes together are referred to as an Oracle instance. The process and memory of an instance are used to efficiently handle data used by multiple users.
Related Questions
Subscribe Our NewsLetter
Never Miss an Articles from us.
Recent Articles
Featured Categories
- Common Interview Questions
- Python Flask Interview Questions
- NoSQL Interview Questions
- jQuery Interview Questions
- C Programming Interview Questions
- AngularJs Interview Questions
- Node JS Interview Questions
- JavaScript Interview Questions
- Core Java Interview Questions
- HTML Interview Questions
- Laravel Interview Questions
- Wordpress Interview Questions
- PHP Interview Questions
Oracle Interview Questions
What is Oracle?
Oracle is a database server that is used to handle data in a structured manner. It lets its users to retrieve and to st..
Oracle Interview Questions
Define Oracle database
An Oracle database can be termed as a compilation of data housed in a database server and treated like a large unit...
Oracle Interview Questions
Explain Parameter file in Oracle.
Parameter file is a file having a track of initialization parameters and the matching values. The two types of Oracle su..