Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> CREATE DATABASE creates "memory leak"
Has anybody encountered a similar problem? I am using WinXP and have one
instance sucessfully running. Now I am trying to manually create a second
instance.
Thanks, Mike
SQL> CREATE DATABASE test
2 MAXINSTANCES 1
3 MAXLOGFILES 5
4 MAXDATAFILES 100
5 DATAFILE 'oracle\oradata\test\system01.dbf' SIZE 325M REUSE
6 AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
7 UNDO TABLESPACE "UNDOTBS" DATAFILE 'oracle\oradata\test\undotbs01.dbf'
8 SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
9 CHARACTER SET WE8MSWIN1252
10 logfile 'D:\oracle\oradata\test\redo01.log' size 100M reuse, 11 'D:\oracle\oradata\test\redo02.log' size 100M reuse, 12 'D:\oracle\oradata\test\redo03.log' size 100M reuse;CREATE DATABASE test
Dump file d:\oracle\admin\test\bdump\test_ora_3252.trc
Wed Sep 18 23:08:18 2002
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.1 Service Pack 1, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.1 Service Pack 1, CPU type 586
Instance name: test
Redo thread mounted by this instance: 0 <none>
Oracle process number: 0
3252
HEAP DUMP heap name="pga heap" desc=00209F18
extent sz=0x213c alt=84 het=32767 rec=0 flg=3 opc=3
parent=00000000 owner=00000000 nex=00000000 xsz=0x8214
EXTENT 0 addr=02EE23E4 Received on Sun Sep 29 2002 - 19:07:25 CDT