Oracle Server, the flagship database, has many features familiar to Oracle DBAs for daily operation of solid production environments. These same DBAs are now expected to manage Oracle's MySQL that is being adopted by many companies. We explore the full life cycle and tools of a robust commercial MySQL environment, from development through production, as…

RMAN is a must-have tool familiar to most Oracle DBAs. There are many capabilities hidden in RMAN and going beyond the basics is important. After a quick review of the core functionality, we will discuss both old and new features and provide tips and tricks along with sample code using the Command Line Interface (CLI).

The MITRE Corporation is a not-for-profit organization chartered to work in the public interest. MITRE manages federally funded research and development centers (FFRDCs), partnering with government sponsors to support their critical operational missions. MITRE’s Records Management department needed to deploy a system to help manage physical content and electronic records not just for retention, but…

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…

Oracle announced several appliances and engineered systems - Database Appliance, Exadata, Exalogic, T4 super cluster, Exalytics and Big Data Appliance. While these products provided much needed gap in many cases, there is a tremendous amount of confusion about the proper usecase of these machines. In this session attendees will learn the difference between these, the…

What does it take to make the database secure, to comply with regulations and mandates like SOX and PCI? You may be amazed to know that by taking some simple steps you can perform in a single day, you can attain 60% of the requirements and make your database a secure place, as you will…

Do I have enough memory? Why is my free memory so low? Am I swapping to disk? Can I increase my SGA (db cache) size? Can I add another instance to this server? Are my system resources used optimally? These are all questions that often haunt DBAs. This presentation is The Answer. It covers in…

Unexpected execution plans due to system changes such as optimizer version and statistics, schema/metadata definitions, and system settings can have disastrous effects on performance. Learn how 11g SQL Plan Management (SPM) provides controlled plan evolution to ensure stability and consistent SQL performance.

ASH is one of the most powerful instrumentation related feature Oracle ever introduced and yet it is one the least explored feature. In this article, I explain how ASH can be used for troubleshooting, performance tuning, root cause analysis, scalability and capacity analysis. I also explain key performance related data that is only captured in…

This session will cover how organizations can achieve better performance, higher availability and improved manageability using Oracle Fusion Middleware with Oracle RAC. Learn how to integrate WebLogic Server with Oracle RAC, including the detailed features in Active GridLink for RAC. Plans for future capabilities will also be discussed.