show parameter memory; show parameter sga; show parameter pga; 这些结果贴出来
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 8月 10 15:49:30 2013Copyright (c) 1982, 2005, Oracle. All rights reserved. 连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining optionsSQL> show parameter memoryNAME TYPE VALUE ------------------------------------ ----------- ------------------------------ hi_shared_memory_address integer 0 shared_memory_address integer 0 SQL> show parameter sgaNAME TYPE VALUE ------------------------------------ ----------- ------------------------------ lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 19632M sga_target big integer 19632M SQL> show parameter pgaNAME TYPE VALUE ------------------------------------ ----------- ------------------------------ pga_aggregate_target big integer 6542M SQL>
show parameter sga;
show parameter pga;
这些结果贴出来
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 8月 10 15:49:30 2013Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining optionsSQL> show parameter memoryNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
shared_memory_address integer 0
SQL> show parameter sgaNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 19632M
sga_target big integer 19632M
SQL> show parameter pgaNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target big integer 6542M
SQL>