Oracle SGA 设置

首先想到的是经查SGA，shared pool

C:\Documents and Settings\Administrator>sqlplus a/a@pszx_db as sysdba

SQL*Plus: Release 10.1.0.2.0 - Production on 星期五 8月 10 10:44:14 2012

Copyright (c) 1982, 2004, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Release 10.1.0.2.0 - Production

SQL> show sga

Total System Global Area  171966464 bytes
Fixed Size                   787988 bytes
Variable Size             144964076 bytes
Database Buffers           25165824 bytes
Redo Buffers                1048576 bytes
SQL> show parameter sga

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
lock_sga                             boolean     FALSE
pre_page_sga                         boolean     FALSE
sga_max_size                         big integer 164M
sga_target                           big integer 0

我去，这不知道是哪位神人装的数据库

SQL> alter system set sga_max_size=1024m scope=spfile;

System altered.

SQL> startup force;

SQL> alter system set sga_target=1000m scope=both;

System altered.

SQL> show parameter sga

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
lock_sga                             boolean     FALSE
pre_page_sga                         boolean     FALSE
sga_max_size                         big integer 1G
sga_target                           big integer 1000M
SQL> show sga

Total System Global Area 1073741824 bytes
Fixed Size                   792324 bytes
Variable Size             170125564 bytes
Database Buffers          901775360 bytes
Redo Buffers                1048576 bytes

 

 

http://www.orasql.com/blog/archives/2012/08/12/62.htm