I am having issues with updating or deleting target table rows when I do an update or delete on the source table. The Replicat abends every time that I do an update or insert on the Source Table. I am attaching the Extract and Replicate Param files, and the error files. Please help me resolve this.
Extract:
Replicat:
- Reploc.dsc file:
Oracle GoldenGate Delivery for Oracle process started, group REPLLOC discard file opened: 2017-02-21 02:26:57.121000
Skipping delete from OGGUSER.LOCATIONSX at seqno 4 rba 2838
*
LOCATION_ID = 9699
000000: 39 36 39 39 |9699 |
STREET_ADDRESS = NULL
POSTAL_CODE = 75009
000000: 37 35 30 30 39 |75009 |
CITY = Harry
000000: 48 61 72 72 79 |Harry |
STATE_PROVINCE = NULL
COUNTRY_ID = US
000000: 55 53 |US |
DIVISION = Hollywood
000000: 48 6f 6c 6c 79 77 6f 6f 64 |Hollywood |
*
Current time: 2017-02-21 02:31:06
Discarded record from action ABEND on error 1
OCI Error ORA-00001: unique constraint (HR.LOCATIONSX_PK) violated (status = 1), SQL <INSERT INTO "HR"."LOCATIONSX" ("POSTAL_CODE","CITY","COUNTRY_ID","PREV_STATE_PROVINCE","DIVISION","LOCATION_ID","STREET_ADDRESS","NOTES","CURRENT_DATE","SOURCE_TABLE_NAME","COMMIT_SCN","COMMIT_SCN_SEQ","SRC_TABLE_NAME","OPERATION","RECORD_ROWWID","BEFORE_AFTER") VALUES (:a2,:a3,:a4,:a5,:a12,:a16,:a17,:a18,:a19,:a20,:a21,:a22,:a23,:a24,:a25,:a26)>
Aborting transaction on c:\Oracle\app\product\12.2.0\dbhome_1\dirdat\b2 beginning at seqno 6 rba 2598
error at seqno 6 rba 2598
Problem replicating OGGUSER.LOCATIONSX to HR.LOCATIONSX
Mapping problem with unified update record (target format)...
*
LOCATION_ID = 1818
000000: 31 38 31 38 |1818 |
STREET_ADDRESS = NULL
POSTAL_CODE = 75991
000000: 37 35 39 39 31 |75991 |
CITY = New Bern
000000: 4e 65 77 20 42 65 72 6e |New Bern |
COUNTRY_ID = US
000000: 55 53 |US |
PREV_STATE_PROVINCE = NC
000000: 4e 43 |NC |
NOTES = TEST OF ADDING NOTES
000000: 54 45 53 54 20 4f 46 20 41 44 44 49 4e 47 20 4e |TEST OF ADDING N|
000010: 4f 54 45 53 |OTES |
CURRENT_DATE = 2017-02-21 02:31:06
000000: 32 30 31 37 2d 30 32 2d 32 31 20 30 32 3a 33 31 |2017-02-21 02:31|
000010: 3a 30 36 |:06 |
SOURCE_TABLE_NAME = OGGUSER.LOCATIONSX
000000: 4f 47 47 55 53 45 52 2e 4c 4f 43 41 54 49 4f 4e |OGGUSER.LOCATION|
000010: 53 58 |SX |
COMMIT_SCN = 4080161
000000: 34 30 38 30 31 36 31 |4080161 |
COMMIT_SCN_SEQ = 4080161
000000: 34 30 38 30 31 36 31 |4080161 |
SRC_TABLE_NAME = OGGUSER.LOCATIONSX
000000: 4f 47 47 55 53 45 52 2e 4c 4f 43 41 54 49 4f 4e |OGGUSER.LOCATION|
000010: 53 58 |SX |
DIVISION = Bern
000000: 42 65 72 6e |Bern |
OPERATION = SQL COMPUPDATE
000000: 53 51 4c 20 43 4f 4d 50 55 50 44 41 54 45 |SQL COMPUPDATE |
RECORD_ROWWID = AAAXD6AAGAAAALbAAD
000000: 41 41 41 58 44 36 41 41 47 41 41 41 41 4c 62 41 |AAAXD6AAGAAAALbA|
000010: 41 44 |AD |
BEFORE_AFTER = AFTER
000000: 41 46 54 45 52 |AFTER |
LOCATION_ID = 1818
000000: 31 38 31 38 |1818 |
STREET_ADDRESS = 2222 Grant Ave
000000: 32 32 32 32 20 47 72 61 6e 74 20 41 76 65 |2222 Grant Ave |
NOTES = TEST OF ADDING NOTES
000000: 54 45 53 54 20 4f 46 20 41 44 44 49 4e 47 20 4e |TEST OF ADDING N|
000010: 4f 54 45 53 |OTES |
CURRENT_DATE = 2017-02-21 02:31:06
000000: 32 30 31 37 2d 30 32 2d 32 31 20 30 32 3a 33 31 |2017-02-21 02:31|
000010: 3a 30 36 |:06 |
SOURCE_TABLE_NAME = OGGUSER.LOCATIONSX
000000: 4f 47 47 55 53 45 52 2e 4c 4f 43 41 54 49 4f 4e |OGGUSER.LOCATION|
000010: 53 58 |SX |
COMMIT_SCN = 4080161
000000: 34 30 38 30 31 36 31 |4080161 |
COMMIT_SCN_SEQ = 4080161
000000: 34 30 38 30 31 36 31 |4080161 |
SRC_TABLE_NAME = OGGUSER.LOCATIONSX
000000: 4f 47 47 55 53 45 52 2e 4c 4f 43 41 54 49 4f 4e |OGGUSER.LOCATION|
000010: 53 58 |SX |
OPERATION = SQL COMPUPDATE
000000: 53 51 4c 20 43 4f 4d 50 55 50 44 41 54 45 |SQL COMPUPDATE |
RECORD_ROWWID = AAAXD6AAGAAAALbAAD
000000: 41 41 41 58 44 36 41 41 47 41 41 41 41 4c 62 41 |AAAXD6AAGAAAALbA|
000010: 41 44 |AD |
BEFORE_AFTER = AFTER
000000: 41 46 54 45 52 |AFTER |
*
Process Abending : 2017-02-21 02:31:11
- REPLLOC.rpt file:
***********************************************************************
Oracle GoldenGate Delivery for Oracle
Version 12.2.0.1.1 OGGCORE\_12.2.0.1.0\_PLATFORMS\_151211.1401
Windows x64 (optimized), Oracle 12c on Dec 18 2015 21:13:33
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
Starting at 2017-02-21 02:26:57
***********************************************************************
Operating System Version:
Microsoft Windows Server 2008 R2 , on x64
Version 6.1 (Build 7601: Service Pack 1)
Process id: 5036
Description:
2017-02-21 02:26:57 WARNING OGG-02904 Replication of PARTIAL XML containing NCHAR/NVARCHAR/NCLOB data may cause divergence.
***********************************************************************
** Running with the following parameters **
***********************************************************************
2017-02-21 02:26:57 INFO OGG-03059 Operating system character set identified as windows-1252.
2017-02-21 02:26:57 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
2017-02-21 02:26:57 INFO OGG-02095 Successfully set environment variable ORACLE_SID=orclgg.
2017-02-21 02:26:57 INFO OGG-03528 The source database character set, as determined from the table definition file, is we8mswin1252.
REPLICAT REPLLOC
SETENV (ORACLE_SID='orclgg')
2017-02-21 02:26:57 INFO OGG-02095 Successfully set environment variable ORACLE_SID=orclgg.
USERID OGGUSERT, PASSWORD ***
2017-02-21 02:26:57 WARNING OGG-02551 ORACLE_HOME is not set to Oracle software directory.
DISCARDFILE c:\Oracle\app\product\12.2.0\dbhome_1\dirrpt\reploc.dsc, PURGE
SOURCEDEFS c:\Oracle\app\product\12.2.0\dbhome_1\dirdef\locatem.def
ALLOWDUPTARGETMAP
MAP OGGUSER.LOCATIONSX, TARGET HR.LOCATIONSX, KEYCOLS (LOCATION_ID), INSERTALLRECORDS,
COLMAP (USEDEFAULTS, PREV_STATE_PROVINCE = STATE_PROVINCE, NOTES = 'TEST OF ADDING NOTES', CURRENT_DATE = @DATENOW(), SOURCE_TABLE_NAME = @GETENV('GGHEADER','TABLENAME'), COMMIT_SCN = @GETENV('TRANSACTION','CSN'), COMMIT_SCN_SEQ = @GETENV('TRANSACTION','CSN'), SRC_TABLE_NAME = @TOKEN('TK_TABLE'), OPERATION = @GETENV('GGHEADER','OPTYPE'), RECORD_ROWWID = @GETENV('RECORD','ROWID'), BEFORE_AFTER = @GETENV('GGHEADER','BEFOREAFTERINDICATOR'));
2017-02-21 02:26:57 INFO OGG-06451 Triggers will be suppressed by default.
2017-02-21 02:26:57 INFO OGG-01971 The previous message, 'INFO OGG-06451', repeated 1 times.
2017-02-21 02:26:57 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: MapViewOfFile anon free: UnmapViewOfFile
file alloc: MapViewOfFile file free: UnmapViewOfFile
target directories:
c:\Oracle\app\product\12.2.0\dbhome_1\dirtmp.
CACHEMGR virtual memory values (may have been adjusted)
CACHESIZE: 2G
CACHEPAGEOUTSIZE (default): 4M
PROCESS VM AVAIL FROM OS (min): 4G
CACHESIZEMAX (strict force to disk): 3.41G
Database Version:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE 12.1.0.2.0 Production
TNS for 64-bit Windows: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production
Database Language and Character Set:
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "WE8MSWIN1252"
2017-02-21 02:26:57 WARNING OGG-05673 CSN-based duplicate suppression is disabled because there is no checkpoint table for this Replicat.
2017-02-21 02:26:57 INFO OGG-02545 Parameter GROUPTRANSOPS is ignored by Integrated Replicat when parallelism is greater than 1.
2017-02-21 02:26:57 INFO OGG-02527 Integrated Replicat does not populate a trace table.
2017-02-21 02:26:58 INFO OGG-02530 Integrated replicat successfully attached to inbound server OGG$REPLLOC.
***********************************************************************
** Run Time Messages **
***********************************************************************
2017-02-21 02:26:58 WARNING OGG-02544 Unhandled error (ORA-26799: unique constraint HR.LOCATIONSX_PK violated for table HR.LOCATIONSX with column values ("LOCATION_ID") = (9699)
ORA-00001: unique constraint (HR.LOCATIONSX_PK) violated
ORA-00001: unique constraint (HR.LOCATIONSX_PK) violated) while processing the record at SEQNO 4, RBA 2838 in Integrated mode. REPLICAT will retry in Direct mode.
2017-02-21 02:26:58 WARNING OGG-02761 Source definitions file, c:\Oracle\app\product\12.2.0\dbhome_1\dirdef\locatem.def, is ignored because trail file c:\Oracle\app\product\12.2.0\dbhome_1\dirdat\b2000000004 contains table definitions.
2017-02-21 02:26:58 INFO OGG-03506 The source database character set, as determined from the trail file, is we8mswin1252.
2017-02-21 02:26:58 INFO OGG-01370 User requested START SKIPTRANSACTION. The current transaction will be skipped. Transaction ID 4.28.2588, position Seqno 4, RBA 2838.
2017-02-21 02:26:58 INFO OGG-06505 MAP resolved (entry OGGUSER.LOCATIONSX): MAP "OGGUSER"."LOCATIONSX", TARGET HR.LOCATIONSX, KEYCOLS (LOCATION_ID), INSERTALLRECORDS, COLMAP (USEDEFAULTS, PREV_STATE_PROVINCE = STATE_PROVINCE, NOTES = 'TEST OF ADDING NOTES', CURRENT_DATE = @DATENOW(), SOURCE_TABLE_NAME = @GETENV('GGHEADER','TABLENAME'), COMMIT_SCN = @GETENV('TRANSACTION','CSN'), COMMIT_SCN_SEQ = @GETENV('TRANSACTION','CSN'), SRC_TABLE_NAME = @TOKEN('TK_TABLE'), OPERATION = @GETENV('GGHEADER','OPTYPE'), RECORD_ROWWID = @GETENV('RECORD','ROWID'), BEFORE_AFTER = @GETENV('GGHEADER','BEFOREAFTERINDICATOR')).
2017-02-21 02:26:58 INFO OGG-02756 The definition for table OGGUSER.LOCATIONSX is obtained from the trail file.
Using the following default columns with matching names:
LOCATION_ID=LOCATION_ID, STREET_ADDRESS=STREET_ADDRESS, POSTAL_CODE=POSTAL_CODE, CITY=CITY, COUNTRY_ID=COUNTRY_ID, DIVISION=DIVISION
2017-02-21 02:26:58 INFO OGG-06510 Using the following key columns for target table HR.LOCATIONSX: LOCATION_ID.
2017-02-21 02:26:58 INFO OGG-02232 Switching to next trail file c:\Oracle\app\product\12.2.0\dbhome_1\dirdat\b2000000001 at 2017-02-21 02:26:58.993000 due to EOF. with current RBA 3,293.
Processed extract process graceful restart record at seq 1, rba 872.
2017-02-21 02:26:58 INFO OGG-02232 Switching to next trail file c:\Oracle\app\product\12.2.0\dbhome_1\dirdat\b2000000002 at 2017-02-21 02:26:58.993000 due to EOF. with current RBA 933.
2017-02-21 02:26:58 INFO OGG-03522 Setting session time zone to source database time zone 'GMT'.
Processed extract process graceful restart record at seq 2, rba 1521.
2017-02-21 02:26:58 INFO OGG-02232 Switching to next trail file c:\Oracle\app\product\12.2.0\dbhome_1\dirdat\b2000000003 at 2017-02-21 02:26:58.993000 due to EOF. with current RBA 4,615.
Processed extract process graceful restart record at seq 3, rba 872.
2017-02-21 02:26:58 INFO OGG-02232 Switching to next trail file c:\Oracle\app\product\12.2.0\dbhome_1\dirdat\b2000000004 at 2017-02-21 02:26:58.993000 due to EOF. with current RBA 933.
Processed extract process graceful restart record at seq 4, rba 1521.
2017-02-21 02:26:59 INFO OGG-02232 Switching to next trail file c:\Oracle\app\product\12.2.0\dbhome_1\dirdat\b2000000005 at 2017-02-21 02:26:59.009000 due to EOF. with current RBA 3,061.
Processed extract process graceful restart record at seq 5, rba 872.
2017-02-21 02:26:59 INFO OGG-02232 Switching to next trail file c:\Oracle\app\product\12.2.0\dbhome_1\dirdat\b2000000006 at 2017-02-21 02:26:59.009000 due to EOF. with current RBA 933.
Processed extract process graceful restart record at seq 6, rba 1521.
2017-02-21 02:28:25 INFO OGG-06505 MAP resolved (entry OGGUSER.LOCATIONSX): MAP "OGGUSER"."LOCATIONSX", TARGET HR.LOCATIONSX, KEYCOLS (LOCATION_ID), INSERTALLRECORDS, COLMAP (USEDEFAULTS, PREV_STATE_PROVINCE = STATE_PROVINCE, NOTES = 'TEST OF ADDING NOTES', CURRENT_DATE = @DATENOW(), SOURCE_TABLE_NAME = @GETENV('GGHEADER','TABLENAME'), COMMIT_SCN = @GETENV('TRANSACTION','CSN'), COMMIT_SCN_SEQ = @GETENV('TRANSACTION','CSN'), SRC_TABLE_NAME = @TOKEN('TK_TABLE'), OPERATION = @GETENV('GGHEADER','OPTYPE'), RECORD_ROWWID = @GETENV('RECORD','ROWID'), BEFORE_AFTER = @GETENV('GGHEADER','BEFOREAFTERINDICATOR')).
2017-02-21 02:28:25 INFO OGG-02756 The definition for table OGGUSER.LOCATIONSX is obtained from the trail file.
Using the following default columns with matching names:
LOCATION_ID=LOCATION_ID, STREET_ADDRESS=STREET_ADDRESS, POSTAL_CODE=POSTAL_CODE, CITY=CITY, COUNTRY_ID=COUNTRY_ID, DIVISION=DIVISION
2017-02-21 02:28:25 INFO OGG-06510 Using the following key columns for target table HR.LOCATIONSX: LOCATION_ID.
2017-02-21 02:31:06 WARNING OGG-02544 Unhandled error (ORA-26799: unique constraint HR.LOCATIONSX_PK violated for table HR.LOCATIONSX with column values ("LOCATION_ID") = (1818)
ORA-00001: unique constraint (HR.LOCATIONSX_PK) violated
ORA-00001: unique constraint (HR.LOCATIONSX_PK) violated) while processing the record at SEQNO 6, RBA 2598 in Integrated mode. REPLICAT will retry in Direct mode.
Source Context :
SourceModule : [er.errors]
SourceID : [er/errors.cpp]
SourceFunction : [take_rep_err_action]
SourceLine : [935]
ThreadBacktrace : [16] elements
: [c:\Oracle\app\product\12.2.0\dbhome_1\gglog.dll(??1CContextItem@@UEAA@XZ+0x2a76) [0x000007FEE9ACE986]]
: [c:\Oracle\app\product\12.2.0\dbhome_1\gglog.dll(?CreateMessage@CMessageFactory@@QEAAPEAVCMessage@@PEAVCSourceContext@@IZZ+0x561) [0x000007FEE9ACEFD1]]
: [c:\Oracle\app\product\12.2.0\dbhome_1\gglog.dll(?_MSG_ERR_MAP_TO_TANDEM_FAILED@@YAPEAVCMessage@@PEAVCSourceContext@@AEBV?$CQualDBObjName@$00@ggapp@gglib@ggs@@1W4MessageDisposition@CMessageFactory@@@Z+0x81) [0x000007FEE9A73651]]
: [c:\Oracle\app\product\12.2.0\dbhome_1\replicat.exe(ERCALLBACK+0xaf5f) [0x000000013F4E1F0F]]
: [c:\Oracle\app\product\12.2.0\dbhome_1\replicat.exe(ERCALLBACK+0xb299b) [0x000000013F58994B]]
: [c:\Oracle\app\product\12.2.0\dbhome_1\replicat.exe(ERCALLBACK+0xb75ab) [0x000000013F58E55B]]
: [c:\Oracle\app\product\12.2.0\dbhome_1\replicat.exe(ERCALLBACK+0x5a61d) [0x000000013F5315CD]]
: [c:\Oracle\app\product\12.2.0\dbhome_1\replicat.exe(ERCALLBACK+0x4b6f1) [0x000000013F5226A1]]
: [c:\Oracle\app\product\12.2.0\dbhome_1\replicat.exe(ERCALLBACK+0xae767) [0x000000013F585717]]
: [c:\Oracle\app\product\12.2.0\dbhome_1\replicat.exe(_ggTryDebugHook+0x6c33) [0x000000013F635A33]]
: [c:\Oracle\app\product\12.2.0\dbhome_1\replicat.exe(_ggTryDebugHook+0x5deb) [0x000000013F634BEB]]
: [c:\Oracle\app\product\12.2.0\dbhome_1\replicat.exe(_ggTryDebugHook+0x6add) [0x000000013F6358DD]]
: [c:\Oracle\app\product\12.2.0\dbhome_1\replicat.exe(ERCALLBACK+0xae80b) [0x000000013F5857BB]]
: [c:\Oracle\app\product\12.2.0\dbhome_1\replicat.exe(CommonLexerNewSSD+0x2e892) [0x000000013F74CE02]]
: [C:\Windows\system32\kernel32.dll(BaseThreadInitThunk+0xd) [0x000000007696652D]]
: [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart+0x21) [0x0000000076EFC521]]
2017-02-21 02:31:06 ERROR OGG-01296 Error mapping from OGGUSER.LOCATIONSX to HR.LOCATIONSX.
***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************
Last record for the last committed transaction is the following:
___________________________________________________________________
Trail name : c:\Oracle\app\product\12.2.0\dbhome_1\dirdat\b2000000006
Hdr-Ind : E (x45) Partition : . (x0c)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 121 (x0079) IO Time : 2017-02-21 02:30:47.766000
IOType : 134 (x86) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 98 AuditPos : 22515216
Continued : N (x00) RecCount : 1 (x01)
2017-02-21 02:30:47.766000 UnifiedUpdate Len 121 RBA 2598
TDR Index: 1
___________________________________________________________________
Reading c:\Oracle\app\product\12.2.0\dbhome_1\dirdat\b2000000006, current RBA 2598, 2 records, m_file_seqno = 6, m_file_rba = 2598
Report at 2017-02-21 02:31:11 (activity since 2017-02-21 02:26:58)
From Table OGGUSER.LOCATIONSX to HR.LOCATIONSX:
# inserts: 1
# updates: 0
# deletes: 0
# discards: 2
Integrated Replicat Statistics:
Total transactions: 2
Redirected: 1
DDL operations: 0
Stored procedures: 0
Datatype functionality: 0
Event actions: 0
Direct transactions ratio: 50%
Last log location read:
FILE: c:\\Oracle\\app\\product\\12.2.0\\dbhome\_1\\dirdat\\b2000000006
SEQNO: 6
RBA: 2598
TIMESTAMP: 2017-02-21 02:30:47.766000
EOF: NO
READERR: 0
2017-02-21 02:31:11 ERROR OGG-01668 PROCESS ABENDING.
CACHE OBJECT MANAGER statistics
CACHE MANAGER VM USAGE
vm current = 0 vm anon queues = 0
vm anon in use = 0 vm file = 0
vm used max = 0 ==> CACHE BALANCED
CACHE CONFIGURATION
cache size = 2G cache force paging = 3.41G
buffer min = 64K buffer max (soft) = 4M
pageout eligible size = 4M
================================================================================
RUNTIME STATS FOR SUPERPOOL
CACHE Transaction Stats
trans active = 0 max concurrent = 0
non-zero total = 0 trans total = 0
CACHE File Caching
filecache rqsts = 0 bytes to disk = 0
file retrieves = 0 objs filecached = 0
queue entries = 0 queue processed = 0
queue entry not needed = 0 queue not signaled = 0
fc requesting obj = 0
CACHE MANAGEMENT
buffer links = 0 anon gets = 0
forced unmaps = 0 cnnbl try = 0
cached out = 0
Allocation Request Distribution
< 128B: 0
128B: 0 0 | 512B: 0 0
2K: 0 0 | 8K: 0 0
32K: 0 0 | 128K: 0 0
512K: 0 0 | 2M: 0 0
8M: 0 0 | 32M: 0 0
128M: 0 0 | 512M: 0
Cached Transaction Size Distribution
0: 0
< 4K: 0
4K: 0 0 | 16K: 0 0
64K: 0 0 | 256K: 0 0
1M: 0 0 | 4M: 0 0
16M: 0 0 | 64M: 0 0
256M: 0 0 | 1G: 0 0
4G: 0 0 | 16G: 0 0
64G: 0 0 | 256G: 0 0
1T: 0 0 | 4T: 0 0
16T: 0 0 | 64T: 0 0
256T: 0 0 |1024T: 0 0
================================================================================
CUMULATIVE STATS FOR SUPERPOOL (PREVIOUS RUNS ONLY)
CACHE Transaction Stats
trans active = 0 max concurrent = 0
non-zero total = 0 trans total = 0
CACHE File Caching
filecache rqsts = 0 bytes to disk = 0
file retrieves = 0 objs filecached = 0
queue entries = 0 queue processed = 0
queue entry not needed = 0 queue not signaled = 0
fc requesting obj = 0
CACHE MANAGEMENT
buffer links = 0 anon gets = 0
forced unmaps = 0 cnnbl try = 0
cached out = 0
Allocation Request Distribution
< 128B: 0
128B: 0 0 | 512B: 0 0
2K: 0 0 | 8K: 0 0
32K: 0 0 | 128K: 0 0
512K: 0 0 | 2M: 0 0
8M: 0 0 | 32M: 0 0
128M: 0 0 | 512M: 0
Cached Transaction Size Distribution
0: 0
< 4K: 0
4K: 0 0 | 16K: 0 0
64K: 0 0 | 256K: 0 0
1M: 0 0 | 4M: 0 0
16M: 0 0 | 64M: 0 0
256M: 0 0 | 1G: 0 0
4G: 0 0 | 16G: 0 0
64G: 0 0 | 256G: 0 0
1T: 0 0 | 4T: 0 0
16T: 0 0 | 64T: 0 0
256T: 0 0 |1024T: 0 0
QUEUE Statistics
num queues = 11 q hits = 0 q misses = 0
queue size q hits curlen maxlen cannibalized
0 64K 0 0 0 0
1 128K 0 0 0 0
2 256K 0 0 0 0
3 512K 0 0 0 0
4 1M 0 0 0 0
5 2M 0 0 0 0
6 4M 0 0 0 0
7 8M 0 0 0 0
8 16M 0 0 0 0
9 32M 0 0 0 0
10 64M 0 0 0 0
================================================================================
RUNTIME STATS FOR CACHE POOL #0
POOL INFO group: REPLLOC id: p5036_BLOB
trans active = 0 trans concurrent (max) = 0
trans total = 0 (0 )
flag = 0x00000030
last error = (0=<none>)
Allocation Request Distribution
< 128B: 0
128B: 0 0 | 512B: 0 0
2K: 0 0 | 8K: 0 0
32K: 0 0 | 128K: 0 0
512K: 0 0 | 2M: 0 0
8M: 0 0 | 32M: 0 0
128M: 0 0 | 512M: 0
================================================================================
CUMULATIVE STATS FOR CACHE POOL #0 (PREVIOUS RUNS ONLY)
POOL INFO group: REPLLOC id: p5036_BLOB
trans active = 0 trans concurrent (max) = 0
trans total = 0 (0 )
flag = 0x00000030
last error = (0=<none>)
Allocation Request Distribution
< 128B: 0
128B: 0 0 | 512B: 0 0
2K: 0 0 | 8K: 0 0
32K: 0 0 | 128K: 0 0
512K: 0 0 | 2M: 0 0
8M: 0 0 | 32M: 0 0
128M: 0 0 | 512M: 0