Two values for shared pool size

From: Djordje Jankovic <djankovic_at_corp.attcanada.ca>
Date: Mon, 20 Nov 2000 17:17:53 -0500
Message-Id: <10686.122553@fatcity.com>

By error (I did not comment the old entry) I had the following lines in the init.ora file:

...

shared_pool_size = 67108864
# Nov 15, 2000
shared_pool_size = 33554432
...

Now I have two values for shared_pool_size:

SQL> select * from v$parameter where name='shared_pool_size';

      NUM NAME
TYPE

--------- ----------------------------------------------------------------

---

VALUE

---

---

ISDEFAULT ISSES ISSYS_MOD ISMODIFIED ISADJ --------- ----- --------- ---------- ----- DESCRIPTION

---

       36 shared_pool_size
2
67108864, 33554432
FALSE FALSE FALSE FALSE FALSE size in bytes of shared pool

The value that Oracle has taken is the first one:

SYSTEM_at_DVLP> select * from v$sga;

NAME                     VALUE
-------------------- ---------
Fixed Size               47296
Variable Size         72155136
Database Buffers      32768000
Redo Buffers           1064960

Received on Mon Nov 20 2000 - 16:17:53 CST