12.1.2.3.0 Exadata - Quorum Disks - Increase the availability of your Voting and CRS Files

If you have a QH of EH and want to increase the availability of your voting and css files, you can do so by multiplexing them in DB Nodes using a new feature called QUORUM Disks.

All the steps necessary are described here:

https://docs.oracle.com/cd/E50790_01/doc/doc.121/e51951/db_server.htm#DBMMN22700


They are done using the quorumdiskmgr found at /opt/oracle.SupportTools

1. # /opt/oracle.SupportTools/quorumdiskmgr --create --config --owner=grid --group=oinstall --network-iface-list="ib0, ib1"

Best Regard,
Paulo Portugal

Thew db_performance_profile parameter - IORM Exadata 12.1.2.1.0 and above

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

CellCLI> ALTER IORMPLAN DBPLAN=(
(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

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