Re: OracleProcsses hung on AIX

On 06/11/2004 01:26:49 AM, Seema Singh wrote:
> hi,
> I have Oracle817 running on RS/6000 AIX server.Since couple days whenever
> one query run the databse get hunged.The table is having couple of joins and
> high rows.Any thoughts on?
> thx
> -seema

Well hung AIX system can bring a lot of joy to the users. Now that I've blurted that, define "hung". Is it spending CPU? Is it waiting? What is it waiting for? Can you connect to the database? Anything in the log file? Are there any trace files? I must admit that the thought of well hung AIX systems doing joins is rather provocative, but the posts on this list should be rated "G" for General Audience. I believe that we're in the PG-13 zone right now.

-- 
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------