Tag: Database & Technology

Oracle WebCenter Content 10g functionality was effectively contained in one container - the Content Server. This fact alone made it easy to deploy, administer, and customize. However, for all of these easy capabilities, the product was somewhat lacking on the scalability and performance side. With Oracle WebCenter Content 11g, and the inclusion of Oracle Weblogic Server, SOA and BPM, the product has expanded functionality and best-in-class performance and scalability. The new trade off is that these additional infrastructure components have created a layer of complexity causing delayed deployments and non-optimized systems. Come to this session as we discuss some strategies and tactics for tuning WebCenter Content 11g, including details around how and when to use reverse proxy and load balancing, so that you can truly optimize WebCenter and maximize your investment.

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…