Oracle Docs Your Oracle Document Library

0

Oracle Critical Patch Update October 2012

00Oracle Critical Patch Update October 2012 The Critical Patch Update for October 2012 and The Oracle Java SE Critical Patch Update for October 2012 were released on October 16th, 2012. Oracle strongly recommends applying...

0

Useful SQL Statements Part 1

00Startup time select to_char(startup_time, ‘HH24:MI DD-MON-YY’) “Startup time” from v$instance / How large is the database col “Database Size” format a20 col “Free space” format a20 col “Used space” format a20 select round(sum(used.bytes) /...

0

Oracle Critical Patch Update January 2012

00Description A Critical Patch Update is a collection of patches for multiple security vulnerabilities. Critical Patch Update patches are usually cumulative but each advisory describes only the security fixes added since the previous Critical...

0

Recompiling Invalid Schema Objects

00Recompiling Invalid Schema Objects Operations such as upgrades, patches and DDL changes can invalidate schema objects. Provided these changes don’t cause compilation failures the objects will be revalidated by on-demand automatic recompilation, but this...