Oracle 11g offers several methods for database duplication, including duplicating to the same server or duplicating to an alternate or development platform for use as development instance. This talk will provide a real-life step-by-step example of how I use Oracle Active Duplication in 11gR2 to duplicate or clone…

You want to engage the mobile market, but what's the best approach? A native application in the iTunes store, or a mobile version of your web site? With the latest ADF Mobile tools, you get the best of both worlds, because you can make native applications with nothing more than standard HTML5, CSS, and JavaS…

Program Global Area (PGA) resides in the process private memory of the server process. PGA_AGGREGATE_TARGET is used to control the sizing of workareas. Often improper setup and incomplete understanding of the inner working of PGA and the interconnectivity with OS settings leads to ORA-4030 errors, which…

Oracle VM provides two major categories of virtual machines; HVM and Paravirtualized. The HVM or Hardware Virtualized Machine is able to take advantage of hardware acceleration features built into the x86 chipset to accelerate certain operations. The Paravirtualized machine is able to take advantage of mor…

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 Inter…

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…

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…

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…