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

Develop motel point of sale software, Project Description: I need a poin... Project Description: I need a point of sale for motels. It needs to run on windows and requires being network able so that we can have more than one computer using it at once.

What is foreign key, What is foreign key? A relation schema r1 derived ... What is foreign key? A relation schema r1 derived from an ER schema may contain among its attributes the primary key of another relation schema r2.this attribute is known as a

Create a database schema, Consider a database schema consisting of four rel... Consider a database schema consisting of four relations, whose schemas are: Product (maker, model, type) PC (model, speed, ram, hd, price) Laptop (model, speed, ram, hd, s

Determine the subsystem design issue, Determine the Other System Design Iss... Determine the Other System Design Issue How to realise subsystems; through hardware or software? How is object model mapped on chosen hardware software? Mapping

Express the ways provided by mysql for pattern matching, Express the ways p... Express the ways provided by MySQL for Pattern Matching? MySQL provides two kinds of pattern matching. 1) One is based on SQL patterns 2) Regular expressions.

Textbook ordering system, Question: Consider the following database rel... Question: Consider the following database relations for a textbook ordering system used by a college bookshop: Book (b-copy#, bname, ISBN#, author, price, subject) Order (s#

ER Diagram, Hi I have got an assignment for making an er diagram for market... Hi I have got an assignment for making an er diagram for market management software can any budy help me?

What is recovery?, What Is Recovery?  During the life of a transaction, ... What Is Recovery?  During the life of a transaction, i.e., a after the start of a transaction but before the transaction commits, various changes may be made in a database state

What is primary key explain, What is primary Key Explain? Primary Key ... What is primary Key Explain? Primary Key - Primary key is one of the candidate keys. It should be selected such in which its attribute values are never, or very rarely, chang

Define partial, Partial Key : It is a group of attributes that can uniquel... Partial Key : It is a group of attributes that can uniquely identify small entities and that are related to same base entity. It is sometime named as Discriminator.  Altern