Re: database using more memory than allocated
Date: Wed, 30 Sep 2015 18:13:41 -0700
Message-ID: <CAKsxbLqHGrSxb3szLNeCkLWEZK7FYoAusBnhXwYk81zXjSWQyQ_at_mail.gmail.com>
A couple of other things. In the morning before all this we had the database server hung up, we couldn't get into it to see what was going on. And we have no information to what could have been the problem. Maybe memory but there is no data to support that.
When I look at dba_hist_active_sess_history right before I rebooted the
database I see these wait events.
library cache load lock
db file sequential read
Disk file operations I/O
wait for EMON to spawn
db file parallel read
read by other session
On Wed, Sep 30, 2015 at 6:05 PM, Jeff Chirco <backseatdba_at_gmail.com> wrote:
> We are having some major memory issues with one of our databases today. I
> have the following parameter set.
>
> memory_max_target = 8g
> memory_target=4g
>
> 11.2.0.4 EE database on Windows Server 2008R2
>
> So the database is only supposed to use 4gb but it got up to 84gb before
> it took down the server. We think we found the application that caused but
> not the database reason. We have 300 external sites that push us data
> every minute. We didn't realize for half the day that it wasn't working.
> Around noon apparently it started working and I was able to see that the
> Windows service for that database was allocated 84gb before it killed the
> entire server.
> Once we discovered that this service started working we decided to allow
> each location to upload 1 at a time, then 5, 10, 25, everything was fine
> until we got to 250 locations. Then all of a sudden the memory jump up
> really fast to 40gb before I manually stopped the database and we stopped
> all external loads.
> Why would the database use more memory that has been set to use. I have
> been trying to go through ASH and AWR but it is hard to get a good picture
> because we keep on having to restart the database. Tomorrow morning we are
> going to work on it again.
> I am really lost on this so if anybody can offer any suggestions I would
> appreciate it.
>
> I was going to create a SR but apparently Oracle is having an unplanned
> downtime for their site. Maybe this is a bigger issue that I thought :)
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 01 2015 - 03:13:41 CEST