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

Your posts are moderated

Write your message here..

Related Questions

Type of views-data control, Type of views :  Simple views and Difficult ... Type of views :  Simple views and Difficult Views Feature Simple Views Complex Views Number of tables One

Explain the process-oriented decomposition, Breaking into Subsystems D... Breaking into Subsystems Decomposition is a significant technique for coping with complexity based on idea of divide and conquers. In dividing a problem into sub problems, the

Discuss how the bi-directional implementations are made, Discuss how the bi... Discuss how the bi-directional Implementations are made. In bi-directional implementation of the association, a pair of references must implement every link. The declarations a

What are the types of reference, What are the types of reference?explain it... What are the types of reference?explain it with suitable examples? Object oriented language given the ability to refer the object attribute of the type can be referred to the s

Database part of ldb?, Is it mandatory to declare all the tables in Report ... Is it mandatory to declare all the tables in Report by the key word tables for all the tables that exist in the structure of LDB, and are being explained in the Database part of LD

What are data models, What are data models? Explain it detail? Entity ... What are data models? Explain it detail? Entity relationship model Rectangles Ellipse Diamonds Lines Relational model Relational model use a collection

What is system catalog or catalog relation, What is system catalog or catal... What is system catalog or catalog relation? How is better known as? A RDBMS maintains a explanation of all the data that it contains, information about every relation and index

What is trigger, What is trigger Triggers are statements that are imple... What is trigger Triggers are statements that are implemented automatically by the system as the side effect of a change to the database.

Structure of distributed database, Structure Of Distributed Database: A di... Structure Of Distributed Database: A distributed database system haves of a collection of sites, each of which keeps a local databases system. Every site is able to process local

Give detail description on transactions, Give detail description on Transac... Give detail description on Transactions. - Using transactions we can group all SQL commands into a single unit. - Transaction begins with some task and finishes only when a