我的share_pool居然是0，为什么？

显示全部楼层 · 2009-1-4 14:52:28

sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Tue May 19 03:13:40 2009
Copyright (c) 1982, 2005, Oracle.All rights reserved.
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area188743680 bytes
Fixed Size
1218436 bytes
Variable Size
75499644 bytes
Database Buffers
109051904 bytes
Redo Buffers
2973696 bytes
Database mounted.
Database opened.
SQL> show parameter sga
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
lock_sga
boolean FALSE
pre_page_sga
boolean FALSE
sga_max_size
big integer 180M
sga_target
big integer 180M
SQL> show parameter share
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address
integer 0
max_shared_servers
integer
shared_memory_address
integer 0
shared_pool_reserved_size
big integer 3355443
shared_pool_size
big integer 0
shared_server_sessions
integer
shared_servers
integer 1

千问 · 2009-1-4 14:52:28

参数没设，自动管理

千问 · 2009-1-4 14:52:28

asmm