On the same lines...are you auditing and filled the audit tablespace? ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Rajeev Prabhakar Sent: Tuesday, May 19, 2009 10:57 AM To: saad4u@xxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: Oracle 10g hangs ...earlier running smoothly Hello Saad, If the adjusting permissions is not very helpful, could you check if the free space on the filesystem is not the issue. I vaguely remember having encountered this (low space on either home directory of the oracle id, ORACLE_HOME directory OR dest directories for udump/bdump) a while back and preventing sqlplus connections. Does the alert log show anything ? -Rajeev On Tue, May 19, 2009 at 10:43 AM, Saad Khan <saad4u@xxxxxxxxx<mailto:saad4u@xxxxxxxxx>> wrote: Good Morning fellows, Thanks. Sid