Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

User_KWXZ9Jun 20 2013 — edited Jun 20 2013

Hi All ,

I am using oracle 11.2.0.3 with 3 node rac with ODI .

I have the below table which i am not able to drop  and giving the error .

SQL> drop table I$_CDS_FAULT_DEV1;

drop table I$_CDS_FAULT_DEV1

           *

ERROR at line 1:

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

SQL> show parameter ddl_lock

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

ddl_lock_timeout                     integer     300

i changed to 100 but still the same error also i have checked and there are no locks . Can you please provide me a way to resolve this issue .

Regards ,

DBApps

This post has been answered by unknown-698157 on Jun 20 2013
Jump to Answer

Comments

TPD-Opitz

b84d6217-63ff-4b01-ac20-dedb366b9b09 wrote:

Hi guys,

I have a simple doubt. I was studying and create some code to check the result and I found out a strange situation.

since you postsd uncompilable code we cannot tell what's really goning on in your example. please always post an SSCCE. http://sscce.org

Whats wrong with this code? Why it does not print anything?

char = 0; //integer value

System.out.println( c +" String ");

You ran in the beginners trap of not distinguishing between numbers as they are used by the Computer and human readable characters.

Java converts numbers to human readable characters when ever it can. But when you declare a variable of type char than you are telling the JVM you want to do this conversion yourself.

According to the ASCII Standard the decimal value 0 is a non printable character.

and why this next works very well?

char = 1; //integer value

System.out.println( c +" String ");

this is also "not working".  depending on the terminal you use you may get something to see but according to the ASCII Standard it should also not print to Screen.

I know that char is stored as a positive integer and assign with 0 is different of assign with '0'.

But you are not Aware that

char c;

is different from

int c;

public class CharPlusStringTest {

@Test
public void test0() {
  char c= 0; //integer value
  System.out.println( ">"+c +"< String ");
}

@Test
public void test1() {
  char c= 1; //integer value
  System.out.println( ">"+c +"< String ");
}

@Test
public void test3() {
  int c= 1; //integer value
  System.out.println( ">"+c +"< String ");
}
}

bye

TPD

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 18 2013
Added on Jun 20 2013
4 comments
79,885 views