Database Tuning (MOSC)

MOSC Banner

Excess user IO with SQL statement

edited Jun 6, 2020 5:00AM in Database Tuning (MOSC) 2 commentsAnswered
This SQL with PARALLEL option is querying a partitioned (by year) table of 56million records (size 32GB). The explain plan suggest that it is doing FULL TABLE SCAN twice. It has got UNION ALL, aggregate functions etc. The db version is 11.2.0.1.0. I have very little knowledge about data. I am having issue with grid control not able to run SQL Tuning Advisor. It is returns an error "ORA-13767-End snapshot ID must be greater than begin snapshot ID".
How can i start troubleshooting this issue. Any thoughts?
Thanks in advance.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center