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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: