Just add Thread.sleep(2000000) to your java code. It wouldn't need all this time (this is in ms). You should see a stuck thread after 10 mins.I'm a beginner DBA, also am only little aware of writing java code. In which type of file i have to write this code.
The one I sent to you previously is the simplest. You can create a servlet, add the Thread.sleep, deploy and the job is done.creating a servlet means is it so I have to write a code in web.xml or .jsp. Is my understanding correct?
As you are a DBA, you should be familiar with stored procedures and this might be easier for you.Let me try this store procedure and inform you. How do i invoke this from Weblogic?
In order to keep it simple, so you can achieve your goal, you can introduce the delay in a stored procedure and invoke it from Weblogic.
In the stored procedure, you can add the following to introduce the sleep (this is a 20 minutes sleep): DBMS_LOCK.sleep(1200);