Imers?o Oracle Performance Tuning / Prática 04
Eduardo Amaral Ferreira
DBA Oracle | SQL | Postgres | Mysql | Linux | OCA | OCI | AWS
Salve, salve!!
No lab de agora demonstro o uso de Métricas, Alertas e Baselines.
/* Listando os valores de limite para todos os alertas de Tablespace*/
SET LINESIZE 200
COLUMN tablespace_name FORMAT A30
COLUMN metrics_name FORMAT A30
COLUMN warning_value FORMAT A30
COLUMN critical_value FORMAT A15
SELECT object_name AS tablespace_name, metrics_name, warning_operator, warning_value,critical_operator, critical_value
FROM dba_thresholds WHERE object_type = 'TABLESPACE'ORDER BY object_name;
BEGIN
-- Database-wide KB free threshold.
DBMS_SERVER_ALERT.set_threshold(
metrics_id =>DBMS_SERVER_ALERT.tablespace_byt_free,
warning_operator =>DBMS_SERVER_ALERT.operator_le,
warning_value => '102400',
critical_operator =>DBMS_SERVER_ALERT.operator_le,
critical_value => '51200',
observation_period => 1,
consecutive_occurrences => 1,
instance_name => NULL,
object_type => DBMS_SERVER_ALERT.object_type_tablespace,object_name => NULL);
end;
/
/*Gerando um AWR de compara??o*/
@?/rdbms/admin/awrddrpt
/*Criando Snap manualmente*/
BEGIN DBMS_WORKLOAD_REPOSITORY.create_snapshot();
END;
/
/*Apagando snaps em um determinado range*/
BEGIN DBMS_WORKLOAD_REPOSITORY.drop_snapshot_range( low_snap_id=>15,High_snap_id=>20); END; /
?
/*Criando baseline*/
BEGIN DBMS_WORKLOAD_REPOSITORY.create_baseline (
start_snap_id => 35,
end_snap_id => 36,baseline_name => 'Performance Nova');
END;
/
/*E aqui listo os baselines existentes*/
col baseline_name format a30;
set lines 300
SELECT baseline_id,baseline_name,baseline_type,start_snap_id,end_snap_id
FROM dba_hist_baseline;