Write a short note on oracle instance, Database Management System

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







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
Related Questions
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 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 of literals values that have been specified? BETWEEN operator is used to compare a value to a list of literals values that h

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? 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

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

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

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. Ans: Two-phase locking is significance in the context of ensuring that schedules are serializable. The two-phase locking protocol defines a p

Why is need for the multiple access paths?