Hai

My database running cbo mode ,but i want schedule to collect statistics automatically at every 4pm ,i successfully submit the job using dbms_job.How to see the "SCH

My Octopus is pregnant too !

The ducks fly backwards over my house ....

What ?

URGENT!!

my car broken, fix please

remi@

If you are on Windows, create a batch file which will run the SQL script to analyze the schema. The batch and SQL files are below:

-------------------------------------------------
set oracle_sid=db02
sqlplus internal @d:\oracle\scripts\analyze_schema
-------------------------------------------------


-------------------------------------------------
spool d:\oracle\scripts\analyze_schema.log
exec dbms_stats.gather_schema_stats('SCHEMA_USER', 35, FALSE, 'FOR ALL COLUMNS SIZE 1', 2, 'DEFAULT', FALSE);
spool off

exit
--------------------------------------------------

Then simpel schedule the batch file with "at" . For UNIX - small changes and cron will do the same for you.


Hope that helps,

clio_usa - OCP - DBA