5 Replies Latest reply on Mar 4, 2013 2:19 AM by Hemant K Chitale

    Direct File Write TEMP (Query Performance)

      Guys I having a performance issue with this query and having this particular wait event in the database Direct File Write TEMP

      select abc.i_g_id ,DECODE(ab.g_type,'Z',0,abc.o_g_id) from nfs_new abm ,nf_new ab where
      (abm.o_g_id=ab.client_group_id and abc.mem_type='D')
      order by 1;

      I gathered stats and did everything possible but the plan remains the same. My PGA is at 1g at the moment. Any idea's