Need to analyze Top Query and its VIEW , rewrite/tune as needed to enhance performance.
Need to study AWR report section and adivse tuning suggestions.
You can check the thread on oracle community for complete understanding of the issue and provide resolution.
[login to view URL]
Bu iş için 10 freelancer ortalamada ₹1315 teklif veriyor
Share the index details on the table along with total no of records of each table and group by depid and creationdate also Relevant Skills and Experience I have 14 years experience in oracle and oracle apps developmen Daha Fazla
I have extensive knowledge of database queries and design. Over 12 years of experience in Oracle and cloud technologies.