Explain your process for diagnosing a significant latency issue in an Oracle environment for Everest Consultants clients.