To set the operating system user for a PDB: 1. Log in to the root as a user and execute the DBMS_CREDENTIAL.CREATE_CREDENTIAL procedure to create an Oracle credential for the $user operating system user: 2. Connect to the PDB to set the PDB_OS_CREDENTIAL to the new credential: 3. Restart the CDB instance. 4. Test the … Читать далее
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