Display OLE DB Providers
Sometimes it can happen that you need to change a property for a certain OLE DB drivers, such as the …
component ‘SET_NO_OUTLINES’ must be declared
When exporting data from a database, you receive following error: EXP-00056: ORACLE error 6550 encountered ORA-06550: line 1, column 41: …
Create an Oracle password file
Oracle password file In order to startup an Oracle database, one need to have either an Oracle password file or …
Write a message to a trace file or the alert.log file
In case you want to write something to the Oracle alert.log file, you can use an undocumented package procedure to …
Location of alert.log file
The alert.log file contain messages related to the startup and running of a specific database. The name of the alert.log …
Enable database auditing
Oracle database auditing can be enabled by setting the audit_trail initialization parameter. You can check the current status using following …
Enable 10046 trace in a session
There are a number of ways to trace a session: Enable trace at the beginning of your session Enable trace …
Generate Workload CPU statistics using dbms_stats.gather_system_stats
In Oracle 9i and up, you can generate CPU cost information during a workload with a procedure of the dbms_stats …
Oracle startup sequence
The Oracle startup phase consist out of 3 steps: nomount phase: during this phase, the initialization file is read mount …
[SEVERE] – My Oracle Support Username/Email Address Not Specified
When you are trying to install Oracle 11gr2 software using a silent install, you might encounter following error: [SEVERE] – …
DbMotive is an