Database - RAC/Scalability (MOSC)

MOSC Banner

If you go to Oracle 12c - Watch out for frjd8zfy2jfdq

edited Nov 28, 2016 9:44AM in Database - RAC/Scalability (MOSC) 2 comments

If you go to Oracle 12c, be sure to watch out for SQL_ID: frjd8zfy2jfdq. There are plenty of articles on this, including one from BPeaslandDBA (I believe that's his article).  During 2016 holiday (today), I was monitoring one particular system where the app team stated the performance was degrading. Other than extremely high version counts and parsing issues caused by multiple PDBs using similar SQL (which is another problem that is still trying to be figured out by the powers-that-be at Oracle), there was one query executing with SQL_ID: frjd8zfy2jfdq. The query looked like:

SELECT executions, end_of_fetch_count,              elapsed_time/px_servers

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