Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Pls Help..Huge Memory Usage on Oracle/Solaris

Re: Pls Help..Huge Memory Usage on Oracle/Solaris

From: Irishcelt9 <irishcelt9_at_aol.com>
Date: 14 May 1998 05:52:31 GMT
Message-ID: <1998051405523100.BAA09325@ladder01.news.aol.com>


Sounds like your databases need some tuning quick!! Check out what the memory parameters are set to in the database initialization files. I have seen several systems literally brought to their knees when the values for SGA memory consumption are too high. Also, check the system files for excessive fragmentation and consider scheduling maintenance shutdown/startups (if possible). You may also want to evaluate the number of rollback files alotted to heavy use tablespaces.

Mary
mporter_at_universalsewing.com Received on Thu May 14 1998 - 00:52:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US