12c Database
TOracle Sharding Feature (12.2 New Feature)
| Oracle Sharding (12.2) | Install & Configure Shards (12.2) | Managing Shards |
12c Architecture with Multitenant Databases
Administration & Development Enhancements
Information Life Cycle Management & Compression Enhancements
| ILM – Automatic Data Optimization | ILM – ADO – Practice | Flashback data archive (FDA) with optimization (i.e Compression) |
| New Names in compression |
Partitioning Enhancements
Data loading
| SQL Loader express loading | Datapump Enhancements – Export | Datapump Enhancements - Import |
Security
| Unified Auditing – Overview | Unified Auditing - Practice | Sec_case_sensitive_logon – Upgrade gotcha |
| Privilege Capture | Deprecated features in Oracle Security | Resource role does not contain unlimited tablespace option |
| Select any Dictionary no more sensitive |
RMAN
Optimizer & Performance Tuning
| Adaptive Query Optimization | Adaptive Execution Plans | Automatic Reoptimization (Statistics Feedback & Dynamic statistics) |
| SQL Plan Directives | SPM with Adaptive Query Optimization | Approximate Query Processing (12.2) |
| Other Features | ||
| Monitor Database Operations | Hybrid Histograms | DBMS_XPLAN Reporting Mode |
| Custom Clustering Factor | Approximate Aggregations (12.2) | |
| Statistics Enhancements | ||
| CTAS collects statistics | GTT – Session level statistics | DBMS_STATS in Reporting Mode |
| Statistics Advisor Task (12.2) |
Grid Infrastructure
| Flex Cluster – Overview | Convert Normal cluster to Flex Cluster | IPV6 Support for cluster connect |
RAC
| Global Data Services | srvctl in evaluation mode | Application Continuity – Transaction Guard |
Automatic Storage Management
Dataguard
| Fast Sync | Far Sync Standby | Global Temporary Tables in DG |
| Network Recovery | MultiInstance Redo Apply (12.2) | Nologged Blocks Recovery(12.2) |
Upgrade
| New Script | Parallel Upgrade |
18c Database
Installation Enhancements
| RPM Based Installation | Image Based Installations | Install PSM Utility to Manage Oracle Infrastructure in cloud |
| Using PSM Utility | Readonly Oracle Homes |
General
Backup & Recovery
| Duplicate PDB with RMAN |
ASM
| ASM Mirror for PDB Clone | ASM Diskgroup Enhancements | |
RAC & Grid
| Shared SCAN Listeners |
Dataguard
| Automatic recover of nonlogged blocks | Multi Instance Redo Apply | v$dataguard_process view instead of v$managed_standby |
| Rollfoward Standby using Service |
CDB & PDB's
| Refreshable PDB Switchover |
Database Performance
| DBMS_SQLTUNE instead of DBMS_SQLSET |
19c Database
Oracle 19c New Features Articles & Installation Page.
Not lot but good exciting ones.
Installation & Upgrades
- Standard Edition 2- RAC Desupported
- Simplified Image based installation of client as well
- RPM Based Installation
- Docker Container for 19c
- Auto Upgrade Utility
- DryRun mode for GridSetup in clusterware Installation
- CreateDuplicateDB in DBCA Silent Mode
General
- SQL Quarantine
- Clear flashback logs periodically
- EZConnect Enhancements
- Max_Idle_Time_Blocker to terminate blocking sessions automatically
- ADDM Analysis at PDB Level
- Multimodel partitioning with Hybrid partitioning allowing some partitions in the database and some as external partitions even in hdfs.
- Password Enhancements
Performance
- Automatic Indexing - Manage Auto Indexes with Advisory task like MOnitor, Capture, Identify, Verify, Decide
- SQL Statement Diagnostability with SQL Advisor repair and SQL Test case for procedures
- Realtime statistics for DML Operations
- Statistics Collection on custom frequency automatically
RAC
- Zero downtime Grid Patching
- Root.sh script automation's
Dataguard
- Replicate Restore Points from Primary to Standby
- Automatic Flashback of Standby
- DML redirect to standby
- Configure FSFO in observer mode
- Dynamic Service Failover to Standby
Deprecated & De Supported features
Grid
- Clone.pl
- addnode.sh
Oracle 19c and 20c (preview) now contains Machine Learning algorithms directly can called from database itself. And as I am not at all expert in this and I was looking for right examples and came across this superb video on how to use them from none other than oracle analytics expert “Brendan Tierney”
Starting 20c, one do not need to bother about index rebuilding, shrinking, managing them. We can automate this using feature Automatic Data Optimization option + marking the indexing to certain tier/policies.
The optimization process includes actions such as compressing, shrinking, or rebuilding the indexes:
Compress: Compresses portions of the key values […]
Starting 20c, the following datapump enhancements are available as per new features guide which are more useful to DBA on day to day.
Resume Transportable Tablespace Jobs Oracle Data Pump resumes transportable tablespace export and import jobs that are stopped. Oracle Data Pump has the capacity to resume transportable tablespace export and […]
In Oracle database 20c, flashback and PITR are supported when recovering PDBs to an ancestor or orphan PDB incarnations. That means you can do a recovery for specific PDB if the PDB is in the same CDB level incarnation. Just to mention in 12.1 also we can do flashback and PITR for container databases […]
Most of time developers writes multiple procedures or pl/sql code with relevant conditions and blocks to simplify operations , but the complexity grows and number of joins increases the operations of SQL Engine and PLSQL engine has to involved more and do more context switching at the cost of performance. In Oracle Database 20c, […]
With Oracle 20c, (as per preview details), introduced a new BASE_LEVEL value for the INMEMORY_FORCE parameter. When this new value is set the INMEMORY_SIZE parameter can be set up to a value of 16GB without having to license the Database In-Memory option. In fact, when the BASE_LEVEL value is set you cannot set the […]
SecureFiles Defragmentation
SecureFiles defragmentation provides online defragmentation of allocated and freed space in SecureFiles segments, for all types of SecureFiles LOBs – compressed, deduplicated, encrypted. Defragmentation can be done automatically by a background process, and the segment advisor can estimate the fragmentation levels and how much space can be saved. Defragmentation can […]
Starting 20c, One can keep expression in Initialization Parameters. some examples from documentation as below
Initialization parameter expressions can contain the following constructs:Integer values
OLAP_PAGE_POOL_SIZE = 1073741824
Decimal values, only when they are part of a numeric operation
CPU_COUNT = 8 * 0.6
If the operation resolves to a decimal value, then the result […]
In oracle 20c, JSON is a new SQL and PL/SQL data type for JSON data. The data is stored in the database in a binary form for faster access to nested JSON values. You can use JSON data type and its instances in most places where a SQL data type is allowed, including:
As per recent update in blogs.oracle.com, Oracle is planning to include a Standard Edition High Availability solution with Oracle Grid Infrastructure that provides cluster-based failover for Standard Edition Oracle Databases using Oracle Clusterware.
No comments:
Post a Comment