Hi!
We've encountered a strange phenomenon since we
changed from Oracle 8.1.7 to
Oracle9i Enterprise Edition Release 9.2.0.2.1 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.2.0 - Production
We use the UTL_FILE package to write log messages
into files on the oracle server (WIN2K).
Putting a single line of text into the logfile consists
of basically
...
UTL_FILE.FOPEN...
UTL_FILE.PUT_LINE... -- always in append mode
-- FFLUSH is a bit paranoid, FCLOSE should do, but it worked before.
-- We tried without FFLUSH, using the new
-- 9.x FOPEN parameter autoflush instead of: same thing...
UTL_FILE.FFLUSH...
UTL_FILE.FCLOSE...
...
Before the release change we could inspect the logfiles
( remotely with win2k clients using a file share )
with any text editor *while* the oracle process was appending lines
to the logfiles without any problem.
Repeatedly opening - closing - reopening the file
- even (re)moving or modifying it - worked perfectly,
as the file was recreated or appended to as soon as the next
log entry occurred.
But now in 9.2, if we open-close-reopen a logfile ( without modifying
the file in the editor ) while it is being appended to,
it will be periodically truncated after having grown up to
approximately 1000 lines (20-100 characters per line on average).
Before the truncation happens, the last line contains dozens
of ASCII 0 characters. ( We were able to catch this peculiarity using
the free PFE-Editor, which can detect that a file has been
changed by another application while you are viewing the file.)
After truncation the former last line with the ASCII NULLS has disappeared.
However, if we don't "touch" the file with an editor - we tried a few
different ones, including Notepad - while it is being written,
truncation does not happen.
This "phenomenon" is rather annoying, we are used to inspect the
logfiles to monitor our oracle jobs' performance/progress/errors,
moreover we use UTL_FILE to create CSV files for exporting data
to other applications. If anybody opens such a file unaware of the fact,
that the file is being currently written to, data loss is very likely...
Please excuse my poor English.
Any ideas or similar experiences
or just another Oracle bug?
Thanks in advance for your thoughts,
Andreas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
