Fix Control underscore parameter

Fix Control underscore parameter

Changing password sys or sysasm

Changing SYS or SYSASM

Install Oracle 12c

Download MobaXterm or use putty Set up EC2 instance using OL7.2-x86_64-HVM-2015-12-10 Amazon Machine Image (AMI) with three additional volumes of 5, 8 and 10 gb (this will make your life easier). I use additional sizes to accommodate increase in volume workload. When setting up on EC2 the base use to login with is EC2 Login via MobaXterm […]

profile_env

[code language=”sql”] ############################################################################# #   FILENAME: .profile_env #   PURPOSE: Custom environment variables or additions to the PATH may be #            placed here.  You can edit anything in this file, this file is #            used to customize the environment. ############################################################################# # # #  Revision History: # # # #  REV   DATE         BY        DESCRIPTION # #  —  ——  […]

Backup Options 12c

Making Compressed Backups For any use of the BACKUP command that creates backup sets, you can take advantage of RMAN support for binary compression of backup sets. Specify the AS COMPRESSED BACKUPSET option to the BACKUP command. RMAN compresses the backup set contents before writing them to disk. The details of which binary compression level […]

Oracle Price List June 2017

Oracle June 2017 price list Here is a current version of the Oracle price list  

AMM

The  buffer exterminate wait event is caused when using Oracle’s “automatic memory management” (AMM) when the MMON process shrinks the data buffer cache to re-allocate that RAM for another SGA region. AMM resize operations can hurt overall database performance especially the OLTP environments, and you may want to consider turning off AMM which will relieve […]