8 Replies Latest reply on Dec 22, 2009 6:50 AM by Deepak_DBA

    Database Crash

    601543
      HI All,

      O/S Version : Linux
      Oracle : 10.2

      Our database crashed and when I looked in the alert logfile, we found this


      Thu Dec 17 00:26:20 2009
      Memory Notification: Library Cache Object loaded into SGA
      Heap size 3081K exceeds notification threshold (2048K)
      Details in trace file /var/opt/app/oracle/product/10.2.0/db_1/dbs/XXPT/udump/xxpt_ora_14960.trc
      KGL object name :NIKUSTG.TLS_SPC_DM_PROJECT_COMMON_DIM
      Thu Dec 17 00:28:13 2009
      Memory Notification: Library Cache Object loaded into SGA
      Heap size 2970K exceeds notification threshold (2048K)
      Details in trace file /var/opt/app/oracle/product/10.2.0/db_1/dbs/XXPT/udump/xxpt_ora_14960.trc
      KGL object name :NIKUSTG.TLS_SPC_DM_PROJECT_COMMON_DIM


      Thanks
        • 1. Re: Database Crash
          sb92075
          Our database crashed
          Post evidence that "database crashed"

          What you posted can be ignored.
          • 2. Re: Database Crash
            Deepak_DBA
            hi,

            i hope you haven't monitor your Alertlog for a while... it might shown the error before it crashed(really it cahed.. it 'll ahow an alert)

            In 10g Release 1 I set this parameter to fix the problem below.

            sql>alter system set "_kgl_large_heap_warning_threshold"=8388608 scope=spfile ;

            Memory Notification: Library Cache Object loaded into SGAHeap size 14278K
            exceeds notification threshold (8192K)

            As you can now see in 10.2.0.3.0 it has exceeded 8192K and is complainingabout
            14278k.

            Oracle has stated ( DocID: 330239.1 ) that the parameter defaults to 50M
            10.2.0.2.0.

            Use an alter statement and set to 50M or delete the parameter from the pfile
            andreset the instance


            regards,
            Deepak

            Edited by: Deepak_DBA on Dec 22, 2009 11:11 AM
            • 3. Re: Database Crash
              Pavan Kumar
              Hi,


              Can you post the results of xxpt_ora_14960.trc, problem exits with

              Heap size 3081K exceeds notification threshold (2048K) - your threshold value.

              - Pavan Kumar N
              Oracle 9i/10g - OCP
              http://oracleinternals.blogspot.com/

              Edited by: Pavan Kumar on Dec 22, 2009 11:11 AM
              • 4. Re: Database Crash
                Deepak_DBA
                hi,


                Just a warning you can ignore it or set "_kgl_large_heap_warning_threshold" to a greater value than the default one (2048K) to prevent from it to happen.
                It is ona of the rare underscode parameters you can set without any issue.
                It was introduced just to warn that a big object was loaded into memory.


                but database crash is highly not possible..


                regards,
                Deepak
                • 5. Re: Database Crash
                  601543
                  Hi,


                  Dump file /var/opt/app/oracle/product/10.2.0/db_1/dbs/XXPT/udump/xxpt_ora_14960.trc
                  Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
                  With the Partitioning, OLAP and Data Mining options
                  ORACLE_HOME = /var/opt/app/oracle/product/10.2.0/db_1
                  System name:     Linux
                  Node name:     nuert123
                  Release:     2.6.16.60-0.21-default
                  Version:     #1 Tue May 6 12:41:02 UTC 2008
                  Machine:     x86_64
                  Instance name: XXPT
                  Redo thread mounted by this instance: 1
                  Oracle process number: 21
                  Unix process pid: 14960, image: oracleXXPt@lxdb0520v

                  *** ACTION NAME:() 2009-12-16 21:29:15.687
                  *** MODULE NAME:(TOAD background query session) 2009-12-16 21:29:15.687
                  *** SERVICE NAME:(EPMDMT) 2009-12-16 21:29:15.687
                  *** SESSION ID:(86.18134) 2009-12-16 21:29:15.687
                  Memory Notification: Library Cache Object loaded into SGA
                  Heap size 3056K exceeds notification threshold (2048K)
                  LIBRARY OBJECT HANDLE: handle=cc7c3078 mutex=0xcc7c31a8(0)
                  name=NIKUSTG.TLS_SPC_DM_PROJECT_COMMON_DIM
                  hash=48dcb522d2c4530e0ba19bbe42cf86ab timestamp=12-16-2009 21:29:14
                  namespace=TABL flags=KGHP/TIM/SML/[02000000]
                  kkkk-dddd-llll=0000-001f-20bf lock=X pin=X latch#=1 hpc=0002 hlc=0002
                  lwt=0xcc7c3120[0xcc7c3120,0xcc7c3120] ltm=0xcc7c3130[0xcc7c3130,0xcc7c3130]
                  pwt=0xcc7c30e8[0xcc7c30e8,0xcc7c30e8] ptm=0xcc7c30f8[0xcc7c30f8,0xcc7c30f8]
                  ref=0xcc7c3150[0xcc7c3150,0xcc7c3150] lnd=0xcc7c3168[0xcc7c3168,0xcc7c3168]
                  LOCK OWNERS:
                  lock user session count mode flags
                  -------- -------- -------- ----- ---- ------------------------
                  db824c20 df3ad848 df3ad848 1 X [00]
                  PIN OWNERS:
                  pin user session lock count mode mask
                  -------- -------- -------- -------- ----- ---- ----
                  db89d8e8 df3ad848 df3ad848 0 1 X 00bf
                  LIBRARY OBJECT: object=da79a888
                  type=PRCD flags=EXS/LOC[0005] pflags=NST[0001] status=VALD load=0
                  DEPENDENCIES: count=19 size=32
                  dependency# table reference handle position flags
                  ----------- -------- --------- -------- -------- -------------------
                  0 da79ac00 da79aaa8 deab3e20 0 DEP[01]
                  1 da79ac00 da79aaf8 d7450548 0 DEP[01]
                  2 da79ac00 da79ab48 de49bb78 59 DEP[01]
                  3 da79ac00 da79ab98 de49b490 59 DEP[01]
                  4 da79ac00 da5e9168 de361208 0 DEP[01]
                  5 da79ac00 da5e91b8 cc3cbab8 7 DEP[01]
                  6 da79ac00 da5e9208 ccd52a68 11 DEP[01]
                  7 da79ac00 da5e9290 d72eac90 77 DEP[01]
                  8 da79ac00 da5e92e0 d7896018 77 DEP[01]
                  9 da79ac00 da5e9330 cc694900 77 DEP[01]
                  10 da79ac00 da5e9380 d74a9290 330 DEP[01]
                  11 da79ac00 da6b6650 d7d4cea0 2328 DEP[01]
                  12 da79ac00 da6b66a0 cc897828 2279 DEP[01]
                  13 da79ac00 da6b66f0 cc13a6c8 2788 DEP[01]
                  14 da79ac00 da6b6740 de833d68 3237 DEP[01]
                  15 da79ac00 da6b6790 ccb1b688 11912 DEP[01]
                  16 da6b69e0 da6b67e0 cc2d38a0 10639 DEP[01]
                  17 da6b69e0 da6b6830 cca64ac8 0 DEP[01]
                  18 da6b69e0 da6b6880 de5cfb20 0 DEP[01]
                  READ ONLY DEPENDENCIES: count=10 size=16
                  dependency# table reference handle flags
                  ----------- -------- --------- -------- -------------------
                  0 d12e8420 d12e82f0 cc64a670 /ROD[20]
                  1 d12e8420 d12e8310 cc252c08 /ROD[20]
                  2 d12e8420 d12e8330 dea8e230 /ROD[20]
                  3 d12e8420 d12e8350 d7e42548 /ROD[20]
                  4 d12e8420 d12e8370 cce53fa0 /ROD[20]
                  5 d12e8420 d12e8390 d7ae8228 /ROD[20]
                  6 d12e8420 d12e83b0 d70e5370 /ROD[20]
                  7 d12e8420 d12e83d0 ccbc9c08 /ROD[20]
                  8 d12e8420 d18d2fa0 dea80a40 /ROD[20]
                  9 d12e8420 d18d2fc0 ccd75ab0 /ROD[20]
                  ACCESSES: count=20 size=32
                  dependency# types
                  ----------- -----
                  1 000c
                  4 0009
                  3 0009
                  0 000c
                  5 0006
                  7 0009
                  6 0003
                  8 0009
                  9 0009
                  10 0009
                  11 0009
                  12 0009
                  13 0009
                  14 0009
                  15 0009
                  16 0009
                  6 0006
                  6 000a
                  5 000a
                  17 000c
                  TRANSLATIONS: count=14 size=16
                  original final
                  -------- --------
                  de49b490 dea93610
                  de361208 de361208
                  cc3cbab8 cc3cbab8
                  ccd52a68 d74195f0
                  d72eac90 d72eac90
                  d7896018 d7896018
                  cc694900 cc694900
                  d74a9290 d74a9290
                  d7d4cea0 d7d4cea0
                  cc897828 cc897828
                  cc13a6c8 cc13a6c8
                  de833d68 de833d68
                  ccb1b688 ccb1b688
                  cc2d38a0 cc2d38a0
                  DATA BLOCKS:
                  data# heap pointer status pins change whr alloc(K) size(K)
                  ----- -------- -------- --------- ---- ------ --- -------- --------
                  0 d7fcc370 da79a9a0 I/P/A/-/- 0 NONE 00 4.20 0.00
                  1 64d8228 2ad7981b43e0 PGA 1 NONE 0.00 0.00
                  2 d155f4f0 c84c1040 I/-/A/-/- 0 NONE 00 3056.36 3074.86
                  4 d12e8248 d06af068 I/-/A/-/- 0 NONE 00 5.38 8.00
                  *** 2009-12-16 21:35:52.274
                  Memory Notification: Library Cache Object loaded into SGA
                  Heap size 3072K exceeds notification threshold (2048K)
                  LIBRARY OBJECT HANDLE: handle=cc7c3078 mutex=0xcc7c31a8(0)
                  name=NIKUSTG.TLS_SPC_DM_PROJECT_COMMON_DIM
                  hash=48dcb522d2c4530e0ba19bbe42cf86ab timestamp=12-16-2009 21:35:51
                  namespace=TABL flags=KGHP/TIM/SML/[02000000]
                  kkkk-dddd-llll=0000-001f-20bf lock=X pin=X latch#=1 hpc=0004 hlc=0004
                  lwt=0xcc7c3120[0xcc7c3120,0xcc7c3120] ltm=0xcc7c3130[0xcc7c3130,0xcc7c3130]
                  pwt=0xcc7c30e8[0xcc7c30e8,0xcc7c30e8] ptm=0xcc7c30f8[0xcc7c30f8,0xcc7c30f8]
                  ref=0xcc7c3150[0xcc7c3150,0xcc7c3150] lnd=0xcc7c3168[0xcc7c3168,0xcc7c3168]
                  LOCK OWNERS:
                  lock user session count mode flags
                  -------- -------- -------- ----- ---- ------------------------
                  dbe807c0 df3ad848 df3ad848 1 X [00]
                  PIN OWNERS:
                  pin user session lock count mode mask
                  -------- -------- -------- -------- ----- ---- ----
                  db9a9180 df3ad848 df3ad848 0 1 X 00bf
                  LIBRARY OBJECT: object=da79a888
                  type=PRCD flags=EXS/LOC[0005] pflags=NST[0001] status=VALD load=0
                  DEPENDENCIES: count=19 size=32
                  dependency# table reference handle position flags
                  ----------- -------- --------- -------- -------- -------------------
                  0 da79ac00 da79aaa8 deab3e20 0 DEP[01]
                  1 da79ac00 da79aaf8 d7450548 0 DEP[01]
                  2 da79ac00 da79ab48 de49bb78 59 DEP[01]
                  3 da79ac00 da79ab98 de49b490 59 DEP[01]
                  4 da79ac00 da5e9168 de361208 0 DEP[01]
                  5 da79ac00 da5e91b8 cc3cbab8 7 DEP[01]
                  6 da79ac00 da5e9208 ccd52a68 11 DEP[01]
                  7 da79ac00 da5e9290 d72eac90 77 DEP[01]
                  8 da79ac00 da5e92e0 d7896018 77 DEP[01]
                  9 da79ac00 da5e9330 cc694900 77 DEP[01]
                  10 da79ac00 da5e9380 d74a9290 330 DEP[01]
                  11 da79ac00 da6b6650 d7d4cea0 2328 DEP[01]
                  12 da79ac00 da6b66a0 cc897828 2279 DEP[01]
                  13 da79ac00 da6b66f0 cc13a6c8 2788 DEP[01]
                  14 da79ac00 da6b6740 de833d68 3237 DEP[01]
                  15 da79ac00 da6b6790 ccb1b688 11912 DEP[01]
                  16 da6b69e0 da6b67e0 cc2d38a0 10639 DEP[01]
                  17 da6b69e0 da6b6830 cca64ac8 0 DEP[01]
                  18 da6b69e0 da6b6880 de5cfb20 0 DEP[01]
                  READ ONLY DEPENDENCIES: count=11 size=16
                  dependency# table reference handle flags
                  ----------- -------- --------- -------- -------------------
                  0 d12e8420 d12e82f0 cc64a670 /ROD[20]
                  1 d12e8420 d12e8310 cc252c08 /ROD[20]
                  2 d12e8420 d12e8330 dea8e230 /ROD[20]
                  3 d12e8420 d12e8350 d7e42548 /ROD[20]
                  4 d12e8420 d12e8370 cce53fa0 /ROD[20]
                  5 d12e8420 d12e8390 d7ae8228 /ROD[20]
                  6 d12e8420 d12e83b0 d70e5370 /ROD[20]
                  7 d12e8420 d12e83d0 ccbc9c08 /ROD[20]
                  8 d12e8420 d18d2fa0 dea80a40 /ROD[20]
                  9 d12e8420 d18d2fc0 ccd75ab0 /ROD[20]
                  10 d12e8420 d18d3010 d78c9ca8 /ROD[20]
                  ACCESSES: count=20 size=32
                  dependency# types
                  ----------- -----
                  1 000c
                  4 0009
                  3 0009
                  0 000c
                  5 0006
                  7 0009
                  6 0003
                  8 0009
                  9 0009
                  10 0009
                  11 0009
                  12 0009
                  13 0009
                  14 0009
                  15 0009
                  16 0009
                  6 0006
                  6 000a
                  5 000a
                  17 000c
                  TRANSLATIONS: count=14 size=16
                  original final
                  -------- --------
                  de49b490 dea93610
                  de361208 de361208
                  cc3cbab8 cc3cbab8
                  ccd52a68 d74195f0
                  d72eac90 d72eac90
                  d7896018 d7896018
                  cc694900 cc694900
                  d74a9290 d74a9290
                  d7d4cea0 d7d4cea0
                  cc897828 cc897828
                  cc13a6c8 cc13a6c8
                  de833d68 de833d68
                  ccb1b688 ccb1b688
                  cc2d38a0 cc2d38a0
                  DATA BLOCKS:
                  data# heap pointer status pins change whr alloc(K) size(K)
                  ----- -------- -------- --------- ---- ------ --- -------- --------
                  0 d7fcc370 da79a9a0 I/P/A/-/- 0 NONE 00 4.20 0.00
                  1 64d8228 2ad797e24398 PGA 1 NONE 0.00 0.00
                  2 d155f4f0 ced00308 I/-/A/-/- 0 NONE 00 3072.81 3089.11
                  4 d12e8248 d21070e0 I/-/A/-/- 0 NONE 00 5.38 8.00
                  *** 2009-12-17 00:26:20.429
                  Memory Notification: Library Cache Object loaded into SGA
                  Heap size 3081K exceeds notification threshold (2048K)
                  LIBRARY OBJECT HANDLE: handle=cc7c3078 mutex=0xcc7c31a8(0)
                  name=NIKUSTG.TLS_SPC_DM_PROJECT_COMMON_DIM
                  hash=48dcb522d2c4530e0ba19bbe42cf86ab timestamp=12-17-2009 00:26:20
                  namespace=TABL flags=KGHP/TIM/SML/[02000000]
                  kkkk-dddd-llll=0000-009f-20bf lock=X pin=X latch#=1 hpc=0008 hlc=0008
                  lwt=0xcc7c3120[0xcc7c3120,0xcc7c3120] ltm=0xcc7c3130[0xdb804a88,0xdb804a88]
                  pwt=0xcc7c30e8[0xcc7c30e8,0xcc7c30e8] ptm=0xcc7c30f8[0xcc7c30f8,0xcc7c30f8]
                  ref=0xcc7c3150[0xcc7c3150,0xcc7c3150] lnd=0xcc7c3168[0xde1c93d8,0xde1995b0]
                  LOCK OWNERS:
                  lock user session count mode flags
                  -------- -------- -------- ----- ---- ------------------------
                  db8652c8 df3ad848 df3ad848 1 X [00]
                  PIN OWNERS:
                  pin user session lock count mode mask
                  -------- -------- -------- -------- ----- ---- ----
                  cd58b578 df3ad848 df3ad848 0 1 X 00bf
                  LIBRARY OBJECT: object=da79a888
                  type=PRCD flags=EXS/LOC[0005] pflags=NST[0001] status=VALD load=0
                  DEPENDENCIES: count=20 size=32
                  dependency# table reference handle position flags
                  ----------- -------- --------- -------- -------- -------------------
                  0 da79ac00 da79aaa8 deab3e20 0 DEP[01]
                  1 da79ac00 da79aaf8 d7450548 0 DEP[01]
                  2 da79ac00 da79ab48 de49bb78 59 DEP[01]
                  3 da79ac00 da79ab98 de49b490 59 DEP[01]
                  4 da79ac00 da5e9168 de361208 0 DEP[01]
                  5 da79ac00 da5e91b8 cc3cbab8 7 DEP[01]
                  6 da79ac00 da5e9208 ccd52a68 11 DEP[01]
                  7 da79ac00 da5e9290 d72eac90 77 DEP[01]
                  8 da79ac00 da5e92e0 d7896018 77 DEP[01]
                  9 da79ac00 da5e9330 cc694900 77 DEP[01]
                  10 da79ac00 da5e9380 d74a9290 330 DEP[01]
                  11 da79ac00 da6b6650 d7d4cea0 2214 DEP[01]
                  12 da79ac00 da6b66a0 cc897828 2165 DEP[01]
                  13 da79ac00 da6b66f0 cc13a6c8 2674 DEP[01]
                  14 da79ac00 da6b6740 de833d68 3123 DEP[01]
                  15 da79ac00 da6b6790 cc869128 11856 DEP[01]
                  16 da6b69e0 da6b67e0 ccb1b688 11798 DEP[01]
                  17 da6b69e0 da6b6830 cc2d38a0 10525 DEP[01]
                  18 da6b69e0 da6b6880 cca64ac8 0 DEP[01]
                  19 da6b69e0 d18d31b0 de5cfb20 0 DEP[01]
                  READ ONLY DEPENDENCIES: count=12 size=16
                  dependency# table reference handle flags
                  ----------- -------- --------- -------- -------------------
                  0 d12e8420 d12e82f0 cc64a670 /ROD[20]
                  1 d12e8420 d12e8310 cc252c08 /ROD[20]
                  2 d12e8420 d12e8330 dea8e230 /ROD[20]
                  3 d12e8420 d12e8350 d7e42548 /ROD[20]
                  4 d12e8420 d12e8370 cce53fa0 /ROD[20]
                  5 d12e8420 d12e8390 d7ae8228 /ROD[20]
                  6 d12e8420 d12e83b0 d70e5370 /ROD[20]
                  7 d12e8420 d12e83d0 ccbc9c08 /ROD[20]
                  8 d12e8420 d18d2fa0 dea80a40 /ROD[20]
                  9 d12e8420 d18d2fc0 ccd75ab0 /ROD[20]
                  10 d12e8420 d18d3010 d78c9ca8 /ROD[20]
                  11 d12e8420 d18d3190 d7f3c1f8 /ROD[20]
                  ACCESSES: count=21 size=32
                  dependency# types
                  ----------- -----
                  1 000c
                  4 0009
                  3 0009
                  0 000c
                  5 0006
                  7 0009
                  6 0003
                  8 0009
                  9 0009
                  10 0009
                  11 0009
                  12 0009
                  13 0009
                  14 0009
                  15 0009
                  16 0009
                  17 0009
                  6 0006
                  6 000a
                  5 000a
                  18 000c
                  TRANSLATIONS: count=15 size=16
                  original final
                  -------- --------
                  de49b490 dea93610
                  de361208 de361208
                  cc3cbab8 cc3cbab8
                  ccd52a68 d74195f0
                  d72eac90 d72eac90
                  d7896018 d7896018
                  cc694900 cc694900
                  d74a9290 d74a9290
                  d7d4cea0 d7d4cea0
                  cc897828 cc897828
                  cc13a6c8 cc13a6c8
                  de833d68 de833d68
                  cc869128 cc869128
                  ccb1b688 ccb1b688
                  cc2d38a0 cc2d38a0
                  PARAMETERS are used
                  DATA BLOCKS:
                  data# heap pointer status pins change whr alloc(K) size(K)
                  ----- -------- -------- --------- ---- ------ --- -------- --------
                  0 d7fcc370 da79a9a0 I/P/A/-/- 0 NONE 00 4.20 0.00
                  1 64cd038 2ad797e24370 PGA 1 NONE 0.00 0.00
                  2 d155f4f0 c838cff8 I/-/A/-/- 0 NONE 00 3081.69 3097.57
                  4 d12e8248 c63465a8 I/-/A/-/- 0 NONE 00 5.39 8.00
                  7 d18d3030 d12d7b28 I/-/A/-/- 0 NONE 00 0.64 1.06
                  *** 2009-12-17 00:28:13.344
                  Memory Notification: Library Cache Object loaded into SGA
                  Heap size 2970K exceeds notification threshold (2048K)
                  LIBRARY OBJECT HANDLE: handle=cc7c3078 mutex=0xcc7c31a8(0)
                  name=NIKUSTG.TLS_SPC_DM_PROJECT_COMMON_DIM
                  hash=48dcb522d2c4530e0ba19bbe42cf86ab timestamp=12-17-2009 00:28:12
                  namespace=TABL flags=KGHP/TIM/SML/[02000000]
                  kkkk-dddd-llll=0000-009f-20bf lock=X pin=X latch#=1 hpc=000a hlc=000a
                  lwt=0xcc7c3120[0xcc7c3120,0xcc7c3120] ltm=0xcc7c3130[0xdb931d68,0xdb931d68]
                  pwt=0xcc7c30e8[0xcc7c30e8,0xcc7c30e8] ptm=0xcc7c30f8[0xcc7c30f8,0xcc7c30f8]
                  ref=0xcc7c3150[0xcc7c3150,0xcc7c3150] lnd=0xcc7c3168[0xde1c93d8,0xde1995b0]
                  LOCK OWNERS:
                  lock user session count mode flags
                  -------- -------- -------- ----- ---- ------------------------
                  dbe887b0 df3ad848 df3ad848 1 X [00]
                  PIN OWNERS:
                  pin user session lock count mode mask
                  -------- -------- -------- -------- ----- ---- ----
                  cd5e2918 df3ad848 df3ad848 0 1 X 00bf
                  LIBRARY OBJECT: object=da79a888
                  type=PRCD flags=EXS/LOC[0005] pflags=NST[0001] status=VALD load=0
                  DEPENDENCIES: count=20 size=32
                  dependency# table reference handle position flags
                  ----------- -------- --------- -------- -------- -------------------
                  0 da79ac00 da79aaa8 deab3e20 0 DEP[01]
                  1 da79ac00 da79aaf8 d7450548 0 DEP[01]
                  2 da79ac00 da79ab48 de49bb78 59 DEP[01]
                  3 da79ac00 da79ab98 de49b490 59 DEP[01]
                  4 da79ac00 da5e9168 de361208 0 DEP[01]
                  5 da79ac00 da5e91b8 cc3cbab8 7 DEP[01]
                  6 da79ac00 da5e9208 ccd52a68 11 DEP[01]
                  7 da79ac00 da5e9290 d72eac90 77 DEP[01]
                  8 da79ac00 da5e92e0 d7896018 77 DEP[01]
                  9 da79ac00 da5e9330 cc694900 77 DEP[01]
                  10 da79ac00 da5e9380 d74a9290 330 DEP[01]
                  11 da79ac00 da6b6650 d7d4cea0 2214 DEP[01]
                  12 da79ac00 da6b66a0 cc897828 2165 DEP[01]
                  13 da79ac00 da6b66f0 cc13a6c8 2674 DEP[01]
                  14 da79ac00 da6b6740 de833d68 3123 DEP[01]
                  15 da79ac00 da6b6790 cc869128 11683 DEP[01]
                  16 da6b69e0 da6b67e0 ccb1b688 11625 DEP[01]
                  17 da6b69e0 da6b6830 cc2d38a0 10352 DEP[01]
                  18 da6b69e0 da6b6880 cca64ac8 0 DEP[01]
                  19 da6b69e0 d18d31b0 de5cfb20 0 DEP[01]
                  READ ONLY DEPENDENCIES: count=13 size=16
                  dependency# table reference handle flags
                  ----------- -------- --------- -------- -------------------
                  0 d12e8420 d12e82f0 cc64a670 /ROD[20]
                  1 d12e8420 d12e8310 cc252c08 /ROD[20]
                  2 d12e8420 d12e8330 dea8e230 /ROD[20]
                  3 d12e8420 d12e8350 d7e42548 /ROD[20]
                  4 d12e8420 d12e8370 cce53fa0 /ROD[20]
                  5 d12e8420 d12e8390 d7ae8228 /ROD[20]
                  6 d12e8420 d12e83b0 d70e5370 /ROD[20]
                  7 d12e8420 d12e83d0 ccbc9c08 /ROD[20]
                  8 d12e8420 d18d2fa0 dea80a40 /ROD[20]
                  9 d12e8420 d18d2fc0 ccd75ab0 /ROD[20]
                  10 d12e8420 d18d3010 d78c9ca8 /ROD[20]
                  11 d12e8420 d18d3190 d7f3c1f8 /ROD[20]
                  12 d12e8420 d18d3230 cc8814f8 /ROD[20]
                  ACCESSES: count=21 size=32
                  dependency# types
                  ----------- -----
                  1 000c
                  4 0009
                  3 0009
                  0 000c
                  5 0006
                  7 0009
                  6 0003
                  8 0009
                  9 0009
                  10 0009
                  11 0009
                  12 0009
                  13 0009
                  14 0009
                  15 0009
                  16 0009
                  17 0009
                  6 0006
                  6 000a
                  5 000a
                  18 000c
                  TRANSLATIONS: count=15 size=16
                  original final
                  -------- --------
                  de49b490 dea93610
                  de361208 de361208
                  cc3cbab8 cc3cbab8
                  ccd52a68 d74195f0
                  d72eac90 d72eac90
                  d7896018 d7896018
                  cc694900 cc694900
                  d74a9290 d74a9290
                  d7d4cea0 d7d4cea0
                  cc897828 cc897828
                  cc13a6c8 cc13a6c8
                  de833d68 de833d68
                  cc869128 cc869128
                  ccb1b688 ccb1b688
                  cc2d38a0 cc2d38a0
                  PARAMETERS are used
                  DATA BLOCKS:
                  data# heap pointer status pins change whr alloc(K) size(K)
                  ----- -------- -------- --------- ---- ------ --- -------- --------
                  0 d7fcc370 da79a9a0 I/P/A/-/- 0 NONE 00 4.20 0.00
                  1 64cd038 2ad797e24418 PGA 1 NONE 0.00 0.00
                  2 d155f4f0 c838cff8 I/-/A/-/- 0 NONE 00 2970.15 2986.53
                  4 d12e8248 c6548730 I/-/A/-/- 0 NONE 00 5.38 8.00
                  7 d18d3030 d12d7b28 I/-/A/-/- 0 NONE 00 0.64 1.06
                  • 6. Re: Database Crash
                    Deepak_DBA
                    hi,

                    kgllarge_heap_warning_threshold=4098
                    add or alter this parameter in yor pfile and start the db with pfile and recreate the spfile.
                    sql>alter system set "_kgl_large_heap_warning_threshold"= 4098 scope=spfile ;


                    regards,
                    Deepak
                    • 7. Re: Database Crash
                      601543
                      Is this the reason for database shutdown.
                      • 8. Re: Database Crash
                        Deepak_DBA
                        hi,

                        that you must analyze..

                        but may be..have you started the DB.. by altering the parameters


                        regards,
                        Deepak