Join factorization, a new Oracle DB 11gR2 feature
Hong Su from Inside the Oracle Optimizer:
The Join Factorization transformation was introduced in Oracle 11g Release 2 and applies to UNION ALL queries. Join factorization is a cost-based transformation. It can factorize common computations from branches in a UNION ALL query which can lead to huge performance improvement.
Yet another reason to upgrade to 11gR2.
Comments Off | Filed in Links, Oracle | Tags: performance, sqlOracle Exadata Resource Kit
Featuring:
- 3-D Demo: Oracle Exadata
- Gartner Executive Video: Opportunities and Challenges for Managing Data and Lowering IT Costs
- IDC Report: Exadata Exceeds Expectations
- White Paper: A Technical Overview of the Oracle Exadata Database Machine
- Customer case studies, videos, podcasts and more
via Exadata Partner Community – EMEA.
Comments Off | Filed in Links, Oracle | Tags: exadataToad Extension for Eclipse
Toad Extension for Eclipse gives you the power to perform essential Oracle database development tasks directly within the Eclipse IDE. This free Eclipse plug-in makes it seamless to work with Oracle databases and eliminates the need for multiple tools.
Read about its features and download from quest.com/toad-extension-for-eclipse/.
Salesforce.com, the next Oracle acquisition target?
Oracle has a roughly $25 billion cash balance on its balance sheet, including cash, cash equivalents and short-term marketable securities. Oracle also has a significant amount of debt (around $17 billion) on its balance sheet, which means its net cash position is around $8 billion. However, if Oracle can make use of the cash balance to make acquisitions instead of paying off debt, it could open up a lot of strategic opportunities.
Salesforce.com’s market cap is around $19 billion, and Oracle could utilize its large cash balance towards a possible acquisition attempt. Salesforce.com is a cloud computing player that specializes in providing client relationship management (CRM) as well as other applications. The cloud computing space is an area expected to generate substantial growth over the coming years. Oracle is not currently a major player in the cloud computing market and hence Salesforce.com could provide it with ample growth opportunities in applications software.
ERP Software Financial Roundup for Q4 2011
Comments Off | Filed in Links, Oracle | Tags: erp, sap
- The ERP market has regained strength, but we’re seeing a growing disparity between the big ERP players and the mid-tier players.
- As small and mid-size businesses return to the market in 2011, leading mid-tier players can regain momentum; others will flounder.
- There is growing momentum behind cloud-based ERP, which will benefit NetSuite, as well as those traditional ERP companies that adapt.
Oracle’s VMware support policy like Jekyll and Hyde
Organizations that have run Oracle Database and applications for years on top of VMware’s virtualization technology said they have had little to no problem getting Oracle Support to work with them on issues.Comments Off | Filed in Links, Oracle | Tags: vmware
How To Manually Install XML DB On Oracle 11g
Due to Oracle Bug 9818995, if catqm.sql is used then not all installation steps are performed by this script… This document explains the full set of steps that need to be taken in order to perform a complete and working Oracle XML DB installation.Comments Off | Filed in Links, Oracle, Tips | Tags: 11g, xml
Project Guide for Oracle RAC Implementation
This article is a guide for defining, designing, and delivering a successful Oracle RAC project. It details the steps required to reduce risks and increase your chances of a successful implementation. In addition, it highlights many major pitfalls you may encounter during your Oracle RAC project and offers suggestions on how to avoid them.
Even though it was published in 2006, the steps listed in this guide still apply to many Oracle projects today.
Comments Off | Filed in Links, Oracle | Tags: guide, project, racCreate an Excel file with PL/SQL
For this project I took an Apex-plugin I have written, (IR) Report to Excel (xlsx), and turned it into a PL/SQL package. With this package it’s very easy to create an Excel 2007 file with only a few lines of PL/SQL code.Comments Off | Filed in Links, Oracle | Tags: excel, pl/sql
4 interesting things you may have missed on Feb 18, 2011
-
It's a wiki, like Wikipedia. all of the information you see on the site is freely editable by any logged-in user. Anyone can contribute to articles, add new code, edit articles, you name it. This site is by the community, for the community. Content is moderated by the community and our own panel of database experts, all with a high level of expertise and passion in their field.
-
VARCHAR is an ANSI standard data type but Oracle's implementation of the VARCHAR data type violates the ANSI standard by considering the empty string to be NULL (Oracle's implementation predates the ANSI standard). Oracle has stated that the semantics of the VARCHAR data type may change in the future with respect to how the empty string is treated. If and when that happens, the semantics of the VARCHAR2 data type will remain the same. Using the VARCHAR2 data type is safer because you don't have to worry that some future version of Oracle will break your code by causing empty strings to no longer be considered NULL.
-
Thursday, the National Telecommunications and Information Administration (NTIA) released The National Broadband map, a staggeringly powerful free tool that gives anyone access to census-level data about broadband connectivity in the United States.
-
In the past 5 years many specialized DBMSs have been introduced, as well as database systems with new storage schemes. These can be categorized by the type of the applied technology. This article explains the four most popular types of database systems currently used by top corporations like Yahoo, Facebook, Google, Misrosoft, Amazon, etc.
