Pergunta de entrevista da empresa Capgemini

How to create a view to see the ongoing processes / queries in the db server?