Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Which statistic in the V$PQ_SYSSTAT data dictionary view indicates the number of parallel DML statements currently active?

April 26, 2017Data dictionary DML indicates parallel statements statistic view

0

Posted

Which statistic in the V$PQ_SYSSTAT data dictionary view indicates the number of parallel DML statements currently active?

1 Answer

0

Posted

DML Initiated SQL> select * from v$pq_sysstat; STATISTIC VALUE —————————— ——— Servers Busy 0 Servers Idle 0 Servers Highwater 0 Server Sessions 0 Servers Started 0 Servers Shutdown 0 Servers Cleaned Up 0 Queries Initiated 0 DML Initiated 0 DFO Trees 0 Sessions Active 0 Local Msgs Sent 0 Distr Msgs Sent 0 Local Msgs Recv’d 0 Distr Msgs Recv’d 0