|
||||
|
Autoupgrade is compatible with 12.2 and 18.5 and you need to download the kit from 2485457.1 Autoupgrade.jar is available default in 19c How this works Prevent Issues : Analyze and Fixup Modes java -jar autoupgrade.jar -config config.txt -mode analyze java -jar autoupgrade.jar -config config.txt -mode fixups Simplifying […] Desupport of Oracle Real Application Clusters for Standard Edition 2 (SE2) Database Edition. Starting with Oracle Database 19c, Oracle Real Application Clusters (Oracle RAC) is not supported in Oracle Database Standard Edition 2 (SE2). Upgrading Oracle Database Standard Edition databases that use Oracle Real Application Clusters (Oracle RAC) functionality from earlier releases to Oracle Database […] ADDM does not work in a pluggable database (PDB) by default, because automatic AWR snapshots are disabled by default in a PDB. Starting 19c , To use ADDM in a PDB, you must enable automatic AWR snapshots in the PDB by setting the AWR_PDB_AUTOFLUSH_ENABLED initialization parameter to TRUE and AWR snapshot interval greater than […] When flashback or point-in-time recovery is performed on the primary database, a standby that is in mounted mode can automatically follow the same recovery procedure performed on the primary. When flashback or point-in-time recovery is performed either on a primary database or a PDB in the primary database, the primary database or PDB is moved […] Starting 19c, Restore points that are created on a primary database are automatically replicated to the standby database. The restore points created on the standby database are called replicated restore points. Irrespective of whether a restore point on the primary database is a guaranteed restore point or a normal restore point, the corresponding replicated restore […] Statistics gathering until 18c was on daily/weekly basis based on the maintainance tasks defined. Say 10PM every day with 8 hour window on weekdays and 24 hrs window on week ends. And how many times we have seen statistics have become stale between two collections and DBA’s has to manually intervene and collect stats. From […] Hi While I am exploring the Oracle 19c Database, I found that docker images are already available in https://github.com/oracle/docker-images/tree/master/OracleDatabase/SingleInstance/dockerfiles/19.3.0 Along side, here is the excerpt from documentation , automatic indexing , quarantine, real time statistics are only available on Cloud versions not on normal EE on prem databases. So , Hail cloud 🙂 https://docs.oracle.com/en/database/oracle/oracle-database/19/dblic/Licensing-Information.html#GUID-AB354617-6614-487E-A022-7FC9A5A08472 […] Oracle 19c was on LiveSQL and I can’t wait to test out the 19c Automatic Indexing features, so I tried to create emp/dept tables and queried to use hint /*+ USE_AUTO_INDEXES */ to use automatic indexing. To my dismay, I forgot the fact that LiveSQL is on Exadata and index scans not possible unless settings. […] Really???. Straight from the OOW#18 updates in Twitter, LinkedIn, various posts. Here is the snippet I got it from twitter from Franck Pachot & Maria Colgan posts. This is how it may/will works :). Runs as background task at Fixed and Limited time. “Do not impact your application” ??? True, read below, Follow a predefined […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!