Infrastructure at your Service

Tag

Oracle 12.2 Archives - Page 3 of 3 - Blog dbi services

Oracle Team

Oracle 12cR2 – Is the SYSDG Administrative Privilege enough for doing Oracle Data Guard Operations?

By | Database Administration & Monitoring, Database management | No Comments

By William Sescu For security reasons, you may want that your DataGuard operations are done with a different UNIX user and with a different Oracle user which is not so highly privileged like the SYSDBA.  This is exactly where the SYSDG Administrative Privilege for Oracle Data Guard Operations comes into play. The SYSDG privilege is quite powerful and allows you to work with the Broker (DGMGRL) command line interface and besides that, it enables the…

Read More
Oracle Team

Oracle 12cR2 – DataGuard and the REDO_TRANSPORT_USER

By | Database Administration & Monitoring, Database management | One Comment

By William Sescu In a DataGuard environment, by default, the password of the SYS user is used to authenticate redo transport sessions when a password file is used. But for security reasons you might not want to use such a high privileged user only for the redo transmission. To overcome this issue, Oracle has implemented the REDO_TRANSPORT_USER initialization parameter. The REDO_TRANSPORT_USER specifies the name of the user whose password verifier is used when a remote…

Read More
Oracle Team

Oracle 12cR2: Statistics Advisor

By | Database Administration & Monitoring | No Comments

By Franck Pachot . Today at #ukoug_tech16 12:30 in hall 11A I’ll talk about Statistics Gathering Best Practice & 12cR2 Statistics Advisor Rather than taking the Optimizer Statistics Advisor rules one by one I’ll show the things to take care (some people may call it best practices) when gathering statistics and they mention the Statistics Advisor Rule. If you need a reference about all rules, you can get it from V$STATS_ADVISOR_RULES

Read More