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…

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…

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…

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…

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…

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…

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…

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…

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…