CREATE DATABASE creates "memory leak"

CREATE DATABASE creates "memory leak"

Post by Michael J. Moor » Tue, 01 Oct 2002 09:07:25



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
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

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

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

*** SESSION ID:(9.5) 2002-09-18 23:08:18.000

******** ERROR: PGA memory leak detected 34580 > 23036 ********

******************************************************

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

 
 
 

CREATE DATABASE creates "memory leak"

Post by Michael J. Moor » Tue, 01 Oct 2002 10:31:02


Never mind.

 
 
 

1. The+instruction+at+"0x1f90db9b"+referenced+memory+at+"0x7fa03794"+The+memory+cou

hi,

iam using ado for inserting deleting and modifying the
database records.

iam using only one recordset.

while using the delete statement the below error message
populates and the application is closed down.

vb6.exe - Application Error
The instruction at "0x1f90db9b" referenced memory
at "0x7fa03794". The memory cannot be "written"

i had tried my level best to identify where the probelm is.

but iam not able to do it.

could any body provide me the solution.

regards
varma..

2. MSSQL2000 + Win XP Pro

3. Creating a new "database"

4. Horizontal Portals

5. create "microsoft.public.vc.database.rdo"

6. feature & performance comparison

7. "create database" problem on linux 7.2

8. DBCC Commands???

9. Restricting "Create Database"

10. "Leaking Paradox Database"

11. How to slove the "os_find_good_keyfile"&"could not create shared memory" ---Please help