Administracja sieci teleinformatycznych
Cyberbezpieczeństwo
ORACLE AWR
Oracle Enterprise Manager => Advisor CentralAWR (Automatic Workload Repository)statystyki przechowywane w tabelach WRH$ w przestrzeni SYSAUXwarunki:STATISTICL_LEVEL= TYPICAL | ALLwidoki:memory:DBA_HIST_SGADBA_HIST_PGASTATDBA_HIST_PGA_TARGET_DEVICE...
ORACLE DBLINKS
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];
ORACLE UNDO
shrink undo tablespace:* CREATE UNDO TABLESPACE [name] DATAFILE '[path]' size [nr]G ;* ALTER SYSTEM SET UNDO_TABLESPACE = [name];* DROP TABLESPACE [old_name] including contents and datafiles;check rollback status:SELECT used_urec FROM v$transaction; --recordsSELECT...
ORACLE CREATE
create database manualy:* create PFILEmain changes:- db_name- control_files- audit_file_dest- background_dump_dest- user_dump_dest- core_dump_destexample...
ORACLE LOCKS
find locks:select oracle_username os_user_name, locked_mode, object_name, object_typefrom v$locked_object a,dba_objects bwhere a.object_id = b.object_id select l1.sid, ' BLOCK ', l2.sid from v$lock l1, v$lock l2 where l1.block =1 and l2.request > 0 and...
POSTGRESQL
psql tryb OS psql [option] -d [dbname] -h [hostname] -U [username] psql -llista baz psql -f [file]pobieraj komendy z pliku tryb psql psql syntax: \timingustaw wskazanie czas wykonania SQL \qwyjdź \passwordustaw hasło \psetzmień ustawienia psql \lpokaż bazy \d...