One of our clients is having a problem with Oracle hanging. He is on
XP Professional with Oracle 9i. There are actually 2 places where
it's hanging. One is when he is running SQL scripts. The file with
the scripts gets partially complete when it stops executing just
before a DROP INDEX command.
The other case is when he tried to create a new database using the
Configuration Assistant. After he clicks Create Database, it begins
creating the database but stops when it's 88% completed and just
In both cases, we've checked the alert.log and various trace files
and can find no error messages.
Has anyone here seen this before? Can anyone here give some insight to this situation?
I found an answer on oracle.com where someone stated that, on any sql command, the database will hang if the redo log files are full. There will be no error message. So my question to you now is:
what command can I use to query how full the redo logs are?
I passed on the info to the collegue who is working on this case. I was looking at the directions for the trace on the web page that you sent me and I see where the user is to query the xyz_master and xyz_detail tables, but I did not see where these were created. Are these created by a user or are they created by Oracle?