Database - RAC/Scalability (MOSC)

MOSC Banner

In 11gr2 RAC how does a select query fails over to other node

edited Jul 5, 2015 10:00AM in Database - RAC/Scalability (MOSC) 1 commentAnswered

Suppose we have a two node 11gr2 RAC,I am connected to node 1 and trying to run a select which would return me 1000 rows,while this query was still running, node 1 went down (Assume it has fetched 900 records).

Now ideally the select will be switched and will be running from node 2 to fetch remaining 100 records.

How does the two node co-ordinate this part,Which process comes in to picture for this select statement

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