In our company we use oracle SQL to manage the database and through it we create queries to show the information in tableau reports.
We are currently facing challenges where some reports consume a lot of memory or CPU; is there a way to know what these queries are?
Yes, you can see those queries in the top database statements, where you can see a lot of metrics about these requests
see the documentation here