DBMS Scheduler issue on RAC
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;
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;
0