首页 » ORACLE » pga_aggregate_target最小多大?ORA-00600 [kspgip1], [101], [647], [1],

pga_aggregate_target最小多大?ORA-00600 [kspgip1], [101], [647], [1],

想测试一下如果pga_aggregate_target 如果设置的过小,会不会影响SESSION 连接数,所以在我把pga_aggregate_target设太小时遭遇了异常,不过有收获知道最小是多少了。

看我的例子

SQL> alter system set pga_aggregate_target=5m scope=spfile;

系统已更改。

SQL> startup force
ORA-00093: pga_aggregate_target 必须介于 10M 和 4096G-1 之间

SQL> alter system set pga_aggregate_target=10m scope=spfile;
alter system set pga_aggregate_target=10m scope=spfile
*
ERROR 位于第 1 行:
ORA-00600: 内部错误代码,参数: [kspgip1], [101], [647], [1], [sql92_security], [], [], []


SQL> select status from v$instance;
select status from v$instance
*
ERROR 位于第 1 行:
ORA-00600: 内部错误代码,参数: [kspgip1], [101], [647], [1], [sql92_security], [], [], []


SQL> shutdown immediate
ORA-00604: 递归 SQL 层 1 出现错误
ORA-00600: 内部错误代码,参数: [kspgsp1], [101], [642], [1], [optimizer_mode], [], [], []
SQL> shutdown abort
ORACLE 例程已经关闭。


SQL> startup nomount
ORA-00093: pga_aggregate_target must be between 10M and 4096G-1
SQL> create pfile from spfile;

文件已创建。

修改pfile中值大于10M,drop spfile


SQL> startup nomount
ORACLE 例程已经启动。

Total System Global Area 1578183308 bytes
Fixed Size                   457356 bytes
Variable Size            1551892480 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes
SQL> create spfile from pfile;

文件已创建。

SQL> startup force;
ORACLE 例程已经启动。

Total System Global Area 1578183308 bytes
Fixed Size                   457356 bytes
Variable Size            1551892480 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes
数据库装载完毕。
数据库已经打开。
SQL> alter system set pga_aggregate_target=10m scope=spfile;

系统已更改。

SQL> startup force
ORACLE 例程已经启动。

Total System Global Area 1578183308 bytes
Fixed Size                   457356 bytes
Variable Size            1551892480 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes
数据库装载完毕。
数据库已经打开。
SQL> select * from v$version where rownum<2;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production

note: pga_aggregate_target must be between 10M and 4096G-1

打赏

目前这篇文章有2条评论(Rss)评论关闭。

  1. Filmy Polskie | #1
    2011-12-30 at 09:27

    Greetings! 🙂

  2. Hal Gloodt | #2
    2011-12-21 at 05:16

    Found your blog after i did a search for wholesale golf shirts at Reddit. I wanted to say thank you for taking time to share this site and letting me post.