(Zlatko Sirotic) This is an alternate version of a previous Tip of the Week, “Determine How Deep FK Constraints”, from February 16, 2003. This new version uses a packaged associative array.
Tag: Oracle
Oracle reassures Retek workers
(Mike Meyers) Oracle Corp. senior executives came to town to promise employees and customers that Retek Inc., the Minneapolis software company they recently agreed to acquire, isn’t headed for wrenching changes.
Oracle versus SQL Server in the Enterprise
(David Hull) Can Oracle kick SQL Server’s behind? Oracle expert David Hull throws down the gauntlet to Microsoft devotees.
Oracle Tip: Understand the difference between star and snowflake schemas in OLAP
(Scott Stephens) At the core of data warehouse applications and OLAP (online analytical processing) is a specialized schema that relaxes the rules of Third Normal Form RDBMS schemas in favor of faster analysis and processing of large amounts of data. It’s important to understand the difference betwe
Experiences Installing Oracle Application Server 10g Cold Failover Clusters on AIX 5L
The objective of this document is to provide assistance to those involved with the installation of Oracle Application Server 10g (9.0.4) (AS10g) “Cold Failover Cluster” (CFC) solution on IBM AIX 5L (5200) operating system. Two high availability cluster solutions are currently offered by Oracle for A
Understanding Data Growth and Best Methodologies for SQL Optimization with Toad for Oracle Xpert
(Bryan Huddleston) This paper informs application owners about business considerations that result from data growth, and explains that these owners can prepare their applications by employing a methodical approach to optimizing code within their organization. (R)
Configuring Oracle9i RAC and Oracle RAC 10g on the Same Cluster Using CRS
(Ashok Singh) Oracle Database 10g contains many enhancements, but one of the most interesting is the introduction of Oracle Cluster Ready Services (CRS), Oracle’s full-stack clusterware.
Oracle’s lineup of Online Seminars for April 2005
OracleDirect’s online seminars scheduled for April cover such topics as Oracle Enterprise Manager Grid Control, Oracle, MySQL & Open Source…and more.
Aggregate Data with XQuery
(Nilesh Junnarkar, Nirav Chanchani, and Julie Basu) Most large organizations have multiple applications in-house, each designed to support a specific set of business functions, and these applications are generally optimized for a particular business function. Unlike its applications, however, the va
Deployment: Where the Rubber Meets the Road (Part 2)
(Lonneke Dikmans) Part 1 of this article showed you how to deploy J2EE applications built using frameworks (Oracle ADF) using JDeveloper10g deployment profiles. Now it’s time to turn to deploying the sample application using Apache Ant. As with Part 1, you’ll see how to deploy to not only Oracle Con
