I basically have two issues, i have been contacted by the server maintanence staff and asked why we take up so much harddisk space.
The first issue is that it dumps a huge amounts of ord562048pas files they each only take up a few kilobytes but there are two servers in a balance load setup and they both have about 700.000 files, first of all why are these files there and secondly would it be possible not to create these files.
The second issues i have is that we have alot of mimp_ora_xxx.trc files, some of these reach size of 150mb and are generated every 5-10 minutes. looking at the contest it looks like somebody looking at the files, but is there any ways to reduce these files or avoid them in total. the contents looks like the following:
Dump file /mimp_perm/u_dumplog/mimp_ora_1133.trc
Oracle9i Enterprise Edition Release 188.8.131.52.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 184.108.40.206.0 - Production
ORACLE_HOME = /me01p/oracle/product/220.127.116.11
System name: SunOS
Node name: dkd1mr0002
Instance name: mimp
Redo thread mounted by this instance: 1
Oracle process number: 1155
Unix process pid: 1133, image: oracle@dkd1mr0002 (TNS V1-V3)
I don't have an answer for your first issue, I don't understand the question.
As for the second issue, the trace files with the "getPos" messages, this is a bug. The code is unconditionally printing these messages to the System.out stream.
The work arounds to this, that I can think of, are as follows (in no particular order)
1. upgrade to 10.2. The bug is not present in 10.2.0.3 and higher which is your minimum upgrade path
2. write a cron job to periodically detect and delete the trace files.
3. if you have an extended support contract (since this is 9.2) contact Oracle support and we will produce a patch
If none of the above are possible, please reply and we will see if other coding possibilities exist.
Thanks for your speedy reply and sorry for my own slow return.
I dident quite like the answer:), but at least i have something to give to the server guys.
About the other issues we have a clustered application server, and it seems it dumps alot of files byt the name of "ordXXXXpas" files on each server, they all are a few KB of size but there was found about 700.000 files on each server. The files are placers in %APPSERVER_HOME%\j2ee\home\ordpas, they appear to be sort of temporary files but for what purpose and why there is so many we have no idea.