One of the challenges developers often face during the development and testing phase is to get the test data timely populated in the development/ UAT databases. In the absence of data conversion programs, it becomes tedious manual effort to come up with test data so that various components of an application can be tested. Often…

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

1. Measuring and tuning Global cache performance We will breakdown the CR and CUR response time with few customer examples and show how it can be used to debug Global Cache performance. A script will be supplied to show the breakdown. 2. Tuning RAC background processes performance Earlier discussion of GC will lead tuning few…

We will discuss some of the interesting performance issues and solutions. These issues are encountered with various clients across the globe. (i) A case of High Kernel mode CPU usage (ii) Small dose of NUMA etc. (iii) A case of hung cluster due to CF enqueue locks (iv) A case of hung RAC instances due…

We will discuss some of the interesting performance issues and solutions. These issues are encountered with various clients across the globe. (i) A case of High Kernel mode CPU usage (ii) Small dose of NUMA etc. (iii) A case of hung cluster due to CF enqueue locks (iv) A case of hung RAC instances due…

Of all of the new features that are included in version 11gR2 of the Oracle Database, Edition Based Redefinitions could be the one that has the highest impact on the way we develop database centric applications. With Edition Based Redefinitions you can have multiple versions of the same object in your database schema in order…

Of all of the new features that are included in version 11gR2 of the Oracle Database, Edition Based Redefinitions could be the one that has the highest impact on the way we develop database centric applications. With Edition Based Redefinitions you can have multiple versions of the same object in your database schema in order…

This presentation provides practical solutions for securing your Oracle HTTP Server (OHS). It follows the approach that was used with Project Lockdown for the database to provide a phased approach to securing the web server. The introduction explains the differences in web server setup based on usage, from reverse proxy server to J2EE Application server…

SSD or Solid State Drives is the newest Silver Bullet for providing increased performance for your databases. At times, even upto a factor of multiple times. However, if the wrong SSD drives are chosen or not correctly implemented, it can have the opposite effect and decrease database performance. The first part of this presentation will…

This session covers migration from any other platform to System z. Also covered are adjustments on the Linux box for best performance and changes to the source system which will ensure a smooth migration