Finding long running queries..
Date: Thu, 19 Nov 2015 13:55:08 -0500
Message-ID: <BLU181-W47C6B64F2BF05226930053D81B0_at_phx.gbl>
Hello everyone -
Environment: Oracle RAC 11.2 on OEL
I am trying to set 10046 trace on a batch process to see which queries needs tuning.. The process runs for over 12 hours. Last time I set a max dump file to 6G which got filled up in a couple of hours. current udump directory has limited storage and I don't want to repoint it to another location for the entire duration. I am trying to see if there are any work around like - writing a specific trace file to another file system? or any other ways to minimize the output?
Or if there are better ways to find long running queries for a specific session, i am open to suggestions. FYI, I do have Tuning/Diag pack licenses on these databases..
Thanks much
-Upendra
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 19 2015 - 19:55:08 CET