OraFAQ Forum: Performance Tuning » Automating

Home » RDBMS Server » Performance Tuning » Automating - Gathering Satistics

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Automating - Gathering Satistics [message #206439]

Thu, 30 November 2006 01:05

Brayan
Messages: 315
Registered: June 2002

Senior Member

Hi,

I have a PL/SQL for gathering statistics(dbms_stats.GATHER_TABLE_STATS). I want to automate the the scripts. At present I'm submitting a DBMS_JOB.

Can anybody help me in to cron the job, i mean running the sql from OS.

Regards,
Brian.

Report message to a moderator

Re: Automating - Gathering Satistics [message #206506 is a reply to message #206439]

Thu, 30 November 2006 06:12

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

That should be quite simple.
Write a wrapper shell script, say myshellscript.sh
Something like this (untested code)

#!/bin/bash
sqlplus -s scott/tiger <<EOF
exec dbms_job(.............);
exit;
EOF

give the execute rights for the file myshellscript.sh.
schedule it in cronjob. Search forum/google for examples.
http://www.orafaq.com/forum/m/201760/42800/?srch=cronjob#msg_201760

Report message to a moderator

Previous Topic:	SQL vs. PLSQL
Next Topic:	Index Rebuild Taking Long

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 20 14:15:42 CDT 2026