Infrastructure at your Service

Tag

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

Oracle Team

Oracle 12cR2 – Howto setup Active DataGuard with Temporary Tablespace Groups

By | Database Administration & Monitoring | No Comments

By William Sescu Temporary Tablespaces Groups exist for quite a while now (since 10gR2), but they are, for whatever reason not so often used. Personally, I think they are quite cool. Very easy to setup, and especially in big environments with a lot of parallel processing very useful. But this blog will not be about Temporary Tablespace Groups. They are already explained in the 12.2 Admin Guide. https://docs.oracle.com/database/122/ADMIN/managing-tablespaces.htm#ADMIN-GUID-55A6AE10-6875-4B73-9A5C-CB4965AD5AFE For my Active DataGuard environment, I would…

Read More
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