Identifying Single-AMP and All-AMP queries

Database
Enthusiast

Identifying Single-AMP and All-AMP queries

Is  there any way we can trace if a query executed is  a Single-AMP or Multi-AMP request other than explain plan or execution plan?Is this info stored in DBC tables?

Tags (2)
1 REPLY
Enthusiast

Re: Identifying Single-AMP and All-AMP queries

Hi

You can refer DBQLogTbl and DBQLStepTbl with QueryID and ActiveNumofAMP to find the desired result.

Santanu