adspace


Explain oracle instance.

Answer Posted / Anurag Chaturvedi

An Oracle instance is the runtime environment of an Oracle database. It consists of a SGA (System Global Area) and one or more background processes that manage various tasks such as recovery, memory management, and file I/O. The Oracle instance communicates with clients through SQL*Net protocol.nnWhen you start the database, both system global area (SGA) and background processes are allocated, creating an Oracle instance.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oracle latest version?

1173


How to write a left outer join with the where clause in oracle?

1151


How to start an oracle instance?

1103


Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1955


How to use values from other tables in update statements using oracle?

1156


How to put more than 1000 values into an oracle in clause?

1113


How to select all columns of all rows from a table in oracle?

1127


Design database draw er diagram for a certain scenario ?

4654