|
||||
|
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 […] DBA’s often kill the blocking sessions and from 19c (not sure which patch set) we have new parameter called MAX_IDLE_BLOCKER_TIME parameter which helps to specifies the maximum number of minutes that a blocking session can be idle. After that point, the session is automatically terminated. A session is considered to be a blocking […] 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 […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!