Amazon books

Thursday, February 11, 2016

Thew db_performance_profile parameter - IORM Exadata and above

The new PROFILE type of IORM on versions above make things simple:

(name=dimond, share=10, limit=100, type=profile),
(name=gold, share=5, limit=60, type=profile),
(name=silver, share=1, limit=20, type=profile))

Go to your database and run this change:

SQL> alter system set db_performance_profile=gold scope=spfile;

With that we do not need to specify/change plan directives every time we create new databases.

Best Regards,
Paulo Portugal

Wednesday, February 10, 2016

Increasing your Capacity-on-Demand on Database Servers - Exadata

If you want to increase the number of licensed cores in your DB Servers you can use this command below:

resourceControl -capacity_on_demand {display | disable | enable}
[-cores number_of_cores] [-force]

Remember that you cannot decrease once you increase this number.

Best Regards,
Paulo Portugal

Exadata I/O Instance Capping

A great feature to use in newer versions of Exadata is I/O Latency Capping. Together with this configuration example "CellCLI> ALTER CELL iotimeoutthreshold = '5s'"  you can told your Exa to point to a block mirror that is in a faster disk. Do not set it before checking your I/O information in AWR and other tools/commands. Best Regards,

Paulo Portugal

Wednesday, January 13, 2016

Installing the Backup Module of ZDLRA is simple

1-Download the file at

2-Unzip and install using this command example that you can find in README.txt file

% java -jar ra_install.jar  -dbUser joe -dbPass Oracle
  -walletDir $ORACLE_HOME/dbs/ra_wallet  -libDir $ORACLE_HOME/lib/
Recovery Appliance Install Tool, build 2014-08-07
Recovery Appliance credentials are valid.
Recovery Appliance wallet created in directory /orclhome/dbs/ra_wallet.
Recovery Appliance initialization file /orclhome/dbs/rat1.ora created.
Downloading Recovery Appliance Software Library from file
Download complete.
Extracted file /orclhome/lib/

That's it.

You finished this step.

Best Regards,
Paulo Portugal

Thursday, December 24, 2015

The new restore control file restore from service

Now we can restore a control file from service using a simple command:


Best Regards,
Paulo Portugal

Creating SPARSE Diskgroup - Exadata Snapshot Clones

create diskgroup DG_SPARSE
  normal redundancy 
  disk 'o/*/SPARSE_*'
    'compatible.asm'          = '',
    'compatible.rdbms'        = '',
    'cell.smart_scan_capable' = 'true',
    'cell.sparse_dg'          = 'allsparse',
    'au_size'                 = '4M';

Wednesday, November 4, 2015

Using Rapid Home Provisioning Tool on DB12c

This tool can be used to create rapid clone providing clients, add and delete roles for users, add delete and import images and others.


--Check actual images:

rhpctl query image

--Get more details of certain image:

rhpctl query image -image MYDB12

--Get workingcopy details
rhpctl query workingcopy -image MYDB12

Best Regards,
Paulo Portugal