sql disappears from v$sql as soon as it finishes running?

From: <"">
Date: Fri, 15 May 2020 17:48:15 +0000
Message-ID: <0D8F4CAC0F9D3C4AACC63F50FD9957F763007975_at_PRDTXWPEMLMB32.prod-am.ameritrade.com>

I'm trying to run xbi on a sql id coming from a batch job. They've added the gather statistics hint so I should be able to see estimated vs. actual rows.

However the query runs for about 5 hours (showing in v$sql the whole time) but as soon as it completes it vanishes from v$sql and therefore xbi returns no data.

Does anyone have any suggestions on how to prevent this from happening? Google has been no help for the last 20 minutes of searching.

There is no minimum shared_pool parameter set, sga_target is 64G

Thank you!

Jay Miller
Sr. Oracle DBA

Received on Fri May 15 2020 - 19:48:15 CEST

Original text of this message