|
||||
|
Starting 20c, one do not need to bother about index rebuilding, shrinking, managing them. We can automate this using feature Automatic Data Optimization option + marking the indexing to certain tier/policies. The optimization process includes actions such as compressing, shrinking, or rebuilding the indexes: Compress: Compresses portions of the key values […] 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 […] 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 […] To restrict user operations at PDB levels and even more granular restriction, in 12.2 we can create Lock down profiles using “create lock down profile”. Here are some examples CREATE LOCKDOWN PROFILE test; ALTER LOCKDOWN PROFILE test DISABLE STATEMENT = (‘ALTER SYSTEM’); ALTER LOCKDOWN PROFILE test ENABLE STATEMENT = (‘ALTER SYSTEM’) CLAUSE= (‘flush […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!