Performance in Production v.s. Testing

[LND]

1. SQL tuning again(it well may be that SQL plans are different in test db from prod db or in test db some SQL tuning bugs still exists):
a) v$sqlarea view
1) to get TOP execute count sql, 2) to get TOP buffer_gets/execut_count SQL, etc
b) Use SQL trace and TKPROF

2. shared pool tuning
3. db_buffers tuning