The two databases that I inherented have been generating trace files and log the above error. The OS is Window 2000 SP4. The database version is Since it is a production environment, update to a newer version is next to imposible. The following is excerption from one of the trace file. The DB user issue the sql statement is system. It seems this does not fit into the possible causes from this link:


It seems on the server side. I seems most time it happens right after completing a archive log.  My questions are

1) how could I find out which process or job issue the sql statement?
2) how could I prevent it from happening?

I contacted Oracle support as well, but their suggestion is to upgrade to version  Does this mean there is bug in version Where is the bug doc or fix? If it is a bug, I need to provide to our validation team so that they can approve an upgrade.



---- from alert log -----
Thu Apr 13 02:54:27 2006
ARC0: Evaluating archive   log 8 thread 1 sequence 39636
ARC0: Beginning to archive log 8 thread 1 sequence 39636
Creating archive destination LOG_ARCHIVE_DEST_1: 'K:\ORACLE\ORADATA\D01\VP_ARCH_39636_1.ARC'
ARC0: Completed archiving  log 8 thread 1 sequence 39636
Thu Apr 13 03:44:55 2006
Errors in file f:\oracle\admin\vp\udump\vp_ora_92148.trc
Thu Apr 13 04:19:55 2006
Errors in file f:\oracle\admin\vp\udump\vp_ora_90920.trc
----- from a trace file -----
*** 2006-04-13 04:19:55.000
*** SESSION ID:(36.13376) 2006-04-13 04:19:55.000
*** 2006-04-13 04:19:55.000
ksedmp: internal or fatal error
Current SQL statement for this session:
select /*+ Rule */ sum(f.bytes)/1024, floor(sum(f.bytes)/1024) from sys.dba_free_space f, v$datafile d where f.file_id = d.file# and d.status in ('ONLINE', 'SYSTEM') and tablespace_name =  'SYSTEM' group by tablespace_name
LVL 12
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

May be you have read this, but I post it.

cause: The most common cause for the above error is an ungraceful
disconnection of a session from the oracle db while the db is currently running
a dml statement issued by that session.  The error is recorded when oracle
attempts to reply back to the session with the results of the dml and cannot
access the session.  Overall database operations are usually not affected.

An ungraceful disconnection could cause by but is not limited to any of the
- the client machine crashed
- the network connection crashed
- the user exited the session improperly (not issuing the 'exit' command)
- the user application allows the user to exit the application without properly
terminating the session.

The above can cause problems with corrupted rollback segments if occurring on a
regular basis and is not addressed.  This would require db recovery and
possibly a db rebuild (not a light matter)

PMON will usually rollback most transactions in the rollback segments for a
session if it finds that the session has been ungracefully disconnected, but
there is always a chance that it cannot and this will lead to rollback segment


The dml and the user that issued the dml can be determined from the trace file.
 The current dml is in the tracefile header section. The user can be found in
the process state dump of the trace.  The process state shows the machine,
o/suser, and user for the session.

The DBA can use this information to determine what the user was doing at the
time and if there was an ungraceful exit from the session the user was

The DBA should then address the cause of the ungraceful exit to reduce the
possibility of recurrence.

geotigerAuthor Commented:

Yes, I have read it and it is referenced in the link that I posted. The application connecting to the database is Java application running on WebLogic application server. The Java app creates 10 dedicated connections to Oracle database when it starts, then use the 10 connection as a pool. How would Oracle handle the pool if most of the dedicated connections are idles for long time and then suddenly gets very busy?  
Yes, definetely you have to upgrade ASAP to
I missed this by the first read. (also 10.1.....) are so bugy! has terible errors even in the SQL machine, terible errors.
But in the analytic functions also has bugs....
Curiously the 'set of the bugs' is different in Windows and Unix/Linux versions.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

geotigerAuthor Commented:

After checking Oracle's bug database for version, it seems that our case does not fits with anyof the descriptions in the bug database.

Since most of the trace files are generated by dbsnmp.exe (Oracle agent), I stopped unwanted/unused services on Oracle server including Oracle Apache server, Oracle agent, MTSrecoveryService, Distributed Transaction Coordinator services. It seems that Oracle stopped generating the annoying trace files.

We plan to upgrade Oracle to with new Java application release.  


geotigerAuthor Commented:

This is just an update. I have not seen the error message nor the trace files since I turned off those services.


I insist in that is too bugy
and it is risky to use it.
Even has bugs.

Good luck!
geotigerAuthor Commented:

I agree.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.