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

Home -> Community -> Usenet -> c.d.o.server -> Re: "SYSTEM RUNNING OUT OF PAGING SPACE" (AIX-HACMP-Oracle)

Re: "SYSTEM RUNNING OUT OF PAGING SPACE" (AIX-HACMP-Oracle)

From: chao_ping <chao_ping_at_163.com>
Date: 27 Apr 2002 16:22:14 GMT
Message-ID: <3ccad036$1@usenetgateway.com> 





If Oracle initsid.ora(that is SGA size) does not change, why Oracle will
use more memory? Maybe your SQL execution path has changed because of
the oracle version changes. Try set optimize_mode=rule and restart your
oracle, maybe it works as before. To add more paging space, you do not
need reboot your machine, just use mkps command to add and activate this
new paging space.




--
an oracle fan, 
an oracle beginner

Posted via dBforums
http://dbforums.com


Received on Sat Apr 27 2002 - 11:22:14 CDT












Original text of this message













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