bedbmsguru

출처:http://oracle.tistory.com/430

1. 세션별 CPU Time, Memory 사용량
 
select s.sid, s.serial#, p.spid as "os pid", s.username, s.module, s.sql_id, event, seconds_in_wait,
st.value/100 as "cpu sec",
round(pga_used_mem/1024/1024) "pga_tot(mb)",
round(pga_used_mem/1024/1024) "pga_per_sess(mb)"
from v$sesstat st, v$statname sn, v$session s, v$process p
where sn.name = 'CPU used by this session' -- cpu
and st.statistic# = sn.statistic#
and st.sid = s.sid
and s.paddr = p.addr
and s.last_call_et < 1800 -- active within last 1/2 hour
and s.logon_time > (SYSDATE - 240/1440) -- sessions logged on within 4 hours
order by st.value

 
 
 
 
2. Client별 Memory 사용량
 
select machine,status,count(*) cnt, 
       round(sum(pga_used_mem)/1024/1024) "pga_tot(mb)",
       round(sum(pga_used_mem)/count(*)/1024/1024) "pga_per_sess(mb)"
from v$session s, v$process p
where 1=1
--and s.status='active'
and s.paddr=p.addr
and type <> 'BACKGROUND'
group by machine,status
order by 1

출처: http://oracle.tistory.com/430 [안나푸르나]

column customizing 포함

$a = @{Expression={$_.SamAccountName}; Label="Column 1"; Width=50},
@{Expression={$_.surName}; Label="Column 2"; Width=50},
@{Expression={$_.Description}; Label="Column 3"; Width=50},
@{Expression={$_.Created}; Label="Column 4"; Width=50},
@{Expression={$_.LastLogonDate}; Label="Column 4"; Width=50}

Get-ADUser -Properties SamAccountName, surName, Description, Created, LastLogonDate -Filter {ObjectClass -eq "user"} -SearchBase "OU=MYOU,DC=mydc,DC=co,DC=kr" | Sort-Object -property SamAccountName | Select-object SamAccountName, surName, Description, Created, LastLogonDate | Format-Table -property $a > d:\aa.txt 

Mariadb 를 10.2.18  --> 10.2.19로 업그레이드를 하고 나니 xtrabackup을 이용한  백업이 

unsupported redo log format. the redo log was created 

라는 에러가 나면서 백업이 되지 않는다 해서 찾아낸게 mariabackup  명령어만 다르고 옵션이나 

사용법은 동일하다.

1. xtrabackup을 사용해서백업 복구

(1) 백업

mariabackup --backup --user=root --password='암호' --target-dir=/usr/dat/zabbix_backup

mariabackup --prepare  --target-dir=/usr/dat/zabbix_backup

(2)복구

rsync -avrP /root/aaa/ /var/lib/mysql/

--SELinux 등록

chcon -Rt mysqld_db_t /var/lib/mysql

chcon -Ru system_u /var/lib/mysql

chown -R mysql:mysql /var/lib/mysql

--권한 등록

sudo chown -cR mysql:mysql /var/lib/mysql/*

sudo chown mysql:mysql /var/lib/mysql

--mariadb 10.2 version에서 old redo log를 이용한 crash recovery 시도를 막기 위해아래 파일들을 지워준다.

rm /var/lib/mysql/ib_logfile*

--시작

sudo systemctl start mariadb

출처: https://mariadb.com/kb/en/library/full-backup-and-restore-with-mariabackup/