Re: Why isn't my script running?
From: Paul Linehan <linehanp_at_tcd.ie>
Date: Thu, 26 Feb 2009 06:58:57 +0000
Message-ID: <4bb59cc60902252258v6568705xdc0ff20dde30bc88_at_mail.gmail.com>
> Here is the script:
Date: Thu, 26 Feb 2009 06:58:57 +0000
Message-ID: <4bb59cc60902252258v6568705xdc0ff20dde30bc88_at_mail.gmail.com>
> Here is the script:
<snip...>
> exec dbms_stats.gather_schema_stats('TEST',ESTIMATE_PERCENT=>30,CASCADE=>TRUE)
<snip>
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?
Paul...
> Still won't fire from cron, but runs as $sh test_schema_stats.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.
Paul...
-- linehanp_at_tcd.ie Mob: 00 353 86 864 5772 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 26 2009 - 00:58:57 CST