How do you design an OLTP system that handles terrabytes of data and needs to scale 200% per year ? Or 200% per month ? By the way, all queries still need to respond in subseconds. And no, your budget is not unlimited. Enter Database sharding - the art of splitting data into manageable chunks,…

Organizations of all sizes face challenges in keeping track of users of Information Technology systems. Siloed applications, cloud based services and legacy systems make it difficult for managers to know "who has access to what". In this session, we will demonstrate Oracle's solution to managing this information; Oracle Identity Manager (OIM) and Identity Analytics (OIA).…

During this deep dive, the speaker will walk you through many database deployments scenarios, explain their pros and cons and demonstrate how to decide on HA architecture that's most appropriate for your project. We will start from learning how to define and quantify high availability requirements as well as how to choose the right technology. Of course, we will cover various Oracle HA technologies such as Exadata, RAC, ASM, Data Guard, Streams, Golden Gate, and various smaller Oracle features as well as some storage technologies and virtualization. This session will be most useful for database architects and database administrators who are looking to sharpen their architectural skills, however, there is no particular prerequisites for the attendees besides general familiarity with Oracle database technology stack. We will go deep into technical details of some features but general background will be provided.

This session gives an overview of best practices and tools to diagnose performance problems. The focus of the presentation is the platform Linux on z.

If you have been working with Oracle UCM and Site Studio, Oracle’s acquisition of FatWire has introduced some uncertainty. Are you unsure what “web experience management” means for your company? What is the proper path for my existing Site Studio sites? How can I best utilize WebCenter Sites in my existing Oracle environment? Come to…

An overview of High Availability Solutions with MySQL with case studies of customer deployments in the field

Understanding the ‘TRUE’ High Availability (HA) requirements for the systems is the most critical component in providing and configuring the desired HA for the application. Business and IT must have a common understanding regarding the cost associated with the expected HA. The associated cost and the ‘TRUE’ HA requirements primarily drive the solution architecture and…

In special situations, the Oracle Database generates too many child cursors for particular SQL-IDs. This results in high CPU load on the DB server, coming from heavy mutex access. This is visible as mutex wait events. The lecture will show how this situation arises, how the DBA can try to quick-fix it and how long-term…