Kıbrıs Oracle Database 23ai: New Features for Administrators Eğitimi

  • Eğitim Tipi: Classroom
  • Süre: 3 Gün
  • Seviye: Intermediate
Bu eğitimi kendi kurumunuzda planlayabilirsiniz. Bize Ulaşın!

This course covers the latest additions and improvements in Oracle Database 23ai. It equips Oracle Database Administrators with knowledge about enhanced tools for better management, focusing on performance, architecture, security, and database sharding. The topics include updates to Blockchain Tables, Data Migration with RMAN, Wide Tables, and Lock-Free Reservations.

Existing database administration experience on a modern version of Oracle Database.
Please note: In order to provision you with your courseware and lab access for this course QA must share several items of basic personal information with our partner (usually your full name and email address). For more information on this please visit our QA Partner data sharing page. If you have any questions or concerns please contact your QA account manager.

Module 1: Blockchain Table
Blockchain Tables 23c New Features
  • Objectives
  • Blockchain Table Overview
  • Blockchain Table User Chains
  • Blockchain Table Delegate Signer
  • Blockchain Table Countersignature
  • Summary
Module 2: Availability
Simplified Database Migration Across Platforms Using RMAN Backups
  • Objectives
  • Overview
  • Methods of transporting with Recovery Catalog
  • Methods of transporting in NOCATALOG mode
  • Methods of transporting over network link
  • Prerequisites generic
  • Prerequisites specific
  • Recovery Catalog methods for PDBs
  • Transport a PDB by using a pre-existing Backup with Recovery Catalog
  • Transport a PDB using multiple increamental Backups with Recovery Catalog
  • Recovery Catalog methods for Tablespaces
  • Recovery Catalog method for Tablespaces
  • Transport a Tablespace by using a pre-existing Backup with Recovery Catalog
  • Transport a Tablespace using multiple incremental Backups with Recovery Catalog
  • Transport a by using multiple incremental Backups with Recovery Catalog
  • Methods of transporting in NOCATALOG mode
  • NOCATALOG mode for PDBs
  • Quickly transport a PDB NOCATALOG
  • Transport a PDB using a pre-existing Backup NOCATALOG
  • Transport a PDB using multiple incremental Backups NOCATALOG
  • NOCATALOG mode for Tablespaces
  • Quickly transport a Tablespace NOCATALOG
  • Transport a Tablespace by using a pre-existing Backup NOCATALOG
  • Transport a Tablespace using multiple incremental Backups NOCATALOG
  • Methods of transporting over Network Link
  • Quickly transport a PDB over Network Link
  • Transporting PDBs by Restoring Backups Incrementally over the network
  • Methods of transporting over Network Link
  • Transporting Tablespaces over Network Link
  • Quickly transport a Tablespace over Network Link
  • Transporting Tablespaces by Restoring Backups Incrementally over the network
  • Summary
Automatic Transaction Rollback
  • Objectives
  • Overview
  • Using Automatic Transaction Rollback
  • Automatic Transaction Rollback
  • Using Automatic Transaction Rollback
  • Monitoring
  • Benefits
  • Summary
Automatic Transaction Quarantine
  • Objectives
  • Overview
  • Automatic Transaction Quarantine: Workflow
  • Monitoring Quarantined Transactions
  • Resolving Quarantined Transactions
  • Resolving Quarantined Transaction examples
  • Dropping Quarantined Transactions
  • Quarantined Transactions escalation
  • Summary
Flashback Log Placement
  • Objectives
  • Flashback Log overview
  • Flashback Log parameters
  • Flashback Log management
  • Summary
Module 3: Database Architecture
Unrestricted Direct Loads
  • Objectives
  • Direct Loads pre 23c
  • Direct Loads 23c
  • Benefits
  • Summary
Lock-Free Reservations
  • Objectives
  • Optimistic vs Lock Free
  • Optimistic approach
  • Lock-Free approach
  • Frequently modified values
  • Lock-Free reservations
  • Lock-Free reservation features
  • Lock-Free reservation benefits
  • Functionality requriements
  • Create, Modify, Delete
  • Lock-Free Journal Table
  • Journal Table restrictions
  • Lock-Free reservations
  • Views
  • Summary
Unrestricted Parallel DMLS
  • Objectives
  • Overview parallel DML
  • 23c parallel DML improvements
  • Benefits
  • Summary
Wide Columns
  • Objectives
  • Priori challenges
  • Benefits
  • Increase Column Limits
  • Performance
  • Summary
Improved Performance Hybrid Columnar Compression (HCC)
  • Objectives
  • HCC pre 23c
  • HCC in 23c
  • Database compatibility
  • Performance
  • Summary
Module 4: Performance
Fast Inserts Enhancements
  • Objectives
  • Fast Ingest overview (AKA Deferred Inserts)
  • Using Fast Ingests
  • Enhancements
  • Benefits
  • Management
  • Summary
Accelerate SecureFiles LOB Write Performance
  • Objectives
  • Overview
  • Benefits
  • Summary
Data Storage Improvements
  • Objectives
  • SecureFiles
  • Traditional SecureFiles Shrinking
  • Automatic SecureFiles Shrinking: Advantages
  • High-level view
  • Controlling Automatic SecureFiles Shrink
  • Automatic storage compression
  • Automatic storage compression and automatic clustering
  • Automatic storage compression: Advantages
  • Controlling Automatic storage compression
  • Summary
Module 5: Data Analytics
Oracle Dataase 23c Automatic SQL Plan Management: New Features
  • Objectives
  • Automatic SQL Plan Management: Overview
  • SPM Evolve Advisor
  • Benefits
  • Problems it solves
  • When to use
  • how to use it
  • Summary
Module 6: Manageability
Time and Date Handling Changes
  • Objectives
  • Enhanced Time Zone data upgrade
  • Time Zone definitions change: Considerations
  • Optimizing Time Zone file upgrade
  • Benefits of enhanced Time Zone update
  • Tables with TIMESTAMP WITH TIME ZONE data
  • New parameter in the init.ora file
  • Configuring database parameters
  • SYSDATE and SYSTIMESTAMP
  • Data and Time in Oracle databases
  • Database time verus OS System time
  • Database-specific time in Oracle database 23c
  • Setting Database-specific time: Example
  • Summary
Module 7: Security
Oracle Database 23c Security: New Features
  • Objectives
  • Database Security
  • Pluggable Database Hybrid Read-only mode
  • Read-Only user and session
  • New Developer role
  • Simplified Schema privileges
  • Simplified Schema privilages: Example
  • Audit object actions at the column level
  • Ability to control authorizations for Unified Auditing with Database Vault
  • Integration of Microsoft Azure Active Directory with additional Oracle database environments
  • Summary
Module 8: Sharding
Oracle Database 23c Sharding New Features
  • Objectives
  • Database Sharding
  • Oracle database Sharding
  • Oracle database 23c Sharding new features
  • Sharding native replication (RAFT-based)
  • Directory-based Sharding
  • Coordinated Backup and Restore for Sharded databases
  • Centralized Backup recovery
  • Automatic bulk data move on Sharding key update
  • Split/Move of a partitionset with bulk data movement
  • Summary
Eğitimlerle ilgili bilgi almak ve diğer tüm sorularınız için bize ulaşın!

Yakın tarihte açılacak eğitimler

Sınıf eğitimlerimizi Kıbrıs ofislerimizde düzenlemekteyiz. Kurumunuza özel eğitimleri ise, dilediğiniz tarih ve lokasyonda organize edebiliriz.

Classroom / Virtual Classroom
23 Ocak 2025
Lefkoşa, Girne, Gazimağusa
3 Gün
Classroom / Virtual Classroom
26 Ocak 2025
Lefkoşa, Girne, Gazimağusa
3 Gün
Classroom / Virtual Classroom
18 Şubat 2025
Lefkoşa, Girne, Gazimağusa
3 Gün
Classroom / Virtual Classroom
23 Ocak 2025
Lefkoşa, Girne, Gazimağusa
3 Gün
Classroom / Virtual Classroom
26 Ocak 2025
Lefkoşa, Girne, Gazimağusa
3 Gün
Classroom / Virtual Classroom
06 Mart 2025
Lefkoşa, Girne, Gazimağusa
3 Gün
Classroom / Virtual Classroom
18 Şubat 2025
Lefkoşa, Girne, Gazimağusa
3 Gün
Classroom / Virtual Classroom
20 Mart 2025
Lefkoşa, Girne, Gazimağusa
3 Gün
Oracle Database 23ai: New Features for Administrators Eğitimi Kıbrıs

Kuzey Kıbrıs olarak da bilinen Kıbrıs Türk Cumhuriyeti (KKTC) Akdeniz’de yer alan dünyanın en büyük üçüncü adası Kıbrıs’ta bulunmaktadır. Ülkenin resmi dili Türkçe, başkenti Lefkoşa, Cumhurbaşkanı Ersin Tatar ve para birimi Türk Lirası’dır. Akdeniz ikliminin hakim olduğu bu ülkenin toplam yüz ölçümü 3.550 kilometrekaredir. Yunan mitolojisinde aşk tanrıçası Afrodit’in mekanı olan Kıbrıs’ta M.Ö. 10000 yıllarından beri yerleşim olduğu tahmin edilmektedir.

Doğa güzellikleri, tertemiz sahilleri, plajları ve sakin köyleriyle her yıl çok sayıda turist ağırlamakta olan Kıbrıs’ın en popüler bölgeleri arasında Avakas Gorge, Gavur Taşı, Girne Kalesi, Olimpos Tepesi, Limassol Marina, Cape Greco Milli Parkı, Millomeris Şelalesi ve Afrodit Hamamları sayılabilir.

Bilginç IT Academy Tüm Hakları Saklıdır

Sitemizi kullanarak çerezlere (cookie) izin vermektesiniz. Detaylı bilgi için Çerez Politika'mızı inceleyebilirsiniz.