Database - RAC/Scalability (MOSC)

MOSC Banner

DBMS Scheduler issue on RAC

edited Jul 24, 2012 2:27AM in Database - RAC/Scalability (MOSC) 1 commentAnswered ✓
Hi,

DB: 11.2.0.3
OS: HP-UX
RAC: Two Node RAC.

I am testing the dbms_scheudular job on RAC databases and found some unexpected issue on node 2...

Here is my test case...

{

# I have created one procedure and insert into temp table on every 60 second parallel. because i have given sleep time 60 seconds...

Create or Replace Procedure pr_sch_testing (p_jnum Number)
Is
l_num Number := 0;
l_cnt Number := 0;
Begin
Begin
Select max(intg_number)
into l_num
From temp_123
Where job_number = p_jnum;
Exception
When Others
Then
l_num := 0;
End;
Loop
l_cnt := l_cnt +1;
l_num := l_num+1;

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center