GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  Scenarios
Go To First  |  Previous Question  |  Next Question 
 Scenarios  |  Question 10 of 25    Print  
All the users are complaining that their application is hanging. How you will resolve this situation in OLTP

  
Total Answers and Comments: 5 Last Update: May 27, 2008   
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: ganesh parab
 
By increasing memory to process simutanous access.

Above answer was rated as good by the following members:
mamamami, pradyumnah
August 17, 2005 02:11:25   #1  
ganesh parab        

RE: All the users are complaining that their application is hanging. How you will resolve this situation...
By increasing memory to process simutanous access.
 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
April 30, 2006 12:23:13   #2  
pandish Member Since: April 2006   Contribution: 7    

RE: All the users are complaining that their applicati...
it may be one of the solution. You gotta check the alert logs & see exactly what it the reason for hanging the database.
 
Is this answer useful? Yes | NoAnswer is useful 0   Answer is not useful 1Overall Rating: -1    
July 07, 2006 10:55:37   #3  
Ritesh Singh        

RE: All the users are complaining that their applicati...

If the user is complaining the hang problem ..then the experience of a dba reflects the work style that he is going to perform and basically as the rule suggest first try to connect to the database itself and fire some query to check whethere you are allowed to connect or not if you are connected then check for any locked_objects by checking v$locked_object and dba_waiters and dba_blockers.then you have to eliminate the things which are working properly and targetting yourself to the weaker place and then check at os level that which process is consuming the most of the time and then analyze the problem if the problem relates to a single user process then check what that user is doing by checking the sql statement he is firing.than so on


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
March 30, 2007 18:44:51   #4  
Chiranjeevi Manne        

RE: All the users are complaining that their applicati...
1. Check whether the execution plan of various SQL statements have been changed which may happen due to Bulk inserts and updates.
2. Try to gather statistics on regular basis.
3. Check the server side resources using top vmstat iostat sar utilities.
4. Check the storage side
5. Check the network side

 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
May 27, 2008 05:30:46   #5  
singh.neerajin Member Since: May 2008   Contribution: 4    

RE: All the users are complaining that their application is hanging. How you will resolve this situation in OLTP

If problem is pertaining to database & a user dont have acess to database level . One can check the process ( taking long time ) through the enterprise manager.


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape