Description: Because there is a finite amount of memory available on a database server and on an Oracle Database 11g instance, you must pay attention to how memory is allocated. Also, database planning must include a balance between performance, cost, and reliability. You must consider the investment in the system architecture, which includes the hardware and software infrastructure needed to meet your requirements. This course explores the database's memory structures, focusing on how to configure SGA parameters and how to implement Automatic Memory Management and Automatic Shared Memory Management, and how to configure automatic PGA memory management. This course also explains how to monitor the performance of sessions and services, including how the Automatic Workload Repository (AWR) works, and how to use the SQL Tuning Advisor to identify and tune SQL statements that are using the most resources. This course also describes the benefits of Database Replay within your Oracle environment.
Target Audience: Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators
Duration: 02:00
Description: To test your knowledge on the skills and competencies being measured by the vendor certification exam. TestPrep can be taken in either Study or Certification mode. Study mode is designed to maximize learning by not only testing your knowledge of the material, but also by providing additional information on the topics presented. Certification mode is designed to test your knowledge of the material within a structured testing environment, providing valuable feedback at the end of the test.
Target Audience: Individuals seeking practice in a structured testing environment, covering the skills and competencies being measured by the vendor certification exam.
Duration: 01:45