Oracle MDB Maintenance

To solve performance problems with the Oracle MDB, do one of the following:

From an Oracle SQL tool on the Solaris Oracle server computer run the command:

EXEC DBMS_STATS.gather_schema_stats(ownname =>'MDBADMIN', cascade =>true, method_opt=>'FOR ALL COLUMNS SIZE AUTO');

Login to the Solaris computer using the Oracle user credentials, and from the command shell run the command as shown in the following example:
```
echo "EXEC DBMS_STATS.gather_schema_stats (ownname => 'MDBADMIN', cascade =>true, method_opt=>'FOR ALL COLUMNS SIZE AUTO');"|sqlplus sys/<pwd>@<instance> as sysdba
```
In this example, <pwd> is the password of the current Oracle instance and <instance> is the name of the current Oracle instance (SID).

More information: