We have 40 million data in S3 and while inserting data from S3 to oracle table the sessions are stuck and showing library cache: mutex X wait events.
What all enhancements can be done to improve performance.
We have partitioned the data and still facing the issue.
New contributor
user26673195 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.