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
The File Based System File based systems are an early attempt to computerise the manual filing system. For example, a manual file can be set up to hold all the correspondence r

Let us first describe the term relationships. What Are Relationships? A relationship can be defined as: A set of associations or connection, or A rule for communic

a.  Construct a query around any one of the functional divisions you made in 4a such that if executed in the distributed design of 4 would require reconstruction of at least two ho

What is a hash index? A hash index organizes the search keys, with their associated pointers, into a hash file structure.

What is a heterogeneous distributed database? In a heterogeneous distributed database, dissimilar sites may use different schemas, and dissimilar dbms s/w. The sites may not be

Question : Object-Oriented Database (OODM) is defined as a logical data model that captures the semantics of objects supported in object-oriented programming. An Object-Oriente

Explain the function of Object model Object model describes the classes of objects in system, including their attributes and operations which they support. The analysis object

List the SQL domain Types? SQL supports the following domain types. 1) Char(n) 2) varchar(n) 3) int 4) numeric(p,d) 5) float(n) 6) date.

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 meant by computing the closure of a set of functional dependency? The closure of F denoted by F + is the set of functional dependencies logically implied by F.