SQL Tuning is a Science. SQL Tuning is an Art. You may have heard both claims. SQL Tuning can indeed be a complex task requiring the use of some attributes of both brain hemispheres: Analytical Thinking and Creativity. If we want to enhance our SQL Tuning skills we may need then to take them both…

      Most everyone knows an Oracle wallet is a password-protected container that can store authentication credentials, including traditional database passwords and PKI certificates, but did you know some of the slick ways in which an Oracle wallet can be leveraged?  Most people use wallets to store PKI credentials, but if you use it…

Demystify the world's 4th most popular Database engine!  If you don't support MongoDB now, chances are that you will in the future. This session will explain the basic concepts of MongoDB in terms that an Oracle DBA will readily understand. It will also review how to install and administer MongoDB, and give some simple DML…

Performance tuning can be complex. It's often hard to know which knob to turn or button to press to get the biggest performance boost. In this presentation, Janis Griffin, database performance evangelist, SolarWinds, will detail 5 steps to quickly identify performance issues and resolve them. Attendees at this session will learn how to: Quickly fine…

Oracle Advanced Analytics 12.2c delivers significant performance gains and features. OAA’s in-database algorithms can now build predictive models on billions of records in minutes, “score” millions of records in seconds and support real-time model deployment. New features include an unsupervised feature selection algorithm, partitioned models and Oracle Data Miner GUI enhancements.  R integration enables users…

The session will Introduce key new features that will be available with "Oracle Real Application Clusters 12c Release 2" Introduce best practices for deployment, Management, Availability and Performance tuning Cover internals of the key features so DBA's can understand how the feature will help with their day-to-day activities Presenter: Anil Nair, Principal Product Manager, Oracle Corporation

This presentation will look at which 12c new features should be investigated for use.  Most of the features that will be covered will be related to the DBA, but there will also be a few outside that realm that focus on the developer.  There will be simple examples (such as a quick example using pluggable…

Linux Container (not to be confused with Oracle 12c Container database) like Docker and LxC is the next-generation virtualization technology. Imagine having all the benefits of a hypervisor-based virtual machine, but with no performance overhead. Its this combination that makes containers ideal for databases, especially when running on bare metal. While the adoption of containers…

Docker greatly simplifies the way in which applications and their dependencies are packaged and distributed. While modern, microservices-based applications have greatly benefitted with the use of docker, this technology can be applied to traditional, Oracle-based applications as well. Typically, to create a new WebLogic environment, one would download the installation packages, install weblogic, create the domain and…

We'll meet informally to discuss the state of Oracle Database 12c and upcomming R2  quickly review some of its more beneficial features, and identify what topics our SIG should focus on in the coming months as 12c ramps up as a formidable player in the Oracle universe.