Re: Performance issue
Date: Tue, 17 Mar 2009 14:05:44 +0000 (UTC)
Message-ID: <gpoano$68e$2_at_solani.org>
On Tue, 17 Mar 2009 00:27:05 -0700, Jenny wrote:
> our database oracle 9i is running on tru64. Db's performance degrades as
> the time goes on, later we bounce the DB and also restarts the machine.
> after restart the performance increases drastically and as time goes
> performance degrade.
> Can anyone tell what the problem is and also a solution 4 it
My experience tells me that it's probably a swapping issue. Try seeing what can you do about the FILESYSTEMIO_OPTIONS. The default for the parameter is "none", which means that your DB is using buffered I/O. On the vast majority of Unix systems, all of the free memory is used as I/O cache. If the main user of I/O is an Oracle database, this cache area can grow quite a bit. Consider using direct I/O, if that is supported on your file system and I/O.
-- http://mgogala.freehostia.comReceived on Tue Mar 17 2009 - 09:05:44 CDT