Detailed Course Outline
Introduction
- Global objectives of the course
- Lessons grouped by modules
- Schedule of the week
Auditing Using Unified Audit
- Quick review of 11g R2 audit trail implementation
- Overview of the Unified Audit Trail
- Creating and enabling audit policies for all users to whom the role is granted directly
- Capturing VPD (Virtual Private Database) generated predicates
Controlling Data Access Using Privileges and Profiles
- New 12.2 administrative privileges
- Password file enhancements
- Enhance the security of administrative users
- Enforce the associated profile’s password limits
- Using mandatory INHERIT PRIVILEGES privilege to execute invoker's rights procedure
- Using mandatory INHERIT PRIVILEGES privilege to select from BEQUEATH current_user views
- Using new INHERIT (ANY) REMOTE PRIVILEGES privilege
Controlling Data Access Using Privilege Analysis
- Overview of database privilege analysis
- Granting the CAPTURE_ADMIN role to enable management of privilege captures
- Creating and starting/stopping privilege captures and runs
- Viewing privilege analysis result
- Querying DBA_PRIV_CAPTURES
Redacting Data
- Overview of Oracle Data Redaction
- Types of Data Redaction Policies
- New redaction format library in EM GUI
- Redaction policy expression
- Redacting with Nullify redaction function
Encrypting Data
- Encrypt / decrypt / rekey tablespaces online
- Configure automatic tablespace encryption
Controlling Data Access Using Transparent Sensitive Data Protection
- Configure and use TSDP with VPD
- Configure and use TSDP with Data Redaction
- Configure and use TSDP with Unified Auditing
- Configure and use TSDP with Fine-Grained Auditing (FGA)
- Configure and use TSDP with Transparent Data Encryption (TDE)
Making Data Available by Using RMAN Features
- RMAN enhancements
- Transport Data Across Platforms
- Table recovery
- Automate the manual recovery process by using Recover Database Until Available Redo
- REPAIR FAILURE command extented
Making Data Available by Using Oracle Data Pump, SQL*Loader and External Tables
- Oracle Data Pump enhancements
- SQL*Loader enhancements
- Querying against external tables and overriding external table clauses
Making Data Available by Performing Online Operations
- Describe online redefinition supports
- Move and compress table partitions ONLINE
Partitioning Data
- Enable reference partitioning with interval partitioned parent tables
- Incorporate the CASCADE option for TRUNCATE PARTITION and EXCHANGE PARTITION operations
- Convert partitioning Range to Interval and vice-versa
- Convert subpartitioning Range to Interval and vice-versa
- Simplify the maintenance of (sub) partitioned tables
- Composite partitioning
Managing Information Lifecycle Using ADO
- Data classification in 12c : tablespace, group, object, row levels
- Configure heat map
- Automatic movement and compression
- Compression levels and types
- Policy declaration
- Customized automated action execution with user-defined function
- Execution in scheduled maintenance windows and by MMON
- Customized schedule with DBMS_ILM package
Managing Information Lifecycle Using In-Database Archiving and Temporal
- Challenges of old data in tables and 11g solutions
- In-database archiving new solutions
- Use ROW ARCHIVAL clause to enable row lifecycle state for applications
- Set ROW ARCHIVAL VISIBILITY for session level visibility control
- Use predicate on ORA_ARCHIVE_STATE column
- Temporal Validity versus Temporal History (Transaction Time of FDA)
- Set a Temporal Validity by using PERIOD FOR clause of CREATE / ALTER TABLE
- New SQL temporal data type
Monitoring DB Operations and Performance
- Overview
- Use cases
- Current Tools
- Define a DB operation
- Monitoring: Bracketing an Operation
- Monitoring the Progress of Operations
- DB Operation Tuning
- DB Operation Active Report
Configuring In-Memory Column Store
- In-Memory Database option goals and benefits
- Row format and columnar format
- New SGA component
- Deployment
- Compression and priority in-memory segments attributes
- Dictionary tables, added columns, IM statistics and IM Advisor
- IM FastStart
- Interaction with other products
Using In-Memory Column Store
- Caching results of frequently evaluated expressions and virtual columns
- Optimizing joined columns by creating join groups
Improving Performance Using In-Memory Caching
- Setting up Full Database In-Memory Caching
- Explaining the two buffer replacement algorithms of Automatic Big Table Caching
- Configuring Automatic Big Table Caching with DB_BIG_TABLE_CACHE_PERCENT_TARGET initialization parameter
- Using Automatic Big Table Caching
Improving SQL Performance
- Statistics gathering performance improvements: Optimizer Statistics Advisor
- Adaptive Execution Plan
- Benefit from automatic dynamic sampling
Using Real Application Testing Enhancements
- SQL Performance Analyzer enhancements
- SQL Plan Management enhancements
- Database Replay enhancements
Improving Performance Using Other Features
- Manage session PGA limit
- Multiple indexes on the same set of columns
- Describe Advanced Row Compression and Avanced Index Compression HIGH level
- Reduce Cursor Invalidations for DDLs
- Define real-time materialized views with on query computation and ON STATEMENT refresh materialized views
- Using multi-process multi-threaded Oracle architecture
- Describe Database Smart Flash Cache enhancements
- Use temporary undo for your temporary tables