By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,407 Members | 1,072 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,407 IT Pros & Developers. It's quick & easy.

Tablequeue buffers overflow

P: n/a
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.065791020938
Application name = osh
Application ID = A438B224.D378.065791020938
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.TRANSACTION_SEQ AS TRANSACTION_ID, NEXTVAL FOR
CARD.TRANSACTION_COMNT_SEQ AS SVC_CASE_COMNT_ID, INPUT_CLM_SRC_CD,
INPUT_CLM_REC_CD, INPUT_SEQ_NO, INPUT_SELL_SRC_CD, INPUT_SITE_CD,
INPUT_DOC_NO, INPUT_RECPT_DTE, INPUT_REFILE_IND, INPUT_RO_NO,
INPUT_RO_DTE, INPUT_VIN, LTRIM(RTRIM(INPUT_MILEAGE)),
INPUT_SVC_ADVISOR_SSN, INPUT_DELV_RECPT_NO, INPUT_DELV_RECPT_DTE,
INPUT_CARR_CD, INPUT_LINE_NO, INPUT_CLM_TYPE,
INPUT_SVC_CUST_CMPLAINT_CD, INPUT_DAMG_CD,
LTRIM(RTRIM(INPUT_PART_QTY)), LTRIM(RTRIM(INPUT_PART_NO)),
LTRIM(RTRIM(INPUT_PART_AMT)), INPUT_FAIL_CD, INPUT_OBDII_CAUSE_CD,
INPUT_LAB_OP, LTRIM(RTRIM(INPUT_LAB_HRS)),
LTRIM(RTRIM(INPUT_OTH_LAB_HRS)), INPUT_TECH_SSN,
LTRIM(RTRIM(INPUT_NET_ITEM_AMT)), LTRIM(RTRIM(INPUT_CLM_TOT_AMT)),
INPUT_AUTH_CD, INPUT_AUTH_AUTHORIZ_CD, INPUT_DEBIT_REASON,
INPUT_CORR_REJ, INPUT_ERR_DAC_IND, INPUT_RTE_OVERRIDE_IND,
INPUT_INBND_CMNT_IND, INPUT_SUSP_ID, INPUT_BASE_ADDTL_LGTH,
INPUT_CASE_ADDTL_LGTH, INPUT_SAT_REJ_RES, INPUT_WAR_ADMIN_DIV,
INPUT_BMD_DIV_DLR, INPUT_NON_GM_IND,
LTRIM(RTRIM(INPUT_PART_TAX_RATE)), LTRIM(RTRIM(INPUT_LAB_TAX_RATE)),
LTRIM(RTRIM(INPUT_DED_TAX_RATE)), INPUT_PART_ADJ_RATE_SIGN,
LTRIM(RTRIM(INPUT_PART_ADJ_RATE)),
LTRIM(RTRIM(INPUT_SVC_CASE_TOT_LAB_AMT)), FILLER2, PARTS_DESC,
PARTS_VENDOR_CD, PARTS_VENDOR_COST, PARTS_COMPAT_GROUP_NO,
PARTS_DLR_NET_AMT, PARTS_EFFECT_DTE, FILLER3, LABOR_WCC_BASE,
LABOR_WCC_FULL, LABOR_LBR_RATE_CD,
LTRIM(RTRIM(LABOR_WARR_CLASS_CORP)), LABOR_CAMPAIGN_NO,
LABOR_FILE_TIME, LTRIM(RTRIM(LABOR_TOTAL_SUBLET_CEIL)), FILLER4,
DEALER_AREA_CD, DEALER_REGION_CD, DEALER_ZONE_CD,
DEALER_SERV_DIST_CD, DEALER_SALES_DIST_CD, DEALER_PREV_DLR_CD,
DEALER_REPL_DLR_CD, DEALER_BMD_IND, DEALER_BUSN_FORM_IND,
DEALER_SITE_TYPE_NO, DEALER_GM_LBR_TIME_GUIDE_IND,
DEALER_BUSN_ASCT_CD, DEALER_BUSN_FUNC_CD, DEALER_PRIMARY_LANG_CD,
DEALER_CNTRY_CD, FILLER5, VEH_WARR_BLOCK_IND, VEH_BRANDED_TITLE_IND,
VEH_VPP, VEH_BUYBACK, VEH_PDI_STATUS, VEH_ODOMETER_TYPE,
VEH_BBUNL, VEH_SHIPPED_TO_DLR, VEH_DLVRY_SRVC_DLR,
VEH_DLVRY_SRVC_DTE, VEH_DLVRY_SRVC_DISTANCE,
VEH_INSERVICE_DLVRY_DATE, FILLER6, VEH_PROD_DTE,
VEH_BRANDED_TITLE_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_START_DTE,
LTRIM(RTRIM(VEH_DLAY_WARR_START_DIST)), VEH_COMPAT_STR,
VEH_VPP_START_DATE, VEH_VPP_START_MILES, VEH_LEMON_LAW_IND,
VEH_WARR_START_DATE, FILLER7, MIC_AGRMNT_REF_NO, MIC_AGRMNT_TYP,
MIC_ASSEMBLY_CD, MIC_PART_CD, FILLER8, COMP_STATE,
LTRIM(RTRIM(COMP_LAB_HRS_USED)), LTRIM(RTRIM(COMP_LAB_AMT_GROSS)),
LTRIM(RTRIM(COMP_OTH_LAB_HRS_USED)),
LTRIM(RTRIM(COMP_OTH_LAB_AMT_GROSS)),
LTRIM(RTRIM(COMP_LAB_TAX_GROSS)), LTRIM(RTRIM(COMP_PART_AMT_GROSS)),
LTRIM(RTRIM(COMP_PART_TAX_GROSS)), LTRIM(RTRIM(COMP_DLR_PART_ALLOW)),
LTRIM(RTRIM(COMP_NET_AMT_GROSS)), LTRIM(RTRIM(COMP_DEDUCT_AMT)),
LTRIM(RTRIM(COMP_DEDUCT_TAX_GROSS)), LTRIM(RTRIM(COMP_CLM_TOT_AMT)),
LTRIM(RTRIM(COMP_CLM_TAX_GROSS)), COMP_PROCESS_DTE, COMP_COST_CAT,
COMP_TOURIST_IND, COMP_REDUCE_CD_01, COMP_DISP_CD, COMP_ROUTE,
COMP_SEVERITY_CD, LTRIM(RTRIM(COMP_CYCLE_ROLL)), COMP_ERRS,
COMP_ERRS_AUTH, COMP_COST_CAT_WCC, COMP_DBT_CRD_IND,
COMP_ERR_2_DIGIT, COMP_SUSPENSE_IND,
LTRIM(RTRIM(COMP_EXCESS_LBR_HRS)), LTRIM(RTRIM(COMP_EXCESS_LBR_AMT)),
LTRIM(RTRIM(COMP_EXCESS_OTH_LBR_HRS)),
LTRIM(RTRIM(COMP_EXCESS_OTH_LBR_AMT)),
LTRIM(RTRIM(COMP_EXCESS_PART_AMT)), LTRIM(RTRIM(COMP_EXCESS_NET_AMT)),
COMP_TIME_OUT_WARR, COMP_DISTANCE_OUT_WARR, COMP_TIME_IN_SERVICE,
COMP_DISTANCE_IN_SERVICE, COMP_EFFECTIVE_AUTH_CD,
COMP_TRK_MATRIX_COND_CD, COMP_VAL_PRODUCT_LINE, FILLER9,
COMEBACK_DEALER_CD, LTRIM(RTRIM(COMEBACK_RO_NO)), COMEBACK_TRANS_DTE,
COMEBACK_CYCLE_ROLL, COMEBACK_SEQ_NO, COMEBACK_DOC_NO,
COMEBACK_DOC_LINE_NO, COMEBACK_LO_NO, COMEBACK_CLM_TOT_AMT,
COMEBACK_MILES, COMEBACK_TRANS_CD, FILLER10, ROLLBACK_DOC_NO,
ROLLBACK_DOC_LINE_NO, ROLLBACK_RO_NO, ROLLBACK_CYCLE_ROLL,
ROLLBACK_MILES, ROLLBACK_VPP_REG, ROLLBACK_SEQ_NO, PAID_CYCLE_ROLL,
FILEBLK_RO_NO, FILEBLK_CYCLE_ROLL, FILEBLK_BLOCK_EFFECT_DTE,
FILLER11, DIVEXTCD_ERR_3_DIGIT_01, LTRIM(RTRIM(SVC_INBND_COMMENT)),
SVC_OUTBND_COMMENT, SVC_MEMO_PART_COMMENT, CPTD_CONV_RATE,
LTRIM(RTRIM(CR_GLOBAL_NET_ITEM_AMT)),
LTRIM(RTRIM(CR_REGIONAL_NET_ITEM_AMT)), DEALER_KEY, ERR_FLAG,
LTRIM(RTRIM(GLOBAL_DEDCTB_AMT)), LTRIM(RTRIM(GLOBAL_DEDCTB_TAX_AMT)),
LTRIM(RTRIM(GLOBAL_DLR_SUBLET_CEIL_AMT)),
LTRIM(RTRIM(GLOBAL_LABOR_AMT)), LTRIM(RTRIM(GLOBAL_LBR_TAX_AMT)),
LTRIM(RTRIM(GLOBAL_OTHR_LBR_AMT)), LTRIM(RTRIM(GLOBAL_PART_AMT)),
LTRIM(RTRIM(GLOBAL_PART_TAX_AMT)),
LTRIM(RTRIM(GLOBAL_PARTS_MARKUP_COST)),
LTRIM(RTRIM(GLOBAL_TOTAL_CLAIM_AMT)), INVALID_DLR, ISO_UNIT_MEAS_CD,
JOB_REPAIR_DT_ORIG, ETL.STG_NA_WINS_WINSPCF_NA.LOCAL_CURRENCY_CD,
REGION_CURRENCY_CD, LTRIM(RTRIM(REGIONAL_DEDCTB_AMT)),
LTRIM(RTRIM(REGIONAL_DEDCTB_TAX_AMT)),
LTRIM(RTRIM(REGIONAL_DLR_SUBLET_CEIL_AMT)),
LTRIM(RTRIM(REGIONAL_LABOR_AMT)), LTRIM(RTRIM(REGIONAL_LBR_TAX_AMT)),
LTRIM(RTRIM(REGIONAL_OTHR_LBR_AMT)), LTRIM(RTRIM(REGIONAL_PART_AMT)),
LTRIM(RTRIM(REGIONAL_PART_TAX_AMT)),
LTRIM(RTRIM(REGIONAL_PARTS_MARKUP_COST)),
LTRIM(RTRIM(REGIONAL_TOTAL_CLAIM_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_NBR, case when length(ltrim(rtrim(SVC_INBND_COMMENT)))=1
then case when ascii(SVC_INBND_COMMENT) between 0 and
255 then 'Y' else 'N' end when
length(ltrim(rtrim(SVC_INBND_COMMENT))) >1 then 'Y' else 'N' end as
INBND_COMNT_IND, case when
length(ltrim(rtrim(SVC_MEMO_PART_COMMENT)))=1 then case
when ascii(SVC_MEMO_PART_COMMENT) between 0 and 255 then 'Y' else 'N'
end when length(ltrim(rtrim(SVC_MEMO_PART_COMMENT))) >1 then 'Y'
else 'N' end AS MEMO_COMNT_IND, case when
length(ltrim(rtrim(INPUT_PART_NO)))=1 then case when
ascii(INPUT_PART_NO) between 0 and 255 then 'Y' else 'N' end
when length(ltrim(rtrim(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_CD in (4,8)) GV
ON ETL.STG_NA_WINS_WINSPCF_NA.INPUT_VIN = GV.VEH_IDENT_NBR 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

Aug 1 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.