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...

How to use dbms_metadata to generate DDL for constraints

›
set long 10000 set heading off set trimspool on set lines 300 set longchunksize 300 spool all_mycons.sql exec dbms_metadata.set_Transform_pa...

How to use dbms_metadata to generate DDL for a trigger

›
set long 10000 set heading off set trimspool on set lines 300 set longchunksize 300 spool mytrigger.sql exec dbms_metadata.set_Transform_par...
Tuesday, January 12, 2016

On a Linux system, what do the parameters shmall, shmmax and shmmni define?

›
shmall * indicates the total amount of shared memory that the system can use at one time (measured in pages) shmmax * defines the maximu...
Thursday, January 7, 2016

How to join v$database with v$instance

›
Here is a useful query which displays basic information about the database, using v$database and v$instance. Take the opportunity to calcul...
3 comments:
Tuesday, December 22, 2015

Generate "drop user" statement for schemas with and without objects

›
set lines 200 col owner format a20 col username format a30 col schema format a30 PROMPT ==================================================...