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
Give the Introduction of OBJECT DESIGN Strategies which are selected during system design are carried out in object-oriented design. In this procedure, objects which are identi

State the Design of Associations Before designing associations, it is essential to know the way they are used. For this, analysis of association traversals is required. It is

Two Phase Locking (2PL) The two-phase locking protocol having of two phases: Phase 1 : The lock acquisition phase : If a transaction T needs to read an object, it wants to

Define weak and strong entity sets? Weak entity set: entity set that do not have key attribute of their own are known as weak entity sets. Strong entity set: Entity set that

Explain current page table and shadow page table. The key idea behind the shadow paging method is to maintain two page tables during the life of the transaction: the current pa

Find the names of all Albums that have more than 30 tracks. Result: (name: varchar(255))

Define the concept of Object Diagram An object diagram shows a set of the objects and their relationships with each other at a point of time. In a static view, object diagram

) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a picto

What was the method in which records are physically stored in a specified order according to a key field in each record ? A method in which records are physically stored within

Explain the term - Adjustment of inheritance The inheritance can be enlarged as object design progresses by changing class structure. The designer should do: i) Adjust or r