Skip to main content
Question

Can we identified purge,analyze_statisitics or similar query run on which pool?

  • October 22, 2019
  • 3 replies
  • 14 views

hsaxena20
Forum|alt.badge.img+1

Can we identified purge,analyze_statisitics or similar query run on which pool?

3 replies

mosheg
Forum|alt.badge.img+2
  • Participating Frequently
  • October 22, 2019

Try something like this if you know the transaction_id and statement_id:
select resource_pool from query_consumption
where
transaction_id = 72057594230919944 and statement_id = 1;

Or this if you don't:
select resource_pool from query_consumption
where
label = 'xyz';


hsaxena20
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • October 23, 2019

I am using a 9.0.1 version. query_consumption table is not present.


Nimmi_gupta
Forum|alt.badge.img
  • Participating Frequently
  • November 6, 2019

It's from TM (Tuple Mover) pool. Try the below query
select * from system_services;