1. ORACLE的内存 = SGA + PGASGA is almost fixed value : (connect server manger type the command : Show SGA )PGA is increasing according the number of sessions and session activity ( application issued from client) . Check your sort_area_size which will consume the most of PGA memory . This value should not be bigger than 1M/2M
主要参数都在init.ora文件中,贴出来,应当oracle再大,也不会超过这个内存大小的.
才关一次计算机呢?
以前的杀毒软件常常有这个毛病。
而对于Oracle来说,内存和碎片都不是什么大的问题,可以进行有效的自动的监控处理