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