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…

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…

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…

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…