How do you defuse screaming, angry, blame-toting clients?—Angry, accusatory letters from their big boss to your big boss? How do you solve a problem or resolve performance issues in a repeatable way? Defuse a literal shouting-match that started between opposing IT service delivery teams? How do you escape this situation you should avoid like the…

Having accurate optimizer statistics for your database is more important than ever. Handling larger volumes of data and benefitting from the ever-increasing number of choices in execution plans generated by the Oracle Optimizer require that the optimizer knows as much as possible about your data. The only reasonable way to gather the statistics is with the dbms_stats package. But there are many options to dbms_stats, and your choice of which options to use can dramatically affect your results, both in accuracy of statistics and performance of the statistics gathering operation itself.

A few years back we examined dbms_stats in Oracle 9 and 10.1. We update this information for Oracle 11.2 (and the next generation of the Oracle database, if it is released soon enough). In this presentation we will discuss the effects of the various choices. The focus here will be on actual experience, measured performance, and detailed examples— not just on what the documentation says. Those attending the session should have some experience with gathering optimizer statistics.

When your report to Oracle a SQL with poor performance, most probably you will be asked to provide a SQLTXPLAIN (SQLT) report. This SQLT tool is used by Oracle to diagnose SQL statements performing poorly. The problem that you may face is that SQLT requires to be installed before being used. In some Production systems…

MySQL user authentication has greatly changed in the past few years. But does the software you use give users the DROP TABLE privilege by default? Could you use proxies or pre-defined roles? How do you audit users to make sure they have the right privs? What new features such as authentication plug-ins are going to…

An introduction to the new web-based Troubleshooting Tools for ORA-600, ORA-7445, ORA-4031 and ORA-4030 errors that enables customers to diagnose these errors without creating a service request. Based on incident and/or RDA information the database administrator provides as input to the tool recommended actions will be given to resolve the error. Each tool will be…

In order for users to start doing their analysis in OBIEE, you need a repository built. You say, oh that shouldn't be too difficult because I already have my tables built in the database. Then you open the Administration tool and have no idea where to start. What does Business Model and Mapping mean? What…

It's time to go global so multilingual databases are needed. This presentation covers the steps to migrate/upgrade an English only 10.2 database to multilingual 11gR2 database. It shows how to migrate database NLS_CHARACTERSET from WE8ISO8859P1 to WE8MSWIN1252 and to AL32UTF8 . It discusses how to deal with Changeless, Lossy, Truncation and Convertible data and how…

WebCenter Architecture

Jim Starkey has been responsible for many database innovations from the date data type to the BLOB to multi-version concurrency control (MVCC). Join us for this rare opportunity to hear Jim postulate on a new set of rules for 21st century relational databases based on the principles of emergent behavior as found in Nature. Jim…

Wondering what the black box of Oracle Fusion Middleware really entails? Not sure what the difference between Oracle Fusion Middleware, Oracle Fusion Applications, cold fusion, and jazz fusion is? Come to this session for help! It gives a high-level overview of which tools are part of Oracle Fusion Middleware and briefly touches on what they…