Processando a instancia SQLMAG
Verificacao diaria no banco de dados SQLMAG em Mon Jul 13 06:00:00 CDT 2009

=========================================================================
  Processos de banco de dados
=========================================================================
  oracle 14244     1   0   Jun 14 ?          70:58 ora_pmon_SQLMAG

=========================================================================
  Processos de Listener ativos
=========================================================================
  oracle 18395     1   0   Jun 14 ?           1:50 /oracle/u01/software/rdbms/11.0.1/bin/tnslsnr listener0 -inherit
  oracle 18401     1   0   Jun 14 ?           1:53 /oracle/u01/software/rdbms/11.0.1/bin/tnslsnr listener1 -inherit
  oracle 18390     1   0   Jun 14 ?           2:55 /oracle/u01/software/rdbms/11.0.1/bin/tnslsnr listener2 -inherit
  oracle 18398     1   0   Jun 14 ?           1:48 /oracle/u01/software/rdbms/11.0.1/bin/tnslsnr listener3 -inherit

=========================================================================
  Backup logico: Export
=========================================================================
SQLMAG (9800 sec) Export 2.3.45 completed successfully Sun Jul 12 22:46:20 CDT 2009

=========================================================================
  Backup fisico: Hot Backup
=========================================================================
SQLMAG (7035 sec) Hot backup 2.3.45 completed successfully Sun Jul 12 23:57:15 CDT 2009

=========================================================================
Erros encontrados no ALERT LOG
=========================================================================
Nenhum erro encontrado em /oracle/admin/SQLMAG/bdump/alert_SQLMAG.log 

=========================================================================
Procurando por novos arquivos de Trace
=========================================================================
Arquivos de trace gerado em /oracle/admin/SQLMAG/udump nas ultimas 24 horas
/oracle/admin/SQLMAG/udump/SQLMAG_ora_6489.trc
/oracle/admin/SQLMAG/udump/SQLMAG_ora_1696.trc

Arquivos de trace gerado em /oracle/admin/SQLMAG/bdump nas ultimas 24 horas
/oracle/admin/SQLMAG/bdump/SQLMAG_m001_19612.trc
/oracle/admin/SQLMAG/bdump/SQLMAG_m001_25716.trc
/oracle/admin/SQLMAG/bdump/SQLMAG_m001_22601.trc

=========================================================================
Objetos com status INVALIDO
=========================================================================

Owner           Object                         Type                 Status     DDL Date                                           
--------------- ------------------------------ -------------------- ---------- ---------------------                              
SYS             DBMS_SQLPA                     PACKAGE BODY         INVALID    06/14/2009 02:52:44                                
                X_$BH                          VIEW                 INVALID    06/14/2009 02:52:46                                
SYSTEM          X$BH                           SYNONYM              INVALID    06/14/2009 02:52:47                                

=========================================================================
Novos Objetos criados nas ultimas 24 horas
=========================================================================

New Object                       Object Type     Created On Owned By                                                              
-------------------------------- --------------- ---------- ---------------                                                       
SQLMAG_REVISTAS                  TABLE PARTITION 07-13-2009 SQLMAG                                                                   

=========================================================================
Tipos de Objetos e Status
=========================================================================

Owner                     Type                 Status            Count                                                            
------------------------- -------------------- ---------- ------------                                                            
SQLMAG                    INDEX                VALID                86                                                            
                          PACKAGE              VALID                 7                                                            
                          PACKAGE BODY         VALID                 7                                                            
                          PROCEDURE            VALID                25                                                            
                          SEQUENCE             VALID                25                                                            
                          SYNONYM              VALID                 1                                                            
                          TABLE                VALID                66                                                            
                          TRIGGER              VALID               124                                                            
SQLMAGADMIN               FUNCTION             VALID                 1                                                            
                          PACKAGE              VALID                 7                                                            
                          PACKAGE BODY         VALID                 7                                                            
                          PROCEDURE            VALID                 9                                                            
                          SYNONYM              VALID               115                                                            
PUBLIC                    SYNONYM              VALID             2,583                                                            

14 rows selected.

=========================================================================
Status dos Jobs
=========================================================================

no rows selected

=========================================================================
Status das Constraints
=========================================================================

Owner                     Type  Status      Total                                                                                 
------------------------- ----- ---------- ------                                                                                 
SQLMAG                    C     ENABLED       514                                                                                 
SQLMAG                    P     ENABLED        63                                                                                 
SQLMAG                    R     ENABLED        56                                                                                 
SQLMAG                    U     ENABLED         7                                                                                 
SQLMAGADMIN               C     ENABLED       341                                                                                 
SQLMAGADMIN               P     ENABLED        59                                                                                 
SQLMAGADMIN               R     ENABLED        57                                                                                 

7 rows selected.

=========================================================================
Tablespaces em modo de BACKUP
=========================================================================

no rows selected

=========================================================================
Usuarios definidos na Tablespace SYSTEM
=========================================================================

no rows selected

=========================================================================
Capacidade das Tablespaces
=========================================================================

                                Allocated       Used       Free     Pct                                                           
Tablespace                         MBytes     MBytes     MBytes    Free                                                           
------------------------------ ---------- ---------- ---------- -------                                                           
SQL_DADOS                          32.768     26.790      5.978   18,24                                                           
SQL_INDICE                         34.816     27.966      6.850   19,68                                                           
UNDO                                4.000      2.890      1.110   27,76                                                           
SYSTEM                              1.000        340        660   66,01                                                           
SYSAUX                              1.000        247        753   75,32                                                           
TOOLS                               5.874      1.216      4.658   79,30                                                           
USERS                               1.000         38        962   96,20                                                           
                               ---------- ---------- ----------                                                                   
Total:                             80.458     59.487     19.971                                                                   

7 rows selected.

=========================================================================
Atividade de I/O nas Tablespaces onde leitura ou escrita > 5000
=========================================================================

Tablespace                          Blocks Read   Blocks Written        Read Time       Write Time   Total I/O Time               
------------------------------ ---------------- ---------------- ---------------- ---------------- ----------------               
SQL_DADOS                         3.508.517.761        1.627.255       22.079.796          287.388       22.367.184               
SQL_INDICE                           54.070.730        5.075.448       12.354.571          442.499       12.797.070               
UNDO                                    393.609        2.237.128          788.445          131.225          919.670               
TOOLS                                 2.150.750                0          856.131                0          856.131               
SYSTEM                                1.701.140          101.746          247.421           21.246          268.667               
SYSAUX                                8.071.191          287.362          192.183           49.421          241.604               
                               ---------------- ---------------- ---------------- ---------------- ----------------               
Total:                            3.574.905.181        9.328.939       36.518.547          931.779       37.450.326               

6 rows selected.

=========================================================================
Tabelas/Indices que irao falhar no proximo extent
=========================================================================

no rows selected

=========================================================================
Arquivos definidos com AUTOEXTEND
=========================================================================

no rows selected

=========================================================================
Leitura/Escrita por Database File
=========================================================================

File Name                                                      Physical Reads  Physical Writes        Total IOs                   
------------------------------------------------------------ ---------------- ---------------- ----------------                   
/oracle/u01/bd01/oradata/SQLMAG/SQLMAG_DADOS_09.dbf               592.145.977          189.649      592.335.626                   
/oracle/u01/bd01/oradata/SQLMAG/SQLMAG_DADOS_08.dbf               436.149.167          178.910      436.328.077                   
/oracle/u01/bd01/oradata/SQLMAG/SQLMAG_DADOS_01.dbf               420.191.505          198.429      420.389.934                   
/oracle/u01/bd01/oradata/SQLMAG/SQLMAG_DADOS_02.dbf               368.142.088          193.637      368.335.725                   
/oracle/u01/bd01/oradata/SQLMAG/SQLMAG_DADOS_03.dbf               305.744.601          195.476      305.940.077                   
/oracle/u01/bd01/oradata/SQLMAG/SQLMAG_DADOS_04.dbf               107.863.045          164.659      108.027.704                   
/oracle/u01/bd01/oradata/SQLMAG/SQLMAG_DADOS_07.dbf                53.165.206            4.606       53.169.812                   
/oracle/u01/bd01/oradata/SQLMAG/SQLMAG_DADOS_05.dbf                37.389.724                0       37.389.724                   
/oracle/u01/bd01/oradata/SQLMAG/SQLMAG_DADOS_06.dbf                37.115.393                0       37.115.393                   
/oracle/u01/bd01/oradata/SQLMAG/SYSAUX_01.dbf                       7.750.362          212.623        7.962.985                   
/oracle/u01/bd02/oradata/SQLMAG/SQLMAG_INDICE_03.dbf                7.626.847          117.324        7.744.171                   
/oracle/u01/bd02/oradata/SQLMAG/SQLMAG_INDICE_07.dbf                7.612.958          118.531        7.731.489                   
/oracle/u01/bd02/oradata/SQLMAG/SQLMAG_INDICE_05.dbf                7.601.838          123.729        7.725.567                   
/oracle/u01/bd02/oradata/SQLMAG/SQLMAG_INDICE_06.dbf                7.589.720          122.551        7.712.271                   
/oracle/u01/bd02/oradata/SQLMAG/SQLMAG_INDICE_02.dbf                7.579.435          106.161        7.685.596                   
/oracle/u01/bd02/oradata/SQLMAG/SQLMAG_INDICE_01.dbf                7.575.329          108.894        7.684.223                   
/oracle/u01/bd02/oradata/SQLMAG/SQLMAG_INDICE_04.dbf                7.567.040          101.448        7.668.488                   
/oracle/u01/bd02/oradata/SQLMAG/SQLMAG_INDICE_16.dbf                7.549.010          106.857        7.655.867                   
/oracle/u01/bd02/oradata/SQLMAG/SQLMAG_INDICE_15.dbf                6.416.166           81.561        6.497.727                   
/oracle/u01/bd02/oradata/SQLMAG/SQLMAG_INDICE_14.dbf                5.897.831           54.133        5.951.964                   
/oracle/u01/bd02/oradata/SQLMAG/SQLMAG_INDICE_13.dbf                4.691.580           21.313        4.712.893                   
/oracle/u01/bd02/oradata/SQLMAG/SQLMAG_INDICE_12.dbf                4.667.810           20.820        4.688.630                   
/oracle/u01/bd02/oradata/SQLMAG/SQLMAG_INDICE_11.dbf                4.522.814           21.009        4.543.823                   
/oracle/u01/bd02/oradata/SQLMAG/SQLMAG_INDICE_09.dbf                4.186.561           20.858        4.207.419                   
/oracle/u01/bd02/oradata/SQLMAG/SQLMAG_INDICE_10.dbf                3.997.177           22.057        4.019.234                   
/oracle/u01/bd02/oradata/SQLMAG/SQLMAG_INDICE_08.dbf                3.729.032           29.431        3.758.463                   
/oracle/u01/bd01/oradata/SQLMAG/system01.dbf                        1.242.025           88.013        1.330.038                   
/oracle/u01/bd02/oradata/SQLMAG/UNDO_01.dbf                           218.451          423.348          641.799                   
/oracle/u01/bd02/oradata/SQLMAG/UNDO_02.dbf                           175.158          350.472          525.630                   
/oracle/u01/bd01/oradata/SQLMAG/tools04.dbf                            85.403                0           85.403                   
/oracle/u01/bd02/oradata/SQLMAG/tools01.dbf                            75.553                0           75.553                   
/oracle/u01/bd02/oradata/SQLMAG/tools02.dbf                            67.146                0           67.146                   
/oracle/u01/bd02/oradata/SQLMAG/tools03.dbf                            63.690                0           63.690                   
/oracle/u01/bd02/oradata/SQLMAG/users01.dbf                               338               58              396                   

34 rows selected.

=========================================================================
Tabelas que possuem estatisticas coletadas (por esquema)
=========================================================================

Owner                         Analyzed Not Analyzed                                                 
------------------------- ------------ ------------                                                 
SQLMAG                              66            0                                                 
SQLMAGADMIN                         68            0                                                 

2 rows selected.

=========================================================================
Atividades de Full Table Scan
=========================================================================

Statistic                                           Value                                           
---------------------------------------- ----------------                                           
DBWR lru scans                                          0                                           
cluster key scan block gets                   681.648.884                                           
cluster key scans                             204.154.191                                           
index fast full scans (direct read)                     0                                           
index fast full scans (full)                    1.773.165                                           
index fast full scans (rowid ranges)                    0                                           
index scans kdiixs1                             5.886.047                                           
table scan blocks gotten                   14.777.950.339                                           
table scan rows gotten                    695.021.599.736                                           
table scans (cache partitions)                          5                                           
table scans (direct read)                          12.151                                           
table scans (long tables)                         679.858                                           
table scans (rowid ranges)                             18                                           
table scans (short tables)                      1.469.764                                           

14 rows selected.

=========================================================================
Esperas por Data Block e Free List
=========================================================================

Wait Type                  Count                                                                    
--------------- ----------------                                                                    
data block            60.649.731                                                                    
free list                      0                                                                    

=========================================================================
Numero de esperas por Free Buffers
=========================================================================

no rows selected

=========================================================================
Taxa de acerto em Buffer Pool
=========================================================================

Pool           Ratio                                                                                                              
------------ -------                                                                                                              
DEFAULT        97,09                                                                                                              

=========================================================================
Sessoes: Taxa de acerto < 60%
=========================================================================

User Session          Consistent Gets    DB Block Gets   Physical Reads Hit Ratio                                                 
-------------------- ---------------- ---------------- ---------------- ---------                                                 
SQLMAG(4092)                3.469.772           81.176        2.841.846     19,97                                                 
SQLMAG(2743)                1.795.101           53.104        1.476.026     20,14                                                 
SQLMAG(5488)                3.225.976           54.544        2.615.740     20,26                                                 
SQLMAG(5475)               11.422.148          203.102        9.164.062     21,17                                                 
SQLMAG(5480)                1.956.772           56.855        1.579.363     21,57                                                 
SQLMAG(1297)               10.570.084          214.247        8.392.244     22,18                                                 
SQLMAG(4108)                3.464.004           67.040        2.736.016     22,52                                                 
SQLMAG(5471)                  336.469            4.415          264.084     22,53                                                 
SQLMAG(5434)               11.336.280          246.872        8.929.533     22,91                                                 
SQLMAG(4080)                2.476.926           72.180        1.963.593     22,97                                                 
SQLMAGADMIN(5458)          11.906.568            5.193        8.464.543     28,94                                                 
SQLMAGADMIN(4083)             547.040           47.879          420.733     29,28                                                 
SQLMAGADMIN(2714)           7.584.930            3.188        5.361.729     29,34                                                 
SQLMAGADMIN(5442)           8.544.924            4.090        6.001.215     29,80                                                 
SQLMAGADMIN(1339)           4.450.087          363.613        3.368.564     30,02                                                 
SQLMAGADMIN(5469)           7.793.937            3.000        5.433.308     30,31                                                 
SQLMAGADMIN(4105)          17.780.556            8.518       12.365.857     30,49                                                 

17 rows selected.

=========================================================================
Estatisticas de Library Cache
=========================================================================
                                                 Get                               Pin                                            
Namespace                  Gets     Get Hits   Ratio         Pins     Pin Hits   Ratio      Reloads                               
------------------ ------------ ------------ ------- ------------ ------------ ------- ------------                               
JAVA DATA                     0            0  100,00            0            0  100,00            0                               
JAVA RESOURCE                 0            0  100,00            0            0  100,00            0                               
JAVA SOURCE                   0            0  100,00            0            0  100,00            0                               
OBJECT                        0            0  100,00            0            0  100,00            0                               
PIPE                          0            0  100,00            0            0  100,00            0                               
BODY                     83.007       82.494   99,38   52.676.450   52.675.832  100,00            7                               
CLUSTER                  16.841       16.727   99,32       35.518       35.394   99,65           10                               
TRIGGER                   7.205        7.036   97,65   23.443.864   23.443.264  100,00          418                               
TABLE/PROCEDURE         349.723      324.495   92,79  112.870.323  112.747.477   99,89       60.226                               
INDEX                    13.198        8.556   64,83       75.837       69.047   91,05           15                               
SQL AREA              7.740.909    3.569.853   46,12   31.283.053   24.942.249   79,73       26.500                               

11 rows selected.

=========================================================================
Informacoes de ajuste de log_buffer e Redo Log
=========================================================================

Statistic                                           Value                                                                         
---------------------------------------- ----------------                                                                         
redo synch writes                              17.232.235                                                                         
redo synch time                                 9.764.487                                                                         
redo blocks read for recovery                           0                                                                         
redo entries                                   77.784.834                                                                         
redo size                                  37.605.193.728                                                                         
redo buffer allocation retries                        970                                                                         
redo wastage                                3.695.925.904                                                                         
redo writer latching time                           2.032                                                                         
redo writes                                    19.870.725                                                                         
redo blocks written                            83.344.765                                                                         
redo write time                                 6.971.794                                                                         
redo log space requests                             1.117                                                                         
redo log space wait time                            5.398                                                                         
redo log switch interrupts                              0                                                                         
redo ordering marks                             1.321.305                                                                         
redo subscn max counts                          2.327.976                                                                         

16 rows selected.

=========================================================================
Execucoes de Objetos na Shared Pool (Execs > 100)
=========================================================================

Owner           Object Name                      Object Type    Executions                                                        
--------------- -------------------------------- ------------ ------------                                                        
SQLMAG          FORMATACAO                       PACKAGE BODY   17.844.159                                                        
SYS             UTL_FILE                         PACKAGE BODY    1.117.431                                                        
SQLMAGADMIN     VERIFICA_ARTIGOS                 PROCEDURE         781.486                                                        
SYS             UTL_RAW                          PACKAGE BODY      540.610                                                        
SYS             DBMS_SYS_SQL                     PACKAGE BODY      385.402                                                        
SYS             DBMS_SQL                         PACKAGE BODY      375.629                                                        
SYS             DBMS_APPLICATION_INFO            PACKAGE BODY      155.022                                                        
SQLMAGADMIN     VERIFICA_CARACTERES              PACKAGE BODY      153.580                                                        
SYS             DBMS_OUTPUT                      PACKAGE BODY       45.220                                                        
SQLMAG          FORMATA_CODIGO                   PROCEDURE          28.048                                                        
SYS             DBMS_UTILITY                     PACKAGE BODY       10.222                                                        
SYS             DBMS_DDL_INTERNAL                PACKAGE BODY        7.532                                                        
SYS             DBMS_DATAPUMP                    PACKAGE BODY        6.972                                                        
SYS             DBMS_STATS                       PACKAGE BODY        2.898                                                        
SYS             DBMS_FLASHBACK                   PACKAGE BODY        1.008                                                        
SYS             UTL_TCP                          PACKAGE BODY          816                                                        
SYS             UTL_SMTP                         PACKAGE BODY          288                                                        

17 rows selected.

=========================================================================
Numero de Objetos que falharam ao obter espaco na Shared Pool
=========================================================================

no rows selected

=========================================================================
Fragmentacao da Shared pool
=========================================================================

   total                           total                                                                                          
   bytes      free  largest        bytes   used   largest       total  request request   Miss  Fail to                            
   free      count   free           used  count      used    requests   misses   fails    PCT Miss PCT                            
----------- ------ --------- ----------- ------ --------- ----------- -------- ------- ------ --------                            
   45149504     86   1007432     6229528    195    405800        6340        0       0    .00                                     

=========================================================================
Utilizacao de memoria da Shared Pool - Maiores primeiro
=========================================================================

Owner           Object Name                    Object Type        Sharable Size                                                   
--------------- ------------------------------ --------------- ----------------                                                   
SYS             DBMS_STATS                     PACKAGE BODY             520,326                                                   
SYS             DBMS_SQL                       PACKAGE                  181,924                                                   
SYS             DBMS_DATAPUMP                  PACKAGE BODY             166,345                                                   
SYS             PRVT_ADVISOR                   PACKAGE BODY              96,896                                                   
SYS             DBMS_SYS_SQL                   PACKAGE BODY              79,864                                                   
SYS             DBMS_UTILITY                   PACKAGE BODY              47,032                                                   
SQLMAG          FORMATACAO                     PACKAGE BODY              46,621                                                   

7 rows selected.

=========================================================================
Objetos "pinados" na Shared Pool
=========================================================================

Object Type          Object Name                              Kept                                                                
-------------------- ---------------------------------------- ----                                                                
CLUSTER              C_COBJ#                                  YES                                                                 
                     C_FILE#_BLOCK#                           YES                                                                 
INDEX                I_FIXED_OBJ$_OBJ#                        YES                                                                 
                     I_HH_OBJ#_COL#                           YES                                                                 
                     I_TAB_STATS$_OBJ#                        YES                                                                 
TABLE                BOOTSTRAP$                               YES                                                                 
                     FIXED_OBJ$                               YES                                                                 
                     HISTGRM$                                 YES                                                                 
                     HIST_HEAD$                               YES                                                                 
                     IND$                                     YES                                                                 
                     IND_STATS$                               YES                                                                 
                     OBJ$                                     YES                                                                 
                     OBJECT_USAGE                             YES                                                                 
                     TAB$                                     YES                                                                 
                     TAB_STATS$                               YES                                                                 
                     TS$                                      YES                                                                 
                     UNDO$                                    YES                                                                 
                     USER$                                    YES                                                                 

18 rows selected.