Oracle Technology Update Knowledge Base Computer Education CETi
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.