Test was done on VM with 4X CPU E5-2660 2.20GHz + 4GB mem with tools written by pgbench-tools on postgresql 9.4.5 settings: run test 3 times by 10 min, db size 100(1.5gb) 400(6gb) 700 (10gb) 1000 (15gb), clients 1,2,4,8,16,32 Results: with the exception of an anomalous drawdown in the last test, without selinux performance gain … Читать далее
quick way to make standby of small database is to make backup, copy it to destination and create standby backup on source: param file: copy to standby,modify audit dest and create spfile: restore database: configure standby: DGMGRL> show configuration;
script to monitor status of full and inc backup
fixed by merge of 2 folders from rac nodes into single directory:
hi, there is a script to find out cpu load from awr by one instance ( in example number two ) : ps: usefull to make graphs linke this:
in addition to how to backup invalid object source : and drop them:
Unfortunately, the old Metalink note 175982.1 which used to describe the internal mnemonic’s has disappeared from My Oracle Support. Modified: 16-AUG-2011 Type: BULLETIN Status: PUBLISHED In this Document Purpose Scope and Application ORA-600 Lookup Error Categories Internal Errors Categorised by number range Internal Errors Categorised by mnemonic Applies to: Oracle Server … Читать далее
script to monitor tablespace usage, in this example warn me if tablespace usage is more than 85% and free space in in lower than 30GB same thing but for asm : check scheduler state ( last running job status ) check invalid objects check unusable index
Oracle Database 12c: Security 13 — 3 Enabling and Managing OLS •Register and enable OLS: – Using DBCA or – Executing the LBACSYS.CONFIGURE_OLS and LBACSYS.OLS_ENFORCEMENT.ENABLE_OLS procedures •The The LBACSYS schema owns all OLS objects. •Use Enterprise Manager Cloud Control (EMCC) SQL*Plus to manage the Label Security policies. •In PDBs, which canhttp://bushmelev-aa.ru/wp-admin/edit-tags.php?taxonomy=post_tag be plugged in and … Читать далее