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

Your posts are moderated

Write your message here..

Related Questions

RDM & ER Modelling #questiRegional Gardens has many nurseries, including Wagga Wagga, Bathurst, Albury, Orange, and Dubbo. Each nursery is known by its campus code, eg WW, B, A, O

Define the canonical cover Define the Canonical cover Ans: A canonical cover F c for F is a set of dependencies like F logically implies all dependencies in F c , and F c logically

Database administrator Database Administrator One of the main perpose for having the database management system is to have control of both data or programs accessing that data.

What is a transaction What is a Transaction? A transaction is an event which happens on the database. Generally a transaction reads a value from the database or writes a value t

When are they useful justify with an exa... When are they useful? Justify with an example. The temporary tables are commonly used to support specialized rollups or exact application processing needs.

Determine the persistent object Determine the Persistent object Persistent object can be stored in one of the following: Files Cheap, permanent, simple storage Low level (

Scope of traffic data management A TDMS project plan is not a typical Information Technology project plan; therefore, a traffic data project has several unique characteristics: Traffic da