How to tune sql spending 100% of db time on CPU

ADDM recommendation:

Recommendation 1: SQL Tuning

   Estimated benefit is 4.72 active sessions, 44.39% of total activity.

   --------------------------------------------------------------------

   Action

      Run SQL Tuning Advisor on the SELECT statement with SQL_ID

      "30ts060nuw8wy".

      Related Object

         SQL statement with SQL_ID 30ts060nuw8wy.

     

   Rationale

      The SQL spent 100% of its database time on CPU, I/O and Cluster waits.

      This part of database time may be improved by the SQL Tuning Advisor.

   Rationale

      Database time for this SQL was divided as follows: 100% for SQL

      execution, 0% for parsing, 0% for PL/SQL execution and 0% for Java

      execution.

   Rationale

      SQL statement with SQL_ID "30ts060nuw8wy" was executed 216 times and had