Tag: Database

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…

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…

Picking out, validating and improving slow or resource-eating SQL statements is part of any responsible DBA's work who takes his/her job serious. Identification alone can be tough, but it will be even harder to improve something you have no chance to understand the purpose of. This way, you will never be in the position to…

Why is PowerShell a DBA’s best friend?  It’s a lightweight, simple and powerful tool to manage database operations.  As DBAs we are tasked with managing many different types of database platforms.  It’s a database and you are a DBA, right?  It all looks the same, right?  PowerShell gives you the ability to run scripts against…

Why is PowerShell a DBA’s best friend?  It’s a lightweight, simple and powerful tool to manage database operations.  As DBAs we are tasked with managing many different types of database platforms.  It’s a database and you are a DBA, right?  It all looks the same, right?  PowerShell gives you the ability to run scripts against…

In this presentation we will learn the basics of the Oracle Server networking. We will discuss the various components of OracleNet, the various ways to connect to the database through the network and some tips to help simplify some of the challenges Oracle networking can pose. Eligible for Certificate: #IOUGeniusCert; #IOUGeniusCore   Info: www.collaborate.ioug.org/certificates  

For many years software architects have discovered and implemented several concepts and best practices to build highly scalable applications. In today's era of the cloud, these concepts are even more applicable and critical. The cloud solutions faces many challenges due to growing data, unpredictable traffic patterns and demand for faster response time. In this session…

  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…

There are over 1200 wait events in Oracle 12c, but in my experience there are only 10  that DBAs should be very familiar with.. If you can master these 10 wait events, what causes them and their solutions, you will be ahead of the performance analysis game. In this session, Janis Griffin, Database Performance Evangelist,…