02 12

ORACLE AWR

Oracle Komentarze (1) »
Oracle Enterprise Manager => Advisor Central


AWR (Automatic Workload Repository)
statystyki przechowywane w tabelach WRH$ w przestrzeni SYSAUX
warunki:
STATISTICL_LEVEL= TYPICAL | ALL
widoki:
memory:
DBA_HIST_SGA
DBA_HIST_PGASTAT
DBA_HIST_PGA_TARGET_DEVICE
DBA_HIST_SGASTAT
DBA_HIST_BUFFER_POOL_STAT
DBA_HIST_DB_CACHE_ADVICE
DBA_HIST_SHARED_POOL_ADVICE
sql:
DBA_HIST_SQL_SUMMARY
DBA_HIST_SQLSTAT
DBA_HIST_SQL_PLAN

other:
DBA_HIST_SYSSTAT
DBA_HIST_FILESTATXS

DBA_HIST_WR_CONTROL
DBA_HIST_SNAPSHOT
DBA_HIST_DATABASE_INSTANCE
DBA_HIST_ACTIVE_SESS_HISTORY
sprawdzenie częstotliwości:
SELECT * FROM DBA_HIST_WR_CONTROL
ustawienie częstotliwości:
DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS ([retention - min],[interwal - min]);
manualny snapshot:
DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT();
drop snapshot:
DBMS_WORKLOAD_REPOSITORY.DROP_SNAPSHOT_RANGE([low_id],[end_id]);
raporty AWR:
$oracle_home/rdbms/admin/awrrpt.sql
$oracle_home/rdbms/admin/awrrpti.sql – z wyborem instancji
raporty ADDM (Automatic Database Diagnostic Monitor:
analiza danych z AWR pod względem wąskich gardeł
$oracle_home/rdbms/admin/addmrpt.sql
 02 04

ORACLE DBLINKS

Oracle Komentarze (0) »

SELECT * FROM dba_db_links;
SELECT * FROM user_db_links;
DROP DATABASE LINK [link_name];
CREATE DATABASE LINK [link_name] CONNECT TO [user] IDENTIFIED BY [password] USING ‘[tns_alias]‘;
SELECT count(*) FROM user_tables@[link_name];

WordPress - Hosting: Twój hosting - Skórka: N.Design Studio - Spolszczenie: Adam Klimowski.
RSS wpisów RSS komentarzy Zaloguj