Hello, A particular select query took unusually long time to execute
hence I took an app.snap to find out what happens internally and I
found out that tablequeue buffers are overflowing on a particular node
of my logically partitioned db having 8 partitions.
Current number of tablequeue buffers overflowed = 147737
Total number of tablequeue buffers overflowed = 190224
Maximum number of tablequeue buffers overflowed = 189683
Can you please help me to resolve this error. Thanks
Full App.snap is as below.
Application Snapshot
Application handle = 752
Application status = UOW Waiting
Status change time = 07/31/2006 23:26:06.155943
Application code page = 819
Application country/region code = 1
DUOW correlation token = A438B224.D378.0 65791020938
Application name = osh
Application ID = A438B224.D378.0 65791020938
Sequence number = 0001
TP Monitor client user ID =
TP Monitor client workstation name =
TP Monitor client application name =
TP Monitor client accounting string =
Connection request start timestamp = 07/31/2006 22:09:38.963574
Connect request completion timestamp = 07/31/2006 22:09:38.964465
Application idle time = 5 seconds
CONNECT Authorization ID = CARDUSER
Client login ID = carduser
Configuration NNAME of client = ah2s00618
Client database manager product ID = SQL08023
Process ID of client application = 25976
Platform of client application = SUN
Communication protocol of client = TCP/IP
Inbound communication address = 164.56.178.36 54136
Database name = CARD
Database path =
/udb/udbdata/cardp1in/cardp1in/NODE0000/SQL00001/
Client database alias = CARD
Input database alias = CARD
Last reset timestamp =
Snapshot timestamp = 07/31/2006 23:26:11.129943
The highest authority level granted =
Indirect CREATETAB authority
Indirect BINDADD authority
Indirect CONNECT authority
Indirect IMPLICIT_SCHEMA authority
Indirect LOAD authority
Coordinating database partition number = 0
Current database partition number = 0
Coordinator agent process or thread ID = 3158092
Agents stolen = 0
Agents waiting on locks = 0
Maximum associated agents = 10
Priority at which application agents work = 0
Priority type = Dynamic
Lock timeout (seconds) = 600
Locks held by application = 4
Lock waits since connect = 0
Time application waited on locks (ms) = 0
Deadlocks detected = 0
Lock escalations = 0
Exclusive lock escalations = 0
Number of Lock Timeouts since connected = 0
Total time UOW waited on locks (ms) = 0
Total sorts = 0
Total sort time (ms) = Not Collected
Total sort overflows = 0
Data pages copied to extended storage = Not Collected
Index pages copied to extended storage = Not Collected
Data pages copied from extended storage = Not Collected
Index pages copied from extended storage = Not Collected
Buffer pool data logical reads = Not Collected
Buffer pool data physical reads = Not Collected
Buffer pool temporary data logical reads = Not Collected
Buffer pool temporary data physical reads = Not Collected
Buffer pool data writes = Not Collected
Buffer pool index logical reads = Not Collected
Buffer pool index physical reads = Not Collected
Buffer pool temporary index logical reads = Not Collected
Buffer pool temporary index physical reads = Not Collected
Buffer pool index writes = Not Collected
Total buffer pool read time (milliseconds) = Not Collected
Total buffer pool write time (milliseconds)= Not Collected
Time waited for prefetch (ms) = Not Collected
Unread prefetch pages = Not Collected
Direct reads = Not Collected
Direct writes = Not Collected
Direct read requests = Not Collected
Direct write requests = Not Collected
Direct reads elapsed time (ms) = Not Collected
Direct write elapsed time (ms) = Not Collected
Number of SQL requests since last commit = 715
Commit statements = 0
Rollback statements = 0
Dynamic SQL statements attempted = 715
Static SQL statements attempted = 0
Failed statement operations = 2
Select SQL statements executed = 1
Update/Insert/Delete statements executed = 0
DDL statements executed = 0
Inactive stmt history memory usage (bytes) = 0
Internal automatic rebinds = 0
Internal rows deleted = 0
Internal rows inserted = 0
Internal rows updated = 0
Internal commits = 1
Internal rollbacks = 0
Internal rollbacks due to deadlock = 0
Binds/precompiles attempted = 0
Rows deleted = 0
Rows inserted = 0
Rows updated = 0
Rows selected = 75921
Rows read = 370711
Rows written = 190224
UOW log space used (Bytes) = 0
Previous UOW completion timestamp = 07/31/2006 22:09:38.964465
Elapsed time of last completed uow (sec.ms)= 0.000000
UOW start timestamp = 07/31/2006 22:09:39.008789
UOW stop timestamp =
UOW completion status =
Open remote cursors = 1
Open remote cursors with blocking = 1
Rejected Block Remote Cursor requests = 0
Accepted Block Remote Cursor requests = 1
Open local cursors = 0
Open local cursors with blocking = 0
Total User CPU Time used by agent (s) = 20.796171
Total System CPU Time used by agent (s) = 1.308886
Host execution elapsed time = 0.098128
Package cache lookups = 12
Package cache inserts = 1
Application section lookups = 716
Application section inserts = 1
Catalog cache lookups = 63
Catalog cache inserts = 3
Catalog cache overflows = 0
Catalog cache high water mark = 0
Workspace Information
Shared high water mark = 6603465
Total shared overflows = 0
Total shared section inserts = 1
Total shared section lookups = 1
Private high water mark = 0
Total private overflows = 0
Total private section inserts = 0
Total private section lookups = 0
Most recent operation = Fetch
Cursor name = SQL_CURSH200C4
Most recent operation start timestamp = 07/31/2006 22:09:39.136001
Most recent operation stop timestamp = 07/31/2006 23:26:06.155941
Agents associated with the application = 9
Number of hash joins = 0
Number of hash loops = 0
Number of hash join overflows = 0
Number of small hash join overflows = 0
Statement type = Dynamic SQL Statement
Statement = Fetch
Section number = 4
Application creator = NULLID
Package name = SYSSH200
Consistency Token = SYSLVL01
Package Version ID =
Cursor name = SQL_CURSH200C4
Statement database partition number = 0
Statement start timestamp = 07/31/2006 22:09:39.136001
Statement stop timestamp = 07/31/2006 23:26:06.155941
Elapsed time of last completed stmt(sec.ms)= 0.098128
Total Statement user CPU time = 17.382323
Total Statement system CPU time = 0.364014
SQL compiler cost estimate in timerons = 1885043
SQL compiler cardinality estimate = 246036
Degree of parallelism requested = 1
Number of agents working on statement = 0
Number of subagents created for statement = 1
Statement sorts = 0
Total sort time = 0
Sort overflows = 0
Rows read = 370535
Rows written = 190224
Rows deleted = 0
Rows updated = 0
Rows inserted = 0
Rows fetched = 75921
Buffer pool data logical reads = Not Collected
Buffer pool data physical reads = Not Collected
Buffer pool temporary data logical reads = Not Collected
Buffer pool temporary data physical reads = Not Collected
Buffer pool index logical reads = Not Collected
Buffer pool index logical reads = Not Collected
Buffer pool temporary index logical reads = Not Collected
Buffer pool temporary index physical reads = Not Collected
Blocking cursor = YES
Dynamic SQL statement text:
SELECT NEXTVAL FOR CARD.TRANSACTIO N_SEQ AS TRANSACTION_ID, NEXTVAL FOR
CARD.TRANSACTIO N_COMNT_SEQ AS SVC_CASE_COMNT_ ID, INPUT_CLM_SRC_C D,
INPUT_CLM_REC_C D, INPUT_SEQ_NO, INPUT_SELL_SRC_ CD, INPUT_SITE_CD,
INPUT_DOC_NO, INPUT_RECPT_DTE , INPUT_REFILE_IN D, INPUT_RO_NO,
INPUT_RO_DTE, INPUT_VIN, LTRIM(RTRIM(INP UT_MILEAGE)),
INPUT_SVC_ADVIS OR_SSN, INPUT_DELV_RECP T_NO, INPUT_DELV_RECP T_DTE,
INPUT_CARR_CD, INPUT_LINE_NO, INPUT_CLM_TYPE,
INPUT_SVC_CUST_ CMPLAINT_CD, INPUT_DAMG_CD,
LTRIM(RTRIM(INP UT_PART_QTY)), LTRIM(RTRIM(INP UT_PART_NO)),
LTRIM(RTRIM(INP UT_PART_AMT)), INPUT_FAIL_CD, INPUT_OBDII_CAU SE_CD,
INPUT_LAB_OP, LTRIM(RTRIM(INP UT_LAB_HRS)),
LTRIM(RTRIM(INP UT_OTH_LAB_HRS) ), INPUT_TECH_SSN,
LTRIM(RTRIM(INP UT_NET_ITEM_AMT )), LTRIM(RTRIM(INP UT_CLM_TOT_AMT) ),
INPUT_AUTH_CD, INPUT_AUTH_AUTH ORIZ_CD, INPUT_DEBIT_REA SON,
INPUT_CORR_REJ, INPUT_ERR_DAC_I ND, INPUT_RTE_OVERR IDE_IND,
INPUT_INBND_CMN T_IND, INPUT_SUSP_ID, INPUT_BASE_ADDT L_LGTH,
INPUT_CASE_ADDT L_LGTH, INPUT_SAT_REJ_R ES, INPUT_WAR_ADMIN _DIV,
INPUT_BMD_DIV_D LR, INPUT_NON_GM_IN D,
LTRIM(RTRIM(INP UT_PART_TAX_RAT E)), LTRIM(RTRIM(INP UT_LAB_TAX_RATE )),
LTRIM(RTRIM(INP UT_DED_TAX_RATE )), INPUT_PART_ADJ_ RATE_SIGN,
LTRIM(RTRIM(INP UT_PART_ADJ_RAT E)),
LTRIM(RTRIM(INP UT_SVC_CASE_TOT _LAB_AMT)), FILLER2, PARTS_DESC,
PARTS_VENDOR_CD , PARTS_VENDOR_CO ST, PARTS_COMPAT_GR OUP_NO,
PARTS_DLR_NET_A MT, PARTS_EFFECT_DT E, FILLER3, LABOR_WCC_BASE,
LABOR_WCC_FULL, LABOR_LBR_RATE_ CD,
LTRIM(RTRIM(LAB OR_WARR_CLASS_C ORP)), LABOR_CAMPAIGN_ NO,
LABOR_FILE_TIME , LTRIM(RTRIM(LAB OR_TOTAL_SUBLET _CEIL)), FILLER4,
DEALER_AREA_CD, DEALER_REGION_C D, DEALER_ZONE_CD,
DEALER_SERV_DIS T_CD, DEALER_SALES_DI ST_CD, DEALER_PREV_DLR _CD,
DEALER_REPL_DLR _CD, DEALER_BMD_IND, DEALER_BUSN_FOR M_IND,
DEALER_SITE_TYP E_NO, DEALER_GM_LBR_T IME_GUIDE_IND,
DEALER_BUSN_ASC T_CD, DEALER_BUSN_FUN C_CD, DEALER_PRIMARY_ LANG_CD,
DEALER_CNTRY_CD , FILLER5, VEH_WARR_BLOCK_ IND, VEH_BRANDED_TIT LE_IND,
VEH_VPP, VEH_BUYBACK, VEH_PDI_STATUS, VEH_ODOMETER_TY PE,
VEH_BBUNL, VEH_SHIPPED_TO_ DLR, VEH_DLVRY_SRVC_ DLR,
VEH_DLVRY_SRVC_ DTE, VEH_DLVRY_SRVC_ DISTANCE,
VEH_INSERVICE_D LVRY_DATE, FILLER6, VEH_PROD_DTE,
VEH_BRANDED_TIT LE_DTE, VEH_INVC_DLR, VEH_WARR_BLOCK_ CD,
VEH_ORDER_TYPE_ NO, VEH_SRVC_TYP_NO , VEH_DLVRY_TYPE_ NO,
VEH_SALES_MODEL _CD, VEH_DLAY_WARR_S TART_DTE,
LTRIM(RTRIM(VEH _DLAY_WARR_STAR T_DIST)), VEH_COMPAT_STR,
VEH_VPP_START_D ATE, VEH_VPP_START_M ILES, VEH_LEMON_LAW_I ND,
VEH_WARR_START_ DATE, FILLER7, MIC_AGRMNT_REF_ NO, MIC_AGRMNT_TYP,
MIC_ASSEMBLY_CD , MIC_PART_CD, FILLER8, COMP_STATE,
LTRIM(RTRIM(COM P_LAB_HRS_USED) ), LTRIM(RTRIM(COM P_LAB_AMT_GROSS )),
LTRIM(RTRIM(COM P_OTH_LAB_HRS_U SED)),
LTRIM(RTRIM(COM P_OTH_LAB_AMT_G ROSS)),
LTRIM(RTRIM(COM P_LAB_TAX_GROSS )), LTRIM(RTRIM(COM P_PART_AMT_GROS S)),
LTRIM(RTRIM(COM P_PART_TAX_GROS S)), LTRIM(RTRIM(COM P_DLR_PART_ALLO W)),
LTRIM(RTRIM(COM P_NET_AMT_GROSS )), LTRIM(RTRIM(COM P_DEDUCT_AMT)),
LTRIM(RTRIM(COM P_DEDUCT_TAX_GR OSS)), LTRIM(RTRIM(COM P_CLM_TOT_AMT)) ,
LTRIM(RTRIM(COM P_CLM_TAX_GROSS )), COMP_PROCESS_DT E, COMP_COST_CAT,
COMP_TOURIST_IN D, COMP_REDUCE_CD_ 01, COMP_DISP_CD, COMP_ROUTE,
COMP_SEVERITY_C D, LTRIM(RTRIM(COM P_CYCLE_ROLL)), COMP_ERRS,
COMP_ERRS_AUTH, COMP_COST_CAT_W CC, COMP_DBT_CRD_IN D,
COMP_ERR_2_DIGI T, COMP_SUSPENSE_I ND,
LTRIM(RTRIM(COM P_EXCESS_LBR_HR S)), LTRIM(RTRIM(COM P_EXCESS_LBR_AM T)),
LTRIM(RTRIM(COM P_EXCESS_OTH_LB R_HRS)),
LTRIM(RTRIM(COM P_EXCESS_OTH_LB R_AMT)),
LTRIM(RTRIM(COM P_EXCESS_PART_A MT)), LTRIM(RTRIM(COM P_EXCESS_NET_AM T)),
COMP_TIME_OUT_W ARR, COMP_DISTANCE_O UT_WARR, COMP_TIME_IN_SE RVICE,
COMP_DISTANCE_I N_SERVICE, COMP_EFFECTIVE_ AUTH_CD,
COMP_TRK_MATRIX _COND_CD, COMP_VAL_PRODUC T_LINE, FILLER9,
COMEBACK_DEALER _CD, LTRIM(RTRIM(COM EBACK_RO_NO)), COMEBACK_TRANS_ DTE,
COMEBACK_CYCLE_ ROLL, COMEBACK_SEQ_NO , COMEBACK_DOC_NO ,
COMEBACK_DOC_LI NE_NO, COMEBACK_LO_NO, COMEBACK_CLM_TO T_AMT,
COMEBACK_MILES, COMEBACK_TRANS_ CD, FILLER10, ROLLBACK_DOC_NO ,
ROLLBACK_DOC_LI NE_NO, ROLLBACK_RO_NO, ROLLBACK_CYCLE_ ROLL,
ROLLBACK_MILES, ROLLBACK_VPP_RE G, ROLLBACK_SEQ_NO , PAID_CYCLE_ROLL ,
FILEBLK_RO_NO, FILEBLK_CYCLE_R OLL, FILEBLK_BLOCK_E FFECT_DTE,
FILLER11, DIVEXTCD_ERR_3_ DIGIT_01, LTRIM(RTRIM(SVC _INBND_COMMENT) ),
SVC_OUTBND_COMM ENT, SVC_MEMO_PART_C OMMENT, CPTD_CONV_RATE,
LTRIM(RTRIM(CR_ GLOBAL_NET_ITEM _AMT)),
LTRIM(RTRIM(CR_ REGIONAL_NET_IT EM_AMT)), DEALER_KEY, ERR_FLAG,
LTRIM(RTRIM(GLO BAL_DEDCTB_AMT) ), LTRIM(RTRIM(GLO BAL_DEDCTB_TAX_ AMT)),
LTRIM(RTRIM(GLO BAL_DLR_SUBLET_ CEIL_AMT)),
LTRIM(RTRIM(GLO BAL_LABOR_AMT)) , LTRIM(RTRIM(GLO BAL_LBR_TAX_AMT )),
LTRIM(RTRIM(GLO BAL_OTHR_LBR_AM T)), LTRIM(RTRIM(GLO BAL_PART_AMT)),
LTRIM(RTRIM(GLO BAL_PART_TAX_AM T)),
LTRIM(RTRIM(GLO BAL_PARTS_MARKU P_COST)),
LTRIM(RTRIM(GLO BAL_TOTAL_CLAIM _AMT)), INVALID_DLR, ISO_UNIT_MEAS_C D,
JOB_REPAIR_DT_O RIG, ETL.STG_NA_WINS _WINSPCF_NA.LOC AL_CURRENCY_CD,
REGION_CURRENCY _CD, LTRIM(RTRIM(REG IONAL_DEDCTB_AM T)),
LTRIM(RTRIM(REG IONAL_DEDCTB_TA X_AMT)),
LTRIM(RTRIM(REG IONAL_DLR_SUBLE T_CEIL_AMT)),
LTRIM(RTRIM(REG IONAL_LABOR_AMT )), LTRIM(RTRIM(REG IONAL_LBR_TAX_A MT)),
LTRIM(RTRIM(REG IONAL_OTHR_LBR_ AMT)), LTRIM(RTRIM(REG IONAL_PART_AMT) ),
LTRIM(RTRIM(REG IONAL_PART_TAX_ AMT)),
LTRIM(RTRIM(REG IONAL_PARTS_MAR KUP_COST)),
LTRIM(RTRIM(REG IONAL_TOTAL_CLA IM_AMT)), SVC_CMPLNT_TYPE _CD,
DEALER_CSV_BFU_ IND, DEALER_VEH_TYPE _CD_C, DEALER_VEH_TYPE _CD_L,
DEALER_VEH_TYPE _CD_M, VEH_FLEET_CUST_ PAY, COMP_REDUCE_CD_ 02,
COMP_REDUCE_CD_ 03, COMP_PUB_ID, DIVEXTCD_ERR_3_ DIGIT_02,
DIVEXTCD_ERR_3_ DIGIT_03, DIVEXTCD_ERR_3_ DIGIT_04,
DIVEXTCD_ERR_3_ DIGIT_05, DIVEXTCD_ERR_3_ DIGIT_06,
DIVEXTCD_ERR_3_ DIGIT_07, DIVEXTCD_ERR_3_ DIGIT_08,
DIVEXTCD_ERR_3_ DIGIT_09, DIVEXTCD_ERR_3_ DIGIT_10, 1 AS KEY1 ,
GV.VEH_IDENT_NB R, case when length(ltrim(rt rim(SVC_INBND_C OMMENT)))=1
then case when ascii(SVC_INBND _COMMENT) between 0 and
255 then 'Y' else 'N' end when
length(ltrim(rt rim(SVC_INBND_C OMMENT))) >1 then 'Y' else 'N' end as
INBND_COMNT_IND , case when
length(ltrim(rt rim(SVC_MEMO_PA RT_COMMENT)))=1 then case
when ascii(SVC_MEMO_ PART_COMMENT) between 0 and 255 then 'Y' else 'N'
end when length(ltrim(rt rim(SVC_MEMO_PA RT_COMMENT))) >1 then 'Y'
else 'N' end AS MEMO_COMNT_IND, case when
length(ltrim(rt rim(INPUT_PART_ NO)))=1 then case when
ascii(INPUT_PAR T_NO) between 0 and 255 then 'Y' else 'N' end
when length(ltrim(rt rim(INPUT_PART_ NO))) >1 then 'Y' else 'N' end AS
PART_NO_IND FROM ETL.STG_NA_WINS _WINSPCF_NA LEFT OUTER JOIN (SELECT
VEH_IDENT_NBR FROM CARD.GLOBAL_VEH WHERE SOURCE_SYSTEM_C D in (4,8)) GV
ON ETL.STG_NA_WINS _WINSPCF_NA.INP UT_VIN = GV.VEH_IDENT_NB R WHERE
((ERR_FLAG <>(CASE WHEN 'Y' ='Y' THEN 'U' END)) OR (ERR_FLAG =(CASE
WHEN 'Y' ='N' THEN 'N' END ))) FOR READ ONLY
Subsection number = 0
Subsection database partition number = 0
Subsection status = Executing
Execution elapsed time (seconds) = 4592
Total user CPU time (sec.ms) = 3.513507
Total system CPU time (sec.ms) = 0.274765
Current number of tablequeue buffers overflowed = 0
Total number of tablequeue buffers overflowed = 0
Maximum number of tablequeue buffers overflowed = 0
Rows received on tablequeues = 75922
Rows sent on tablequeues = 0
Rows read = 0
Rows written = 0
Number of agents working on subsection = 1
Agent process/thread ID = 3158092
Subsection number = 2
Subsection database partition number = 0
Subsection status = Waiting to send
on tablequeue
Node for which waiting on tablequeue = Any node
Tablequeue ID on which agent is waiting = 2
Execution elapsed time (seconds) = 4592
Total user CPU time (sec.ms) = 13.868816
Total system CPU time (sec.ms) = 0.089249
Current number of tablequeue buffers overflowed = 147737
Total number of tablequeue buffers overflowed = 190224
Maximum number of tablequeue buffers overflowed = 189683
Rows received on tablequeues = 0
Rows sent on tablequeues = 327840
Rows read = 370535
Rows written = 190224
Number of agents working on subsection = 1
Agent process/thread ID = 3932324
Agent process/thread ID = 3158092
Database partition number = 0
Agent Lock timeout (seconds) = 600
Memory usage for agent:
Memory Pool Type = Other Memory
Current size (bytes) = 16384
High water mark (bytes) = 16384
Configured size (bytes) = 68719476736
Memory Pool Type = Application Heap
Current size (bytes) = 147456
High water mark (bytes) = 344064
Configured size (bytes) = 753664
Agent process/thread ID = 3932324
Database partition number = 0
Agent Lock timeout (seconds) = 600
Memory usage for agent:
Memory Pool Type = Other Memory
Current size (bytes) = 16384
High water mark (bytes) = 16384
Configured size (bytes) = 68719476736
Memory Pool Type = Application Heap
Current size (bytes) = 65536
High water mark (bytes) = 65536
Configured size (bytes) = 753664
Agent process/thread ID = 1761504
Database partition number = 0
Agent Lock timeout (seconds) = 600
Memory usage for agent:
Memory Pool Type = Other Memory
Current size (bytes) = 32768
High water mark (bytes) = 49152
Configured size (bytes) = 68719476736
Memory Pool Type = Application Heap
Current size (bytes) = 65536
High water mark (bytes) = 65536
Configured size (bytes) = 753664
Agent process/thread ID = 3588184
Database partition number = 0
Agent Lock timeout (seconds) = 600
Memory usage for agent:
Memory Pool Type = Other Memory
Current size (bytes) = 32768
High water mark (bytes) = 49152
Configured size (bytes) = 68719476736
Memory Pool Type = Application Heap
Current size (bytes) = 65536
High water mark (bytes) = 65536
Configured size (bytes) = 753664
Agent process/thread ID = 1056806
Database partition number = 0
Agent Lock timeout (seconds) = 600
Memory usage for agent:
Memory Pool Type = Other Memory
Current size (bytes) = 32768
High water mark (bytes) = 49152
Configured size (bytes) = 68719476736
Memory Pool Type = Application Heap
Current size (bytes) = 65536
High water mark (bytes) = 65536
Configured size (bytes) = 753664
Agent process/thread ID = 3153968
Database partition number = 0
Agent Lock timeout (seconds) = 600
Memory usage for agent:
Memory Pool Type = Other Memory
Current size (bytes) = 32768
High water mark (bytes) = 49152
Configured size (bytes) = 68719476736
Memory Pool Type = Application Heap
Current size (bytes) = 65536
High water mark (bytes) = 65536
Configured size (bytes) = 753664
Agent process/thread ID = 1511456
Database partition number = 0
Agent Lock timeout (seconds) = 600
Memory usage for agent:
Memory Pool Type = Other Memory
Current size (bytes) = 32768
High water mark (bytes) = 49152
Configured size (bytes) = 68719476736
Memory Pool Type = Application Heap
Current size (bytes) = 65536
High water mark (bytes) = 65536
Configured size (bytes) = 753664
Agent process/thread ID = 733184
Database partition number = 0
Agent Lock timeout (seconds) = 600
Memory usage for agent:
Memory Pool Type = Other Memory
Current size (bytes) = 16384
High water mark (bytes) = 16384
Configured size (bytes) = 68719476736
Memory Pool Type = Application Heap
Current size (bytes) = 65536
High water mark (bytes) = 65536
Configured size (bytes) = 753664
Agent process/thread ID = 2179202
Database partition number = 0
Agent Lock timeout (seconds) = 600
Memory usage for agent:
Memory Pool Type = Other Memory
Current size (bytes) = 32768
High water mark (bytes) = 49152
Configured size (bytes) = 68719476736
Memory Pool Type = Application Heap
Current size (bytes) = 65536
High water mark (bytes) = 65536
Configured size (bytes) = 753664
