Re: Why isn't my script running?

  • From: Paul Linehan <linehanp@xxxxxx>
  • To: eugene.pipko@xxxxxxxxxxxx
  • Date: Thu, 26 Feb 2009 06:58:57 +0000

> 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@xxxxxx

Mob: 00 353 86 864 5772
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 02-2009