New blog!
Mon, 10/06/2008 - 22:45 — astijfOk. So this is the first blog-entry on Stiffmaster.com.
Welcome to my domain. Soon I'll update the website with some more content.
For the record: I'm an Oracle professional. That means you'll find some IT-related stuff here. Or maybe something else after all.
Just register yourself, and I'll keep you updated.
Stiff's list of useful Oracle scripts
Fri, 03/12/2010 - 18:23 — astijfListing some Oracle (eBS) scripts here.
Some syntaxes that I keep forgetting and some statements that are too long to type often.
Generate compile invalids script:
select 'alter '||decode(object_type,'PACKAGE BODY','PACKAGE',object_type)||' '||owner||'.'||object_name||' compile '||decode(object_type,'PACKAGE BODY','BODY')||';'
from dba_objects where status='INVALID' ;
Find concurrent request / program:
select cr.request_id, cpt.user_concurrent_program_name, cr.phase_code, cr.status_code,
Sister (brother) website!
Mon, 10/05/2009 - 17:45 — astijfJust a short note, to inform you about my other website:
Here you'll find a more extensive blog. And most importantly, the 'Oracle Workflow for eBS DBA' series on http://www.stijf.com/wordpress/about/link-page/
Enjoy!
Recent blog posts
