Billy Cripe, Author, Blogger and Man in Kilt returns to talk about Enterprise 2.0 information architecture. Designing systems that understand context as well as information flow are critical to realizing the promise and benefit of E2.0. Before systems can be wired together you must understand the overlap and intersection of people, systems and information. Without…

We all know that optimizer stats are vital for the optimizer to produce efficent plans. Histograms provide the optimizer with even more detailed knowledge on the data. But what about the SQL statements that transform the data in predicates, e.g. UPPER() or NVL()? The optimizer can't make an intelligent decision in those cases. In Oracle…

We all know that optimizer stats are vital for the optimizer to produce efficent plans. Histograms provide the optimizer with even more detailed knowledge on the data. But what about the SQL statements that transform the data in predicates, e.g. UPPER() or NVL()? The optimizer can't make an intelligent decision in those cases. In Oracle…

Collecting Optimizer Statistics is always a double-edged sword - it might force the optimizer to generate new plans which could be better or worse than the existing plan. But you can't stop stats collection too; since that could definitely result in poor plans. So what can you do? In Oracle 11g, you can force stats…

This presentation will look at which 11gR1 & 11gR2 new features should be investigated for use. Most of the features that will be covered will be related to the DBA, but there will also be a few outside that realm. There will be simple examples to show the basic functionality of the following new features…

This presentation will look at which 11gR1 & 11gR2 new features should be investigated for use. Most of the features that will be covered will be related to the DBA, but there will also be a few outside that realm. There will be simple examples to show the basic functionality of the following new features…

This presentation will provide a beginning set of security steps you can take with your Oracle database. As of 11g some of these recommendations are now the default, but if you are managing previous versions of Oracle, these are basic minimum steps that should be taken. Here is a beginning set of security features that…

Disk I/O remains the single most expensive of any operation and every computer professional needs to know how to manage the storage and retrieval of their database. With 64-bit technology, the IT professional also must understand the internals of RAM data buffering and how to get the most from your RAM resources. This presentation will…

Disk I/O remains the single most expensive of any operation and every computer professional needs to know how to manage the storage and retrieval of their database. With 64-bit technology, the IT professional also must understand the internals of RAM data buffering and how to get the most from your RAM resources. This presentation will…

Oracle Database 11g is a comprehensive database platform for data warehousing and business intelligence that combines industry-leading scalability and performance, deeply-integrated analytics such as OLAP and Data Mining, and embedded integration and data-quality. Also for data warehousing, the Sun Oracle Database Machine provides a complete, integrated hardware and software solution for high performance data warehousing,…