Throughout my 16 years working with Oracle, I have accumulated a list of tips and techniques that assist with the development of Oracle based custom applications. These tips and tricks can be used to improve application performance, to streamline code, and to create higher quality applications. The speaker will describe each topic in detail as…

Oracle Forms is a strong and viable product with years of future left. However, Oracle has “bet the farm” on the success of Fusion; Oracle’s rewrite of its Application stack using Java EE and Service-Oriented Architecture. A key tool in this development effort has been the JDeveloper tool and the Oracle Application Development Framework (ADF).…

This presentation will show the top ten tips when tuning your architecture for grid computing. Oracle has come a long when from when they first introduced clustering. The tools continue to improve and the installation continues to get better and easier. The main focus is to show many of the Grid Control screen shots so…

Oracle Application Express (APEX) provides a convenient way of building the basic page structures necessary to guide a user through a multi-step process. This capability can be leveraged to build wizards into complex APEX applications, thereby reducing user errors and training costs. The end result is an application that is both reliable and cost effective…

Traditionally DBAs tended to prepare a set of home grown database performance monitoring scripts based on v$views and v$tables for database performance monitoring and diagnosis. However for environments with a large number of databases, a database performance monitoring tool such as Oracle Enterprise manager provides a much more effective way to manage the database performance.…

Oracle Grid consolidates compute resources into an on-demand sharing resource pool. As a new addition to the Grid, Oracle VM provides the server virtualization that enables the flexible Grid based on a pool of virtual machines. To provide an infrastructure support for the Grid, blades servers and an iSCSI storage provide an ideal platform and…

Oracle Grid consolidates compute resources into an on-demand sharing resource pool. As a new addition to the Grid, Oracle VM provides the server virtualization that enables the flexible Grid based on a pool of virtual machines. To provide an infrastructure support for the Grid, blades servers and an iSCSI storage provide an ideal platform and…

This paper describes using the Oracle® Generic Connectivity gateway (OGC) to transparently integrate tables in a Microsoft SQL Server database with an Oracle database. While there are many other ways to federate data from multiple data sources, OGC offers several advantages. • OGC federation uses simple configuration files eliminating the need to write and maintain…

This paper describes using the Oracle® Generic Connectivity gateway (OGC) to transparently integrate tables in a Microsoft SQL Server database with an Oracle database. While there are many other ways to federate data from multiple data sources, OGC offers several advantages. • OGC federation uses simple configuration files eliminating the need to write and maintain…

New in Oracle Database 11gR2, the "recursive common table expression" (CTE) gives us yet another tool to manage hierarchical data. A recursive CTE is composed of one or more "anchor members" followed by one or more "recursive members." For example, to find all the ancestors of George Walker Bush, we create anchor members that list…