|
||||
|
Starting 19c, We can run DML operations on Active Data Guard standby databases. This enables you to run read-mostly applications, which occasionally execute DMLs, on the standby database. Automatic redirection of DML operations to the primary can be configured at the system level or the session level. The session level setting overrides the system level […] In Previous versions Oracle, When a service moves to an available instance, Oracle Database does not automatically move the service back to the preferred instance when the preferred instance restarts because: The service is running on the desired number of instances. Maintaining the service on the current instance provides a higher level of service availability. […] 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 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 […] 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!!!