I restarted the database and increased the db_block_buffers. There seemed to be a lot of back and forth to disk. This seems to have fixed the problem. Thanks for all your help.