SQLTXTRACT Runs A LONG Time Collecting V$CELL_STATE (Doc ID 2094324.1)

Last updated on JANUARY 05, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

SQLTXTRACT runs a LONG time collecting V$CELL_STATE

For example, the report taking a long while while creating report sqlt_s43537_cell_state_begin.txt  

A tail of report sqlt_s43537_cell_state_begin.txt shows:

-------------------
[oracle@myoradb01 run]$ tail -30  sqlt_s43537_cell_state_begin.txt
</remotesendport_stats>
INST_ID="1" CELL_NAME="192.168.10.37;192.168.10.38" OBJECT_NAME="4003802647" STATISTICS_TYPE="SENDPORT"
<remotesendport_stats>
<stats type="client_stats">
<stat name="client_hostname">myoradb01.anywhere.com</stat>
<stat name="client_pid">83094</stat>
<stat name="last_send_time">Mon Dec 28 11:03:10 2015 374 msec</stat>
</stats>
<stats type="context_skgxp_stats">
<stat name="ctxptr">0x6001d6fa4500</stat>
<stat name="ospid">11196</stat>
<stat name="proto_bytesx">128555024</stat>
<stat name="proto_opsr">153</stat>
<stat name="proto_bytesr">348</stat>
<stat name="sends">1236106</stat>
<stat name="bytes_sent">187888232</stat>
<stat name="snt_con_msg">2</stat>
<stat name="rpc_mcpy_ospid">83094</stat>
<stat name="rpc_mcpy_fsz">1048576</stat>
<stat name="rpc_mcpy_tfrags">1236314</stat>
<stat name="rpc_mcpy_tbytes">187919728</stat>
<stat name="rdma_bytes_pushed">3424256</stat>
</stats>
</remotesendport_stats>
INST_ID="1" CELL_NAME="192.168.10.37;192.168.10.38" OBJECT_NAME="4003804834" STATISTICS_TYPE="SENDPORT"
<remotesendport_stats>
<stats type="client_stats">
<stat name="client_hostname">myoradb01.anywhere.com</stat>
<stat name="client_pid">82927</stat>

-------------------

Changes

 Bug 19332407 - SQLT XTRACT LONG RUNNING COLLECTING V$CELL_STATE

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms