Oracle Database Discussions

hey to all as you know i'm newbie in oracle i've been performance relatted problem i tried to load 10 thousand record in database using application it take too long i saw ADDM report. but i could not understand from where i start to do tune all the issue
in SQL tuning it show
Action Investigate the SQL statement with SQL_ID "350myuyx0t1d6" for possible performance improvements. benifit = 77.1

{insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, '...}
Rationale SQL statement with SQL_ID "350myuyx0t1d6" was executed 1 times and had an average elapsed time of 5191 seconds.

secondly it ask to do application anaysis

Action Alternatively, you may set the parameter "cursor_sharing" to "force".
Action Investigate application logic for possible use of bind variables instead of literals.

Rationale At least 6 SQL statements with PLAN_HASH_VALUE 459939225 were found to be using literals. Look in V$SQL for examples of such SQL statements.
Rationale At least 6 SQL statements with PLAN_HASH_VALUE 1006599796 were found to be using literals. Look in V$SQL for examples of such SQL statements.
Rationale At least 6 SQL statements with PLAN_HASH_VALUE 1069201218 were found to be using literals. Look in V$SQL for examples of such SQL statements.
Rationale At least 6 SQL statements with PLAN_HASH_VALUE 1745091200 were found to be using literals. Look in V$SQL for examples of such SQL statements.
Rationale At least 6 SQL statements with PLAN_HASH_VALUE 2656878656 were found to be using literals. Look in V$SQL for examples of such SQL statements.

Host configration

Consider increasing the throughput of the I/O subsystem. Oracle's recommended solution is to stripe all data file using the SAME methodology. You might also need to increase the number of disks for better performance. Alternatively, consider using Oracle's Automatic Storage Management solution.

Rationale During the analysis period, the average data files' I/O throughput was 134 K per second for reads and 66 K per second for writes. The average response time for single block reads was 4.5 milliseconds.
i wanted to just ask from where i start. what should my action to findout solution.