Write a short note on oracle Instance?

Oracle Instances: An instance is the (executed) Oracle software and the memory they use. It is the instance which manipulates the data stored within the database. It can be begin independent of any database. It consists of:

1) A shared memory area which gives the communication among several processes.
2) Upto five background processes that handled several tasks.
Whenever an oracle examples starts, the file ‘INIT.ORA' is executed.

Posted Date: 5/10/2013 2:07:32 AM | Location : United States

Ask an Expert

Related Discussions:- Write a short note on oracle instance, Assignment Help, Ask Question on Write a short note on oracle instance, Get Answer, Expert's Help, Write a short note on oracle instance Discussions

Write discussion on Write a short note on oracle instance
Your posts are moderated

Write your message here..

Related Questions

Candidate keys, Super keys of a relation can have extra attributes. Candida... Super keys of a relation can have extra attributes. Candidate keys are minimal super key, i.e. such a key have no extraneous attribute. An attribute is known as extraneous if even

Define deadlock prevention, Define Deadlock prevention These protocols... Define Deadlock prevention These protocols make sure that the system will never enter a deadlock state. There are two methods to deadlock prevention. One approach makes sure t

Which operator is used to compare a value to a list literals, Which operato... Which operator is used to compare a value to a list of literals values that have been specified? BETWEEN operator is used to compare a value to a list of literals values that h

Create the table, Question: Using the data model express the following ... Question: Using the data model express the following queries in SQL. (a) Create the Table named "Cinema" and make the cinema_code to be the primary key of the relation and

What is functional dependency, What is Functional Dependency? A Functi... What is Functional Dependency? A Functional dependency is shown by X Y among two sets of attributes X and Y that are subsets of R specifies a constraint on the possible tuple

ER diagrams, explain exhaustively the problems associated with ER diagrams.... explain exhaustively the problems associated with ER diagrams. include illustrations in your answer

Describe the iterative and incremental life cycle, Describe the iterative a... Describe the iterative and incremental life cycle For an iterative and incremental life cycle, two criteria are process and time. The main components of showing a project devel

Advantages of database systems, Problem 1. Describe the following a)... Problem 1. Describe the following a) Advantages of Database Systems b) Functions of a DBMS Explanation of part (a) and (b) 2. Explain the following concepts w

Define two-phase locking protocol, Define two-phase locking protocol. A... Define two-phase locking protocol. Ans: Two-phase locking is significance in the context of ensuring that schedules are serializable. The two-phase locking protocol defines a p

Multiple access path, Why is need for the multiple access paths? Why is need for the multiple access paths?