Originally introduced for non database data,  Oracle ASM Cluster File System (ACFS) added the support  Oracle database files in Oracle 12c.  Today IT organizations may leverage Oracle ACFS to establish pooling of storage across database, middleware and applications in their private Cloud. Come to this session to explore the Oracle ACFS and how it is…

"Today’s organizations are subject to greater and greater demands for auditing and compliance; including SOX, HIPAA, PCI and a host of other external requirements. Learn how change tracking techniques can help you identify and track database changes and build a database for use by auditors.Eligible for Certificate: #IOUGeniusCert; #IOUGeniusSecure Info: www.collaborate.ioug.org/certificates  "

The Oracle High Availability Architecture with Oracle 12c RAC as the main pillar emerged as the foundation for the Application Resiliency.  Business continuity, high availability, scalability, flexibility and the agility combined with easy management are the key benefits of the Oracle 12c RAC.  When combined with the HA components like Flashback features, Flex ASM, Transaction…

Different databases behave differently. To come up with a set threshold to monitor the load of a database is a challenge. Baseline thresholds are good for systems that have repeatable patterns, but will not hold good for systems whose behaviour changes over time and has bursts of load. The approach we use at Google is…

Oracle Redaction and Transparent Data Encryption are the most advanced features available in Oracle12c to guarantee optimal database security and data protection, by utilizing a combination of encryption standards and data retrieval methods and policies beyond SQL execution, which enable specialized administrators to fully condition access to private information, using encryption, row-level with either role-driven or…

In this session, learn how to harvest your OEM metric values for later use outside of Enterprise Manager.  We will go into detail about our approach, required setup, and how we use the harvested information.   The primary use cases that will be covered are capacity planning and utilizing a custom built “Desired Metric Settings Repository”…

Oracle Audit Vault consolidates audit data from Oracle databases, operating systems and directories into a centralized secure repository.  Audit Vault has built in compliance reports to improve a DBAs life and configurable alerting to enhance security across a large environment. This session will cover the initial deployment of Audit Vault as an Administrator and the…

Enterprise Manager is an important tool to help DBAs manage and monitor your enterprise.  In fact, EM Cloud control is critical to always being available to notify you of any issues across your databases and systems.  The Oracle Database Appliance is a high availability platform that provides the ability to deploy the EM application and…

Currently the installation of EM12 Agents can be difficult and done manually.  THis quick tip presentation will demonstrate how to automate Oracle agent installations on new and existing machines using RPM's and puppet.  

Security configuration and features are available at many levels in Oracle Exadata Database Machine. This session will focus on the storage and OS layers with an overview of the database-layer security options and best practices. We’ll outline necessary requirements for system maintenance so the system will remain stable while offering suggestions on how security can…