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
1 - Serial RS232 comm port comunication 2 - NanoHTTPD serving a few processed pages 3 - System tray application to indicate status and access configuration forms 4 - SQLit

#ques 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 p

Given the following set of functional dependencies {cf→ bg, g → d, cdg → f, b → de, d → c} defined on R(b,c,d,e,f,g) a. Is cf→ e implied by the FDs? b. Is dg a superkey?

Describe the nested-loop join and block-nested loop join.   Ans:   The block nested- loop join algorithm is as described below:     for every block B r of relation R do beg


What is Relational DBMS This is our subject of study. A DBMS is relational if the data is organized into relations, that is, tables. In RDBMS, all data are kept in the well-kno

explain normalization,and give the examples 1NF,2NF,3NF,BCNF.AND FUNCTIONAL DEPANDENACY AND DECOMPOSITION TECHNIQUES.

folding method and mid square method using visual basic

How is the database organised in Oracle? Database organized within Oracle in terms of table and table holds attributes and values. A database consists of one or more logical

Which two files are used during operation of the DBMS? Data dictionary and transaction log are two files used during operation of the DBMS.