My Oracle Support Banner

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

Last updated on SEPTEMBER 28, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A 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="<EXADATA_CELL_IP_1>;<EXADATA_CELL_IP_2>" OBJECT_NAME="4003802647" STATISTICS_TYPE="SENDPORT"
<remotesendport_stats>
<stats type="client_stats">
<stat name="client_hostname"<HOSTNAME>.<DOMAINNAME></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="<EXADATA_CELL_IP_1>;<EXADATA_CELL_IP_2>" OBJECT_NAME="4003804834" STATISTICS_TYPE="SENDPORT"
<remotesendport_stats>
<stats type="client_stats">
<stat name="client_hostname"<HOSTNAME>.<DOMAINNAME></stat>
<stat name="client_pid">82927</stat>

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

Changes

 Bug 19332407 - SQLT XTRACT LONG RUNNING COLLECTING V$CELL_STATE

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.