Overview/Description Optimizer statistics describe details about the database and the objects in the database and are used by the query optimizer to select the best execution plan for each SQL statement. This course covers gathering optimizer and system statistics, setting statistic preferences, using dynamic sampling, and manipulating optimizer statistics. if you use SQL statements where literal values are provided for the WHERE clause conditions, you get results in many versions of almost identical SQL to be stored in the library cache. If, instead of issuing different statements for each...

Overview/Description When considering Oracle security, you must also consider the security of the listener, which is the gateway to the network and the network itself. This course describes the items on the client, listener, and network security checklists. It demonstrates how to secure administration of the network, restrict access by IP address, and encrypt network traffic. Restricting the privileges of the listener, administering the listener securely, and monitoring listener activity are also covered. Target Audience Database administrators, security administrators, security compliance...

Overview/Description To recognize the steps for creating and using efficient PL/SQL packages, including Oracle-supplied packages, executing dynamic SQL, and improving the performance of code. Target Audience System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers. Prerequisites Previous programming experience and knowledge of SQL Expected Duration (hours) 2.3 Lesson ObjectivesOracle Database 11g: Packages, Dynamic SQL, and Coding Considerations recognize the steps for overloading subprograms, using forward...

Overview/Description identify the scope and capabilities of Oracle Database 11g's performance-enhancing tools, such as those for memory management, performance analysis, and statistics gathering. Target Audience Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA's considering upgrading their systems to 11g Prerequisites The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role Expected Duration (hours...