need SQL tuning tips for these SQL

Hi:  we captured some SQLs: with a comparison from last time's STATSPACK - there is a 30-40% drop for 'execute-to-parse' ratio this year, and these SQLs are ale listed in 'SQL ordered by Parse' in STATSPACK rpt this year.  many of them are 'select' statement.  I pasted only 'insert/update' SQLs here.  May I ask if any tips for tunning them?

because many of them are just simple query.  For example: one suggest replace 'sysdate' with a day or a constant, to reduce number of parses.  Is it right?  what else method we can use?

insert into MQ_MSG (mm_mbr_code, mm_group, mm_upd_dt_stamp, mm_s