Prometey Lab Blog — Страница 12 — Oracle, PostgreSQL, DevOps

Create restore point without sysdba role

21.07.201607.09.2015 от Bushmelev Anton

create procedure to create\drop restore point: create scheduler job to call os scripts create and assign credentials and pin scheduler job to first node ( where scripts placed ) drop_restore_point.sh create_restore_point.sh so, after all create and delete restore point looks like :

oracle restart single change hostname

08.10.201514.08.2015 от Bushmelev Anton

deconfig config add resources change hostname in $ORACLE_HOME/netowrk/admin/listener.ora grid user oracle user:

find current effective hidden param

08.10.201511.08.2015 от Bushmelev Anton

script to analyze partition tables data distribution

10.08.2015 от Bushmelev Anton

disk latency from ash by time

25.12.201507.08.2015 от Bushmelev Anton

some queryes to measure disk io generate pivot list or top wait pivot list: query and result this output can be used to build graphs:

audit purge

01.06.201728.07.2015 от Bushmelev Anton

short way truncate table sys.aud$ =))) create purge audit job Or audit all purge job: create job to update what can job delete from audit SELECT * FROM dba_audit_mgmt_config_params; SELECT * FROM dba_audit_mgmt_last_arch_ts; select * from DBA_AUDIT_MGMT_CLEAN_EVENTS; Standard_Audit_Trail_Purge_Job STOP: Drop: Manual run: list of DBMS_AUDIT_MGMT. —>AUDIT_TRAIL_ALL

postgrespro pg_stat_wait patch

08.10.201521.07.2015 от Bushmelev Anton

usefull materials github postgrespro Waits monitoring on mail list of postgresql.org pgconf2015 slides Packages ubuntu: fedora: Install from source enable waits monitoring add to postgresql.conf ### alter system set waits_monitoring=on; ps: Many thanks to Vladimir Borodin for help !

awr report by hour

25.11.201608.07.2015 от Bushmelev Anton

simplest way to generate awr report by hour after benchmark
export awr

@?/rdbms/admin/awrextr.sql

import awr

@?/rdbms/admin/awrload.sql

— make sure to set line size appropriately
— set linesize 152

generate awr

 set termout off
set linesize 80
set pagesize 10000
select 'spool awrrpt_dwhfrn_'|| snap_id ||'.html'|| chr(13)||
 'select output from table(dbms_workload_repository.awr_report_text('||dbid||',1,'||snap_id||','|| LEAD (snap_id, 1)  OVER (ORDER BY  dbid,snap_id ) ||',0));' || chr(13)||
 ' spool off '
 from dba_hist_snapshot where dbid !=1399642255 and extract( minute from begin_interval_time ) <2 ;

virtualbox shared storage create on linux

25.06.2015 от Bushmelev Anton

create shared storage: data: for i in {1..10};do vboxmanage createhd —filename asm_$i —size 10240 —format VDI —variant Fixed; done OCR: for i in {1..3};do vboxmanage createhd —filename vote_$i —size 1200 —format VDI —variant Fixed; done make disk shareable: for i in `ls -1 *.vdi`; do vboxmanage modifyhd $i —type shareable; done add disk to virtual … Читать далее