Re: Too many open files?

Do you COMPACT the tables?  Another possibility is that files (and file 
descriptors) are created when a live backup of the database is made.  If 
you perform nightly backups then a bug may be causing the file 
descriptor pool to become exhausted.  One solution would be to shutdown 
and restart the database after a backup.  Does it happen after a number 
of days of uptime?

Toby.


M. A. Sridhar wrote:

> Actually, the application does not perform any create/drop/alter operations.
> The schema itself is completely static  when the application is running.
> 
> So I am still rather puzzled.
> 
> Sridhar




---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]