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...
Thursday, February 4, 2016

How to create and start a service with dbms_service

›
Create the service. The first parameter name is the service name, can be up to 64 characters long. The second parameter is the network na...
3 comments:

How to find information about CPUs on an AIX server

›
lsconf | grep Processor Processor Type: PowerPC_POWER7 Processor Implementation Mode: POWER 7 Processor Version: PV_7_Compat Number Of Proce...
Wednesday, February 3, 2016

11.2.0.2 and onwards: v$parameter reflects the NLS session parameters, not the NLS instance parameters

›
After a migration of a database from single-byte to multi-byte character set, I wanted to compare the nls_parameters. As a part of the m...
Wednesday, January 20, 2016

What is the package SYS.USER_LOCK?

›
Recenty I was migrating a database with a package that wouldn't compile because it couldn't find the package called upon in its code...
Monday, January 18, 2016

How to work around error from opatch "LsInventorySession failed: OracleHomeInventory gets null oracleHomeInfo"

›
I recently had to investigate the patch level for an Oracle 10g database prior to an upgrade of an OAS application database. This is the e...