Tagged Questions
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
751 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
810 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
1answer
543 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 ...
