SQL tutorial | Interview questions | Oracle
Would you like to react to this message? Create an account in a few clicks or log in to continue.
SQL tutorial | Interview questions | Oracle

Database administration, oracle Interview questions, SQL Interview questions, DBMS Interview questions,SQL tutorial


What Is an Oracle Instance?

SQL tutorial | Interview questions | Oracle :: Interview questions :: Oracle DBA Interview questions

Go down

What Is an Oracle Instance? Empty What Is an Oracle Instance?

Post by Micheal Sat Jan 16, 2010 8:54 pm

Every running Oracle database is associated with an Oracle instance. When a database is started on a database server (regardless of the type of computer), Oracle allocates a memory area called the System Global Area (SGA) and starts one or more Oracle processes. This combination of the SGA and the Oracle processes is called an Oracle instance. The memory and processes of an instance manage the associated database's data efficiently and serve the one or multiple users of the database.

Micheal
Admin

Posts : 243
Join date : 2010-01-10

http://sql-tutorial.co.cc

Back to top Go down

Back to top

- Similar topics

SQL tutorial | Interview questions | Oracle :: Interview questions :: Oracle DBA Interview questions

 
Permissions in this forum:
You cannot reply to topics in this forum