'alter system' does not alter the memory...

From: Ibrahim DOGAN <idogan_tech_at_yahoo.com>
Date: 23 Dec 2003 07:51:51 -0800
Message-ID: <6bf58828.0312230751.5a116c13@posting.google.com>

version=9.2.0.1

shared pool=112MB
db_cache_size=32MB

and i'm using spfile..

when i try to change the shared_pool ordb_cache_size, sql plus replies "system altered" but the memory figures in v$parameter remains same:

---

SQL> alter system set shared_pool_size=100M System altered.
(but shared_pool is still 112M)

SQL> alter system set db_cache_size=30M
system altered.
(but db_cache_size is still 32 MB)

---

the interesting thing is that when i try to change the shared_pool to 90MB (or any size below 100MB) my session just hangs forever..

any help would be appreciated..

thanks,
i.d. Received on Tue Dec 23 2003 - 09:51:51 CST