I need to do some profiling inside a stored procedure hooked up to a fast refresh on commit materialized view. Trace is the only way to get the detail I need.
I have all the permissions I need except for access to the filesystem. To access the filesystem and retrieve my tracefile (as it stands now), I need to go through 2 layers of barebones nonproduction managed services. This means waiting for hours to get my tracefile back to me.
- Is there any way to route trace results to anything other than the filesystem?
- Is there any clever way to access the trace directory through the Oracle instance?