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…

Prior to 10G, Raw Device or 3rd party cluster filesystem were the only options for Oracle RAC or OPS. Starting with 10G, even with popularity of ASM using Raw luns over FC storage network, NFS is often a much cheaper and viable option. In the case study - the same storage system was assigned as…

Oracle releases fixes for security vulnerabilities on a quarterly basis in the form of a Critical Patch Update (CPU). The CPU is a collection of security patches for the Oracle Database, Oracle Application Server, Oracle Collaboration Suite, and Oracle business applications, including both the Oracle E-Business Suite and PeopleSoft applications. The first CPU was released…

Oracle releases fixes for security vulnerabilities on a quarterly basis in the form of a Critical Patch Update (CPU). The CPU is a collection of security patches for the Oracle Database, Oracle Application Server, Oracle Collaboration Suite, and Oracle business applications, including both the Oracle E-Business Suite and PeopleSoft applications. The first CPU was released…

Having your system configuration and IT project documentation uploaded to My Oracle Support can fill a critical need for disaster recovery. Especially if your primary site is completely lost or unavailable, or the more real possibility that the documentation was never maintained properly in the first place. Personnel would be able to find the information…