The team wants my scripts to spool to one log file so it is easier to verify. I found the following from Oracle Forum.
For UNIX or Linux.
spool temp.txt
your_sql;
spool off
host cat temp.txt >> your_file.txt
host rm temp.txt
For Windows.
spool temp.txt
your_sql;
spool off
host type temp.txt >> your_file.txt
host del temp.txt
Subscribe to:
Post Comments (Atom)
My own Mind Map program in Java script and Python
I had been searching online mindmap apps for my study for a while and never got one that I am really happy with. Then I asked myself what I...
-
During performance tuning or being called to debug a performance issues of the database system, we always would like to know the current I/O...
-
There is a bug in 11.2.0.2 and 11.2.0.3 that causes worse plan. need to add hint /*+OPT_PARAM('_optimizer_use_feedback','false...
-
This script shows you information about your memory configurations, current usage, adviser views, etc. Before jumping into any conclusions, ...
No comments:
Post a Comment