Oracle Real Application Clusters (RAC) is an option for Oracle Databases. It is a cluster database with a shared cache architecture that increases scalability and availability. Oracle RAC support is included in the Oracle Database Standard Edition and is an extra cost option for Enterprise Edition.
7
votes
4answers
2k views
SQL Server equivalent to functionality of Oracle RAC?
I did some Googling and couldn't find an answer to this question more recent than a few years ago, so I thought I'd ask. Oracle's RAC feature offers load-balancing for both read and write ...
1
vote
1answer
97 views
Specify Server for DBMS_Scheduler Job in Policy Managed RAC
A unit test requires a dbms_scheduler job to run on the same RAC node as the unit test is being run from. I know that with an Admin managed database this could be done by creating a service that ...
1
vote
2answers
752 views
Oracle RAC with single node Data Guard physical standby
Best practices for Oracle 11gR2 Data Guard implies that the primary and standby databases should have the same layout, eg. RAC to RAC.
What special considerations would one need to take into account ...
1
vote
2answers
813 views
How high can I set undo retention on Oracle 11gR2
Is it viable to set a very high undo retention, as to allow flashback queries several weeks back in time?
Naturally, enough space must be available in the undo tablespaces to contain the amount of ...
2
votes
2answers
245 views
Oracle Enterprise Manager Jobs Failing Initialization
The Enterprise Manager jobs on our RAC system recently started intermittently failing initialization with the following error:
Error evaluating parameter sources/security checks/locks ORA-06508:
...
2
votes
1answer
545 views
Differing results from gv$session
The following query returns no results, yet it seems like it should.
SELECT * FROM gv$session where SID = SYS_CONTEXT('USERENV','SID');
In my 11.2.0.2 Standard Edition RAC environment the above ...
2
votes
1answer
2k views
