Optimizar SAP

[koletas]

Se llama Check and update optimizer statistics.

Yo tengo varias puestas en el crontab de mi HP-UX, las missing, las del diccionario de oracle y las del systema:

# crontab -l
30 06 * * * /home/util/sap/stats_oracle.com <SID> missing
00 10 01 * * /home/util/sap/stats_oracle.com <SID> oradict_stats
00 10 02 * * /home/util/sap/stats_oracle.com <SID> system_stats


# more /home/util/sap/stats_oracle.com <SID> missing
::::::::::::::
/home/util/sap/stats_oracle.com
::::::::::::::
#!/usr/bin/ksh
sid=$1
tipo=$2
DIR=/home/util/sap
FICH=stats_oracle_${sid}_${tipo}.log

su - ora${sid} -c "brconnect -u / -c -f stats -t $tipo -p 1" >>${DIR}/${FICH} 2>&1 &


===============


# more /home/util/sap/stats_oracle.com
#!/usr/bin/ksh
sid=$1
tipo=$2
DIR=/home/util/sap
FICH=stats_oracle_${sid}_${tipo}.log

su - ora${sid} -c "brconnect -u / -c -f stats -t $tipo -p 1" >>${DIR}/${FICH} 2>&1 &


=========

Lanzalas cuando no exista carga ya que sobrecarga la BBDD.
lanza esto:
SQL> select max(to_char(last_analyzed,'dd/mm/yyyy hh24:mi:ss')) from dba_tables;

Prueba esto con una tabla:
SQL> select TABLE_NAME, OWNER, TABLESPACE_NAME, LAST_ANALYZED from dba_tables where TABLE_NAME='S601';

Si es Oracle, puedes usar las BRTOOLS:
Generar estadísticas del Diccionario de Datos de Oracle con las brtools:

hostnamera<SID># brconnect -u / -c -f stats -t oradict_stats
BR0801I BRCONNECT 7.00 (31)
BR0805I Start of BRCONNECT processing: cdxlzegs.sta 2008-03-14 10.46.30
BR0484I BRCONNECT log file: /oracle/PIP/sapcheck/cdxlzegs.sta

BR0280I BRCONNECT time stamp: 2008-03-14 10.46.30
BR0807I Name of database instance: PIP
BR0808I BRCONNECT action ID: cdxlzegs
BR0809I BRCONNECT function ID: sta
BR0810I BRCONNECT function: stats
BR0812I Database objects for processing: ORADICT_STATS
BR1314I Oracle dictionary statistics will be collected with default options
BR0126I Unattended mode active - no operator confirmation required

BR0280I BRCONNECT time stamp: 2008-03-14 10.46.30
BR1311I Starting collection of Oracle dictionary statistics...
BR0285I This function can take several seconds/minutes - be patient...

BR0280I BRCONNECT time stamp: 2008-03-14 10.50.46
BR1312I Collection of Oracle dictionary statistics completed

BR0806I End of BRCONNECT processing: cdxlzegs.sta 2008-03-14 10.50.46
BR0280I BRCONNECT time stamp: 2008-03-14 10.50.46
BR0802I BRCONNECT completed successfully


Espero que esto te sirva.