Tag: Database

Behind the scenes, Oracle APEX stores all types of different information about your applications and user access in metadata tables. This session will cover some of the wide and varied uses you can put that data to.

WikiLeaks has dramatically changed how organizations deal with data security. Without getting into the politics, this session will discuss how to mitigate data breaches in your APEX applications. It will follow your data through its “chain of custody”, and provide insights on securing it at each step. It will cover not only things to do…

What's the right solution for your content management needs − Oracle WebCenter Content or SharePoint or both. This presentation will try to provide an understanding of the strengths and weaknesses of these two competing but compatable content management solutions while presenting a business strategy to use both of them at the same time. See how…

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 my production instance to a development instance…

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 JavaScript!

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 are raised when memory or resources are requested from…

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 more efficient device drivers, thus accelerating network and I/O operations.…

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…