|
||||
|
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. Image Source: Blogs.oracle.com This will help customers who are on standard edition license to level high availability features that are […] Oracle Open world 2019 – Interesting updates so far. Oracle Cloud – Free Tier – Always Free Services- 1 ADW, 1 ATP , 2 Compute services always free Oracle Database 20c BlockChain table type Desupport of non-cdb architecture, facilitating 3 PDB’s with no cost Native Persistent Database Memory (PMEM) – Automated Machine Learning Binary Json […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!