Creating and Scheduling Executions

You can create an execution when you need to either scale up or down your Exadata database CPUs. The executions you create are displayed in the Exadata CPU Scaling page. The Exadata Infrastructure corresponding to your environment can host multiple databases. You can scale up or down the CPU allocation for each database hosted on an Exadata Infrastructure. After creating your execution, you can schedule it to run at a particular date and time.

To create executions:

1. In the dashboard, click the hamburger menu ( three horizontal lines) at the top-left corner.
2. From the navigation pane, click Exadata CPU Scaling.
3. In the Exadata CPU Scaling page, click Create Execution
4. In the Create & Schedule page, select the Environment Name.
   The corresponding values are auto-populated in all other fields.

   During creation of a new execution, the data pertaining to the existing CPUs allocated to the Exadata Infrastructure as well for each of the Databases Hosted are shown on a last collected basis. If you feel the last collection time is obsolete or old, you can trigger a data collection and refresh of the data by clicking the Refresh icon at the top banner. The refresh process takes a few minutes to complete.

5. To scale up or down the OCPU allocation on Exadata infrastructure, click the up or down arrow in the OCPU Allocation field.
   The Databases Hosted section refreshes to display the CPU allocation to database in the selected environment, as well the allocations for all other databases hosted on that Exadata infrastructure.
6. To scale up or down the other databases hosted on the selected environment, double-click the OCPU Allocation field from the Databases Hosted section.
7. Click the up or down arrow in the OCPU Allocation fields, corresponding to the databases you want to modify.
8. Click Create.
   You are now returned to the Exadata CPU Scaling page, where all the executions are listed. Your newly created execution, including executions in the Database Hosted section will be displayed on the top of the list.

   The status of the execution is indicated alongside the execution detail as coloured bars, and textually in the Status column:

   • Green - Completed successfully, or queued based on the scheduled time
   • No color - In Progress, or stopped manually in between the execution run
   • Red - Failed
   • Yellow - Pending assignment of a schedule by the user
9. To search for an execution you created, type the search criteria in the Search field, and press Enter.
10. To view the log of an execution, click the progress Status corresponding to that execution.
    A panel opens showing details of each stages the execution went through.

To edit an existing execution:

1. From the executions listed in the Exadata CPU Scaling page, click the Environment Name.
2. In the Edit & Schedule page, click Refresh at the top-right corner, if required.
3. Modify values in the editable fields, if required.
4. Click Save & Close.
   You are now returned to the Exadata CPU Scaling page, where all the executions are listed.
5. To discard any edits done and return to the Exadata CPU Scaling page, click Cancel at the top-right corner.

To schedule new executions:

Exadata CPU Scaling executions can be scheduled either during creation of the execution itself, or at a later point in time after creation.

1. In the Exadata CPU Scaling page, click Create Execution.
2. In the Create & Schedule page, select the Environment Name, and then click Next.
3. In the Schedule Execution page, click the calendar icon in the Start Time field to set the date and time.
   If any RFC schedule conflicts are there, the summary of conflict is displayed. Also, you cannot save the chosen schedule and proceed with creating execution. The Create button will be disabled. So, you must choose a new date/time where there are no conflicts.
4. To save the schedule and return to the Exadata CPU Scaling page, click Create.
5. To discard any scheduling changes including the values set in the Create Execution screen, and return to the Exadata CPU Scaling page, click Cancel at the top-right corner.

   Note:

   The values you've set in the Create Execution screen is still in draft stage, until the Create button is clicked. So, if you click the Cancel button from the Schedule Execution screen, all the values set in the Create Execution screen will also be deleted. Also, the Create & Schedule Execution process you initiated will be completely canceled.

6. To go back to the Create Execution page, click Back.

To schedule existing executions:

For the existing executions, you can either modify the schedules already set during creation of execution, or create a new schedule if you've not set a schedule at the creation time.

1. From the executions listed in the Exadata CPU Scaling page, click the Environment Name.
2. In the Edit & Schedule page, modify values if required.
3. If you plan to schedule later, click Save & Close to return to the Exadata CPU Scaling page.
4. If you want to proceed with scheduling, click Next.
5. In the Schedule Execution page, click the calendar icon in the Start Time field to set the date and time.
   If any RFC schedule conflicts are there, the summary of conflict is displayed. Also, you cannot save the chosen schedule. The Save & Close button will be disabled. So, you must choose a new date/time where there are no conflicts.
6. To save the schedule and return to the Exadata CPU Scaling page, click Save & Close.
7. To cancel the schedule, click Cancel Schedule.
8. To discard any scheduling changes and return to the Exadata CPU Scaling page, click Cancel at the top-right corner.
9. To go back to the Edit Execution page, click Back.