Re: Why isn't my script running?

From: Paul Linehan <>
Date: Thu, 26 Feb 2009 06:58:57 +0000
Message-ID: <>

> Here is the script:

> exec dbms_stats.gather_schema_stats('TEST',ESTIMATE_PERCENT=>30,CASCADE=>TRUE)

Why don't you set up a job in the dbms_scheduler instead of running a shell script?

easier - not environment dependent

Or have I missed something completely obvious?


> Still won't fire from cron, but runs as $sh

If you do it inside the db server, you don't have to worry about your OS environment or anything else - the reason Oracle did this in the first place.



Mob: 00 353 86 864 5772
Received on Thu Feb 26 2009 - 00:58:57 CST

Original text of this message