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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: determine total memory used by Oracle via OS tools

RE: determine total memory used by Oracle via OS tools

From: Alvaro Jose Fernandez <alvaro.fernandez_at_sivsa.com>
Date: Wed, 15 Aug 2007 16:25:04 +0200
Message-ID: <607D6181D9919041BE792D70EF2AEC481CFF99@LIMENS.sivsa.int> 





Also (aside note), there are one bug in 10.2.0.3 related to hash joins
using excess memory (above pga_aggregate_target).

 



I recommend getting a "snap" at peak time with the SQLAREAT tools from
Carlos Sierra of Oracle (Note 238684.1) . This tool is great to detect
improper PGA memory usage/bad plans.



Also a statspack snap would reveal if there's something wrong (multipass
execs from the PGA report).

 



regards, 

 



--
http://www.freelists.org/webpage/oracle-l


Received on Wed Aug 15 2007 - 09:25:04 CDT












Original text of this message













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