#11
|
|||
|
|||
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. |
Herramientas | Buscar en Tema |
Desplegado | |
|
|