Why is sqlplus not responding sometimes? 
Author Message
 Why is sqlplus not responding sometimes?
sometimes sqlplus stops responding to certain commands.

Usually it comes back after a while. On certain commands it just
blocks and I have to cancel them to regain control. Often simple
select queries works but delete, drop and insert seems to give
this halt phenomenon. Any suggestions?

/Kalle W

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

Got questions?  Get answers over the phone at Keen.com.
Up to 100 minutes free!
http://www.***.com/



Wed, 18 Jun 1902 08:00:00 GMT
 Why is sqlplus not responding sometimes?

Quote:

>sometimes sqlplus stops responding to certain commands.

>Usually it comes back after a while. On certain commands it just
>blocks and I have to cancel them to regain control. Often simple
>select queries works but delete, drop and insert seems to give
>this halt phenomenon. Any suggestions?

>/Kalle W

Kalle, you need to be more specific about what commands on what
kind of objects are causing a problem.  Do they just take
forever, or are you getting error messages back.

Common cause for problems involving deletes:
1) Deletes are expensive to being with and it will just take
time.  Perhaps a truncate can be used instead.
2) A FK exists on the rows being deleted and cascade deletes are
taking place
3) Triggers exist on the target table causing a cascade effect

Common problem involving drops:
1) Someone analyzed the sys owned objects causing the optimizer
to perform the wrong access plan for dictionary data
2) If it is a table or index the object is large and a lot of
rollback data is being generated.  Truncate the table then drop
it.
3) A log of direct grants were made on the object and Oracle is
having to clean up thousands of these entries.  Create a role,
do the grants to the role and grant the role to the users.

I hope this helps.

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

Got questions?  Get answers over the phone at Keen.com.
Up to 100 minutes free!
http://www.keen.com



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Why are portals sometimes single entry, sometimes multiple?

2. SP sometimes exepts parameters, sometimes not...

3. phantom procedure - mi_prepare() fails sometimes, but sometimes do not

4. sometimes it appends, sometimes not...

5. Why am I not seeing deadlock messages in my Error Log

6. Why Am I Not Releasing Connections???

7. why I am not able to copy db

8. why i am not receiving mails

9. Why my stored procedure to run DTS sometimes works, sometimes not?

10. Why named pipes connect slow and sometimes quick

11. Why does Database/Object Transfer stall out (sometimes)?

12. (ORACLE 7.3.2)Why Listener die on DEC alpha OS 3.2G sometimes


 
Powered by phpBB® Forum Software