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

List any two disadvantages of a database system, List any two disadvantages... List any two disadvantages of a database system ? The disadvantages of database system are: • Database systems are difficult, complex, and time-consuming to design. • Substanti

ER diagram, #question. acompani datdbase needs to store information about e... #question. acompani datdbase needs to store information about employees (identified by a social security number,with salary and phone as attributes) and departments (identified by

What is de-normalization, What is De-normalization? De-normalization is... What is De-normalization? De-normalization is the method of attempting to optimize the performance of a database by adding redundant data. It is sometimes essential because cur

Database recovery and security, Database Recovery And Security Introdu... Database Recovery And Security Introduction In this part we will introduce two main issues relating to database management systems. A computer system suffers from dissi

Can a domain, Can a domain, assigned to a data element be changed? Yes.... Can a domain, assigned to a data element be changed? Yes.  We can do so by just overwriting the entry in the field domain.

What are the kinds of strings, What are the kinds of Strings?  -A binar... What are the kinds of Strings?  -A binary string in MySQL is one that MySQL treats as case sensitive in comparisons. -A non binary string in MySQL is one that MySQL does'nt

What are the overlapping elements, What are the Overlapping elements O... What are the Overlapping elements Overlapping elements can be found by scanning all the elements in front of deleted element in priority list for the sheet and comparing them

What is log shipping, What is Log Shipping? Log shipping is the method ... What is Log Shipping? Log shipping is the method of automating the backup of database and transaction log files on a production SQL server, and then restoring them onto a stand

Define rule that value of foreign key appear in other table, Determine the ... Determine the rule that a value of a foreign key should appear as a value of some particular table is called a  Ans: Referential constraint.    The rule that a value of a fo

Illustrate different types of locks in sql server, Illustrate different typ... Illustrate different types of Locks in SQL Server. There are three kinds of locks in SQL Server i.) Shared locks - These are used for operations which don't allow any update