[
https://issues.apache.org/jira/browse/TRAFODION-1460?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14704359#comment-14704359
]
Selvaganesan Govindarajan commented on TRAFODION-1460:
------------------------------------------------------
I measured the amount of memory allocated in RMS shared segment using GET
STATISTICS FOR RMS ALL command before and after this change.
Before:
Node 0
Stats Heap High WM 2,551,176
Node 1
Stats Heap High WM 1,824,432
After EXPLAIN_IN_RMS is changed to 'ON'
Node 0
Stats Heap High WM 2,811,504
Node 1
Stats Heap High WM 1,839,480
> Enable EXPLAIN_IN_RMS feature by default
> ----------------------------------------
>
> Key: TRAFODION-1460
> URL: https://issues.apache.org/jira/browse/TRAFODION-1460
> Project: Apache Trafodion
> Issue Type: Improvement
> Components: sql-exe
> Affects Versions: 1.0 (pre-incubation)
> Reporter: Selvaganesan Govindarajan
> Assignee: Selvaganesan Govindarajan
> Priority: Minor
>
> EXPLAIN_IN_RMS enables user to get the query plan using RMS while the query
> is active and is not de-allocated. The syntax is
> explain for qid <qid>
> explain options 'f' for qid <qid>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
