Oracle Request Set Run Time Log File Posting
Hi Everyone,
I am currently using the put_line to write information to the log file in Oracle. I don't get to see what is in the log file until the job finishes running. I would like to write to the log file and have the information available while the job is progressing (running) at any point in time. The reason I would like to see this is because I can then write out the number of rows processed so far. After a while, I will have a baseline on how efficient the job runs. Is there a way to get this to work? Thanks in advance for your help.
Software/Hardware used:
Software/Hardware used:
ASKED:
March 5, 2009 3:25 PM
UPDATED:
March 5, 2009 8:29 PM
Answer Wiki:
You are using PUT_LINE, from what package ? UTL_FILE ?
If so, you could use the procedure FFLUSH.
FFLUSH physically writes pending data to the file when called.
Depending on how often you are writing to the file, you could also open and close the file each time you need to write to it. When the file is closed, all pending data is written to disk.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
