5 Replies Latest reply: Mar 3, 2013 8:19 PM by Hemant K Chitale RSS

    Direct File Write TEMP (Query Performance)

    user13322572
      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

      Thanks.