|
||||
|
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 […] Cloud Feature – Not working in On Prem installation. Oracle Database 12c introduced online statistics gathering for CREATE TABLE AS SELECT statements and direct-path inserts. Oracle Database 19c introduces real-time statistics, which extend online support to conventional DML statements. Because statistics can go stale between DBMS_STATS jobs, real-time statistics helps the optimizer generate more optimal […] 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 […] Edited this post on 30-Apr, to correct my command in the test. Update the post on 22-May, not working in on-prem as expected. Whilst the documentation say’s the auto indexing feature is not available on-prem ones, I tried to test it out. Command to enable auto index mode is below, we have options “Implement”, “Report-Only”, […] Starting Oracle 19c, SQL Quarantine features helps to prevent reuse of same execution plan which was terminated by resource managers due to resource limits. This will help not to run the rouge queries again on the database if the resource manager is active. SQL Quarantine will need to setup configuration and define thresholds for specific […] Hi In this post we will see how to install Oracle 19c Database using RPM method with Vagrant Virtual box and via ansible playbook. Pre-reqs You need to have vagrant installed in your machine. Steps: Download the repository for Vagrant and Ansible playbook here Download 19c database rpm from Oracle downloads and copy into your […] 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 […] Hello All, Oracle 19c is available officially for download , cant wait to test automatic indexing feature. Keep you posted. https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html Thanks Suresh |
||||
Oracle 23c New Features for DBA's
Follow Me!!!