all queries and jobs and oozie dashboard loading slow

[#1]

Our servers have enough unused CPU and memory. However, hue dashboard to list oozie workflows is taking over 5-10 minutes. Queries that take 5-6 minutes are taking 3-4 hours. What could be wrong? How do I debug this issue?

[#2]

What kind of queries are we talking about? Impala, Hive or others? It really depends on what they are, and there are different things to look out for.

Regarding Hue Oozie dashboard slow, have you tried to check Hue server log and DB performance?