Check to see if the SORT_AREA_SIZE
has been increased recently [either in the init.ora
or in a login.sql or application program with the
ALTER SESSION SET ..].
Hemant
"RR" <rickraster_at_hotmail.com> wrote in message
news:97b4acf3.0206200642.69832659_at_posting.google.com...
> Hi all. Bit stumped here (hopefully just a simple problem):
>
> os Redhat 7.2
> v. 8.1.7
> 500+M swap
> 312 ram
>
> it's a small production server (4 gigs), has run fine for the last 8
> months. Recently we have had an increase in the volume of data.
>
> Over the weekend, the server hung due to lack of memory, taken up by
> Oracle processes (as shown by ps aux). free -t over a period of time
> shows that the memory and swap is steadily getting eaten up. I
> rebooted the database yesterday at 5pm, and by 7am this morning, the
> mem was done and it was hung again.
>
> Has anyone come across this problem before, or have any suggestions on
> where I should be looking for possible problem areas?
>
> TIA
>
> Rick
Received on Thu Jun 20 2002 - 09:52:48 CDT
