table locks up

[bookouri]

I have a table in an 8.1.7 database that if I do several selects or updates on the table, things work ok to begin with but after five or six selects or updates the table "locks up." The database is still on line, I can still log on to the database but if I try to do even a select from the "locked up" table (using toad or sql plus for example) sqlplus "locks up." Is there anywhere I can look to troubleshoot the table. The table is a simple dozen columns with about a thousand test records in it. Im sure oracle has a log somewhere that reports errors.

thanks

 

[JamesGordon]

Have to enabled archive logging?
I had a problem where archive loggin was on but the init.ora parameter log_archive_start=true wasn't set, so after a number of inserts, updates and deletes the DB would hang.
The log is normally $ORACLE_HOME\admin\$ORACLE_SID\pfile\init$ORACLE_SID.ora.

 

[bookouri]

thanks, Ill check that, I believe that that I did do that. Would be great if its that easy..