Friday, November 25, 2016

How to find the page size for a Linux installation

›
In order to set one of the mandatory kernel parameters in a Red Hat flavored Linux distribution, you need to know the page size. To find it...
Monday, November 21, 2016

How to install and use the character set scanner

›
Although deprecated since the release of DMU (Database Migration utility for Unicode), there are still cases where you need to run csscan. ...
Thursday, November 17, 2016

How to create a blackout in Cloud Control using the command-line interface

›
Source your environment to point to the correct ORACLE_HOME. Put the following in a file called .agentenv export ORACLE_BASE=/software/orac...
Monday, November 14, 2016

A short history of the Automated Maintenance Tasks in Oracle

›
Predefined Automatic System Tasks were introduced in Oracle 10g, and consisted of two jobs: 1. Automated statistics collection 2. The Aut...

How to check the status of the Automated Maintenance Tasks in Oracle 11g

›
To see the currently enabled jobs in your database, use the dictionary view DBA_AUTOTASK_OPERATION which displays all automated maintenanc...
Friday, November 4, 2016

Quick guide to set up Transparent Data Encryption for a tablespace

›
If not already done, create a folder for the wallet: # mkdir -p /u01/oracle/admin/proddb01/wallet Step 1: configure the software keystore...
Wednesday, October 5, 2016

Find column semantics

›
When migrating from single-byte code to multi-byte code character sets, one way to move your data without data loss is to change the seman...