From: Rebstock, Roland (Roland.Rebstock@usi.net)
Date: Fri May 14 2004 - 03:02:54 EDT
All, I have a sun e450 with 4 400mhz and 4gb of Ram with 4 GB
of swap on Solaris 8 rev27. For some reason when I logged into the
server to check on why a oracle cold backup was taking so long the
system had 17 processes swapped out via vmstat. Even after stopping the
backup, shutting down oracle and letting the system stand on OS only for
several hours the system still only had 64MB of virtual memory
available. I rebooted the system, and disable the oracle start script
and the system had 6GB of virtual memory available and system was idle.
As soon as I started the cold backup again the system dropped to 3GB
available within 1 hour. I stopped the cold backup which is
approximately 13GB when completed and system never recovers the swap,
the system will continue to run down to 64MB of available via vmstat and
processes will eventually run into the W column of vmstat. Any ideas? I
cant get the cold backup to finish within a reasonable time frame now,
it used to take 5 hours and now it takes 11 hours but the database has
not grown. Here is a vmstat output after 1 hour of shutting down oracle
and a ps -ef only has OS processes running.
procs memory page disk faults cpu
r b w swap free re mf pi po fr de sr f0 s0 s1 s2 in sy cs us sy
id
0 0 0 7069952 3002512 512 751 9 0 0 0 0 0 8 9 0 798 2326 1481 19
5 76
0 0 0 6369536 2191928 0 6 0 0 0 0 0 0 0 0 0 619 56 64 0 0 100
0 0 0 6369536 2191928 0 0 0 0 0 0 0 0 0 0 0 615 72 64 0 0 100
0 0 0 6369536 2191928 171 1184 0 0 0 0 0 0 0 0 0 620 1470 163 1
3 96
0 0 0 6369536 2191928 0 0 0 0 0 0 0 0 0 0 0 612 55 70 0 1 99
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:28:39 EDT