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