Oracle Technology Update

Oracle Database 11g provides grid computing and an improved capability for self-management and automation. This serves to facilitate performance enhancements in conjunction with protecting, auditing, and recalling data.

SYS-ED workshops explain and demonstrate:

• How to provide protection from server failure, site failure, human error, and planned downtime.
• How to secure data and enable compliance with row-level security, fine-grained auditing, transparent data encryption and recall of data.
• The impact of high-performance data warehousing, online analytic processing, and data mining.
• How to properly partition large tables and that performance and high availability requirements are highly dependent upon partitioning tables and indexes into smaller, more manageable components.
• How the cached result set in the Client-Side Query Cache is transparently kept consistent with changes performed on the server side.
• Automatic inter-component deadlock for detecting and automatically executing deadlock detection when such conditions are created or persist in the database.

SYS-ED workshops explain and demonstrate:

• The SQL Test Case Builder, which is a PL/SQL package for gathering in order to reproduce a problem on a different system.
• Intelligent Cursor Sharing which helps in determining whether a cursor will be shared by having its optimizer explicitly evaluate ranges of safe values.
• How a PL/SQL function can be marked to indicate that its result should be cached to allow lookup, rather than recalculation, on the next access when the same parameter values are called.
• The utilization of compound triggers.