Do you ever wonder when and when not to use parallelism and how to control it? Do you want to understand how DBAs and Developers can best work together to optimally utilize parallelism? Parallelism in an Oracle database can increase performance of reporting queries and data loads many times over. However, if not controlled, it…

Users are struggling with performance in a user “experience” in a certain application. This “experience” comprises several SQL statements across multiple database sessions. The database is suspected to be the performance bottleneck, but you’re not sure. Traditional SQL diagnosis and tuning tools are built for specific sessions or SQL statements. How do you address monitoring…

Learn about Oracle's new revolutionary approach for accelerating Oracle Database in-Memory, and protecting application data in memory from malware attacks and memory access errors. By optimizing software through the M7 processor's silicon, and leveraging unique features in the Oracle Solaris operating system, Oracle makes it easier for DBAs and IT staff to activate security protections…

Having an understanding of the inner workings (internals) of a SELECT statement provide such a deep knowledge of Oracle that it leads to better database design and better performance tuning. This talk will discuss the internals of the SELECT statement and how and where it gets the data to return for the answer to a…

The benefits of knowing your data before embarking on a BI project are endless. Sure you can buy a tool to help with this. Or you could use R, an open source tool. This session will dig into methods for using R to connect to your data source to see visual and tabular analyses of…

MySQL is the most popular database on the web and the demand for qualified Database Administrators and Developers is very high.  A popular way to learn MySQL and show mastery are the MySQL DBA and MySQL Developer certifications.  This session will cover the areas of competency required by each of the exam, how to study…

This talk will benefit the Beginner and Mid-Level Oracle DBA when faced with running Oracle on a Windows Server, and may also teach some old hands a trick or two.  Instead of delving into topics that would be for Server Administrators, this session will deal with issues directly related to  DBAs running Oracle on a…

If you currently use an on-premise ERP, CRM or other applications on-premise  such as E-Business Suite, Siebel, SAP, Peoplesoft or any other enterprise or homewgrown application for your business requirements and are looking forward to move some of the functionality to the cloud, Integration is a very crucial component, central to the solution. Without integration,…

Successfully deploying and optimizing an Oracle Database environment can be a daunting task. The two objectives of this session are to focus on the key ingredients for a successful Oracle Database 12c installation and to provide a methodology to diagnose and remove performance bottlenecks by taking a closer look at the different Red Hat Enterprise…

Many database administrators are enslaved by their consoles, completely dependent on GUI-based database management tools not only for modifications for all diagnostics.  This presentation is about breaking away from that trap and getting into the Linux/UNIX shell and finding out what is really going on within the operating-system surrounding the database. This presentation will discuss…