Jeremy Allison of the Samba fame wrote an interesting blog post about Sun’s approach to open source participatory development, followed by Bradley Kuhn’s bad opinion of Oracle’s attitude towards open source.
There are a number of OBEs available for the OWB 11gR2 release which range from an overview of all the cool new usability improvements in the mapping editor (auto-mapping improvements, copy-paste expressions, operators, operator groups, group/ungroup operators, spotlighting to name a few!), through basics of using the operators in a mapping for joining, filtering, pivoting and so on, then diving into building pluggable mappings (aiding reusability and good software design practice) and last but not least an OBE on data profiling covering profiling, deriving rules and even cleansing th
Partitions are often used to help increase the performance of SQL select activity via the concept of partition exclusion – the CBO will be able to identify which of the partitions could hold the data of interest and ignore the others. This is their main benefit from a SQL Select performance perspective.
The problem is, the partitioning key is not always included in your SQL statements.
Counting the number of open cursors in a database instance can be a confusing activity. Perhaps an application has received an "ORA-01000: maximum open cursors exceeded" error message or perhaps you simply want to get an idea of how many cursors an application has open at some point in its execution. No matter the reason, you've attempted to determine the number of open cursors and have found what seems like incorrect or confusing results (i.e. the value is too high!).
The Database Insider Podcast Series is proving to be very popular. October's podcasts feature both Oracle experts like Juan Loaiza and Ray Roccaforte discussing Oracle Exadata V2, and customers including Lexmark and Agenor Technologies sharing their experiences of upgrading to Oracle Database 11g. If you haven't tuned in yet, check out the latest Oracle Database 11g podcasts: