|
||||
|
If and if anytime you need to test it ignore hints or you have legacy codes, you can set ignore hint parameters. Before to 18c this is parameter is a hidden parameter “_Optimizer_ignore_hints” and been obsoleted. This can be set at system/session level. alter system set optimizer_ignore_hints=TRUE In addition, there is another parameter […] 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, […] 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. […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!