DB Projects Help >> Oracle architecture
ORACLE makes and uses storage components to complete several work. For example, storage is used to store rule being carried out and details that is discussed among users. Several basic storage components are associated with ORACLE: the program international region (which includes the collection and update log buffers, and the discussed pool) and the application international region.
System Global Area (SGA) is a discussed storage region assigned by ORACLE that contains details and management details for one ORACLE example.
An ORACLE example contains the SGA and the background processes.
The SGA is assigned when an example starts and deallocated when the example ends down. Each example that is begun has its own SGA.
The Program Global Area (PGA) is a storage stream that contains details and management details for a web server procedure. A PGA is created by ORACLE when a web server procedure is begun. The details in a PGA will depend on the settings of ORACLE.
A procedure is a ''thread of control'' or a procedure in an os that can do a sequence of actions. Some systems use the phrases job or process. An ORACLE collection program has two common types of processes: person methods and ORACLE methods.
A person procedure is created and managed to do the software value of an application (such as a PRO*C program) or an ORACLE instrument (such as SQL*PLUS). The person procedure also controls the connection with the web server methods. Customer methods connect with the web server methods through the application screen.
ORACLE methods are called by other methods to accomplish features on part of the invoking procedure. ORACLE makes a web server procedure to deal with needs from attached person methods. ORACLE also makes a set of historical past methods for each instance
DBMS Assignment Help - Homework Help at Expertsmind.com
Experts at Expertsmind.com offers DBMS homework help, DBMS assignment help and projects help with best online support from qualified and experienced DBMS tutors. We provide optimized database problems and solutions, university assignments and best online tutor for database management course help. Our expert tutors have proven their excellence and we have done many projects in database management system. Find your database question's answers here at Expertsmind.com by just one step ahead by submitting your homework.