+380.000 other summaries
A unique study tool
A rehearsal system for this summary
Studycoaching with videos
Remember faster, study better. Scientifically proven.
Summary - OCA Oracle database 11g : SQL fundamentals I exam guide (exam 1Z0-051)
1 Oracle Server Technologies and the Relational Paradigm
Oracle Enterprise Manager:
Oracle Enterprise Manager comes in three forms:
is a graphical tool for managing one database, which may be a RAC clustered database.
Application Server Control
is a graphical tool for managing one application server instance or a group of instances.
globalizes the management environment. A management repository ( residing in an Oracle database ) and one or more management servers manage the complete environment: all the databases and applications servers, wherever they may be.
Oracle Application Server:
The Oracle Application Server is a platform for developing, deploying and managing web applications.
RAC ( Real Application Cluster )
Oracle RAC allows multiple computers to run Oracle RDBMS software simultaneously while accessing a single database, thus providing clustering. One database can be opened by many instances.
Oracle defines the term instance as the memory structure and the background processes used to access data from a database.
A session is a user process in communication with a server process. There will usually be one user process per user and one server process per user process.
A paradigm is a set of standards, agreed upon by all those involved, that specifies how problems should be understood and addressed.
Access to the database:
Access to the database is through the Oracle instance. The instance is a set of processes and memory structures: it exists on the CPU(s) and in the memory of the server node and this existence is temporary. It is absolutely impossible in the Oracle environment for any user to have direct contact with the database.