This session will focus on Oracle's support of Oracle running on Linux on System Z and also include technical tips.

Some hot topics in data mining include text mining, document clustering, and recommendation engines. Learn how Oracle Data Mining was used in the Schedule Builder session-enrollment application at Oracle OpenWorld 2008 and 2009 to recommend sessions to attendees and find similar and related sessions. This session includes a demonstration of the Oracle Data Miner UI…

Today’s government and commercial organizations do not have the luxury of waiting one week or one day for their transactional data to be loaded into their data warehouse. In order for businesses to achieve competitive advantage over their competitors, relevant up-to-date information needs to be available to conduct robust and real-time analysis of the time…

Oracle ADF is the development platform for the Oracle Fusion Applications and is the core development platform for the Oracle Fusion Middleware solution too. As more and more companies adopt Oracle ADF for their own development needs developers and managers are often faced with the question of how to get up to speed with this…

Ever wondered how Oracle locks a row, or a table? Is there a master lock manager? No, there is not. In this session you will learn how Oracle manages the locking with demos, how ITL slots are used and how you can avoid the issues related to ITL slots. Also learn how unindexed Foreign Keys…

This paper has detailed coverage of real world lessons learnt in implementing SQL Plan Management to solve everyday performance issues related to SQL plan variability. SQL Plan management was used to baseline plans for 7 (seven) critical business processes at SEI, a Global Wealth Management service provider with strict SLA(s) tied to them. The results…

As a beginning DBA you may have some experience with databases such as MS-ACCESS or MySQL. After a weeklong Oracle DBA training course you are now thrust into your new role. In this presentation we will try to present some of the tools that you will need to know / have access to / learn…

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…

During this presentation, a case study is unfolded to reveal the true cause of a slow performing query. Did the database just "have a bad day"? Was the evil DBA to blame? The PL/SQL developer who didn't get enough coffee? Or was it the application sending the "wrong" query in the first place? In this…

The author is called to audit RMAN backup scripts on regular basis for several years now as part of his Day to Day duties. He see the same errors in scripts that Oracle DBAs using to backup critical databases over and over again. Those errors may play a significant role in a recovery process when…