Home » RDBMS Server » Server Administration » Oracle 10g server went in hanging condition (Oracle 10g,10.2.0,windows server 2008 enterprise)
Oracle 10g server went in hanging condition [message #554863] Fri, 18 May 2012 01:31 Go to next message
zahidbutt
Messages: 13
Registered: January 2011
Location: Lahore
Junior Member
Dear Experts,

I am new in field of administration.
Sometimes our db server goes in hanging condition. It does not save any transaction & user waits for long. When I restart, it starts working fine.

What should I do, I mean regarding diagnosis & performance tuning.

Thanks in advance.
Re: Oracle 10g server went in hanging condition [message #554864 is a reply to message #554863] Fri, 18 May 2012 01:57 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How to Identify Performance Problem and Bottleneck
OraFAQ Oracle SQL Tuning Guide
Database Performance Tuning Guide

Regards
Michel
Previous Topic: What actually by default BLOB siz indicating. [merged 4 by jd]
Next Topic: EXTENT MANAGEMENT LOCAL AUTOALLOCATE
Goto Forum:
  


Current Time: Thu Mar 28 06:45:52 CDT 2024