Environment:11.2.0.4
Version Exadata
We are doing database wide tracing and found out that the mount point(/u01) is getting filled very quickly on 1st node and we wanted to change the user_dump_dest parameter to NFS mount point which is shared b/w two nodes.
1st case
started the tracing with below commans
alter system set timed_statistics = true;
alter system set statistics_level=all;
alter system set MAX_DUMP_FILE_SIZE=unlimited;
alter system set events '10046 trace name context forever,level 12'
found out that mount point is getting full ..so changed the user_dump_dest using below command
ALTER SYSTEM SET user_dump_dest='/backup/trace' SCOPE=BOTH SID='*';
Now on server
cd /backup/trace
[oracle@***********:/backup/trace]$ ll
total 0
Even I restarted the tracing and I don't see any trace files got created. Please let me know if this is expected or do i need to change any other parameters?
Thanks for the help