Análise de Desempenho do Banco de Dados

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

2.2 verificar a memória em um computador com CMD
MSINFO32 
2.2 ANÁLISE DAS TABLESPACES
Set lines 120 pages 100
select a.tablespace_name, alocado, livre, maximo
from (Select tablespacE_name, sum(bytes)/1024/1024 alocado,
sum(maxbytes)/1024/1024 maximo
from dba_data_files
group by tablespace_name) a,
(select tablespace_name, sum(bytes)/1024/1024 livre
from dba_free_space
group by tablespace_name) b
where a.tablespace_name = b.tablespace_name(+)
order by 1;
2.2 Tamanho do ASM e tamanho que os datafiles estão ocupando no ASM. 
select sum(bytes)/1024/1024 as TOTAL_MB from dba_data_files;
2.3	Análise dos Jobs programados
select job, next_date , last_date, broken, failures from dba_jobs;
2.4	Atualização das estatísticas do banco de dados:
select owner, trunc(last_analyzed), count(*)
From dba_tables
Where owner not like '%SYS%'
Group by owner, trunc(last_analyzed)
Order by 1,2;
2.5	Objetos inválidos ou desabilitados:
@%ORACLE_HOME%/rdbms/admin/utlrp 
2.6	Objetos com alto nível de fragmentação
column owner format a15
column segment_type format a10
column segment_name format a22
select owner, segment_type, segment_name, bytes/1024/1024 as bytes, extents from dba_segments
Where extents > 100
and owner not like '%SYS%'
order by extents, segment_type;
2.7	Status dos database links
select db_link, username, host from dba_db_links;
2.8	Backups realizados
Verificar Task 
2.9	Análise de Buffer Cache, PGA e Shared Pool
@%ORACLE_HOME%/rdbms/admin/awrrpt
@%ORACLE_HOME%/rdbms/admin/spdrop
 @%ORACLE_HOME%/rdbms/admin/spcreate
Exec perfstat.statspack.snap;
@%ORACLE_HOME%/rdbms/admin/spreport 
Buffer Pool Advisory, Shared Pool Advisory e PGA Memory Advisory
busca pelo erro ORA-