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…

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…

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…

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…