The Oracle Database server consists of an Oracle Database and one or more Oracle Database instances. SQL (Structured Query Language) is the language with which all programs and users access an Oracle Database. Monitoring the performance of and tuning database components, as well as the SQL statements used to access and manipulate the database, helps to ensure the Oracle Database server runs efficiently and as expected. This course explores the major architectural components of the Oracle Database server, memory structures, background processes, and physical and logical storage structures. It also examines SQL tuning, identifying the attributes of a SQL statement that can make it perform poorly, SQL tuning tools, and common tuning tasks. The steps involved in the execution of a SQL statement, the optimizer and its phases, and controlling optimizer behavior are also covered.

Ups.. It seems there are no reviews for this training yet! Go on and be the first to write a review!