Hi Upendra,
As you have tuning pack license, you could use SQL monitor for the batch job
run and start looking at queries with highest elapsed time to the least.
Note: SQLs more that 5secs elapsed time will show up in SQL monitor, even if
it's still running.
Stalin
Sent from my Mobile
On Nov 19, 2015, at 10:55 AM, Upendra nerilla <nupendra@xxxxxxxxxxx> wrote:
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