Tag: Database

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 presentation will focus on the Oracle Clusteware/RAC Installation and Management by using a 16-node 11.2 installation. We will talk about design consideration including pre-reqs, hardware and network setup. We will go over all the Clusterware/RAC installation steps with screenshots. We will then focus on managing this 16-node 11.2 Clusterware/RAC DB including the use of…

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…

This is a two-part session that will take place on Monday and Tuesday. Database shrinking can be overwhelming. Don’t let this feature intimidate you; let it become a powerful friend! This session describes why shrinking is needed and just how to go about using it. Being forewarned and forearmed will decrease the learning curve and…

This presentation is a high-level introduction to Oracle RAC. Many RAC beginner presentations are given by seasoned RAC experts and contain an overwhelming suite of technical discussions, covering a way too much information for the level of expertise of most attendees. This presentation is given by a beginner with the RACand will introduce attendees to…

Transportable Tablespaces (TTS) are one of the most versatile features in Oracle Database. Leaving the datafiles in place with TTS are one of the fastest methods of upgrading without an additional option license cost. Several case studies will be covered: Archiving partitions, storage migrations, TSPITR and sharing a read-only tablespace between databases.

More and more companies are utilizing virtualization in their environments to lower costs and effectively utilize resources. Placing Oracle databases in virtualized environments is not just for development and testing anymore. The rise of virtualization is introducing new performance challenges to the Oracle DBA that are not well documented at this time and these issues…

Even the best-planned database upgrades can leave nagging questions: what happens if my upgraded system performs unexpectedly? Is there a way I can go back to the previous version without downtime and data loss? Oracle GoldenGate allows DBAs to give affirmative answers to these questions. Drawing on upgrade experiences ranging from mid-sized databases to a…

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…