Wednesday, March 16, 2016

How to remove a non-used option marked as INVALID in dba_registry

›
If you have invalid components in your database table dba_registry, and those options are not used, you should mark them as removed to avoid...

How to fix error ORA-04063: package body "OLAPSYS.CWM2_OLAP_METADATA_REFRESH" has errors when installing OLAP into a 11g database

›
You are installing OLAP. You receive the following error at the end of the olap.sql script: SQL> @?/olap/admin/olap.sql SYSAUX TEMP; S...
Tuesday, March 15, 2016

How to add a line feed to your spool file

›
If you want to spool out a file from you sqlplus session, and need a line feed in your string, you can use the function char( int ) to conc...
Tuesday, March 8, 2016

How to check for existence of and installation of Data Mining in the database,

›
In this short article, I am following the document "How To Manually Install Data Mining In Oracle 11g? (Doc ID 818314.1)" select...
Wednesday, March 2, 2016

How to identifiy whether or not Oracle Configuration Manager is in use

›
Change directory to $ORACLE_HOME # cd $ORACLE_HOME # ls ccr bin config doc hosts inventory lib README.pdf state If the directory cc...
Thursday, February 25, 2016

How to enable and disable Automatic SQL tuning

›
Enable: BEGIN dbms_auto_task_admin.enable(client_name => 'sql tuning advisor', operation => NULL, window_name => NULL); EN...
Tuesday, February 16, 2016

How to remove dbms_scheduler jobs

›
To delete an obsolete scheduler job, use the procedure dbms_scheduler.drop_job procedure. In a recent case, a large number of obsolete dbm...