Oracle architectural components

Overview of Primary Components The Oracle architecture includes a number of primary components, which are discussed further in this lesson. Oracle server: There are several files, processes, and memory structures in an Oracle server; however, not all of them are used when processing a SQL statement. Some are used to improve the performance of the database, to ensure that the database can be recovered in the event of a software or hardware error, or to perform other tasks necessary to maintain the database. The Oracle server consists of an Oracle instance and an Oracle database.

48p trinh02 28-01-2013 92 8   Download

After completing this appendix, you should be able to do the following: Describe the Oracle Server architecture and its main components List the structures involved in connecting a user to an Oracle instance List the stages in processing: Queries DML statements Commits

30p trinh02 28-01-2013 62 3   Download

Client-Server Application Connection Oracle Net enables a network connection between a client and an Oracle database server. Oracle Net is a software component that resides on both the client and on the Oracle database server. It is layered on top of the network protocol. When a connection is initiated from a client to the Oracle database server, data is passed down a stack on the client, over the network, and up a similar stack to the Oracle database server.

18p trinh02 28-01-2013 67 6   Download

After completing this lesson, you should be able to do the following: Describe the factors that affect planned and unplanned downtime Describe the basic components of Oracle Data Guard Explain the differences between physical and logical standby databases Explain the benefits of creating a Data Guard environment Explain the use of Data Guard in high-availability architectures

20p nghianguyenluong 30-06-2009 317 93   Download