Re: Oracle/Solaris
Date: Wed, 14 Sep 2011 07:08:06 -0700 (PDT)
Message-ID: <1316009286.22653.YahooMailNeo_at_web161209.mail.bf1.yahoo.com>
Rodd
I tried with regular file system. This also happen when lots other command is slow and not with ls only. Even running Top command takes forever to come while uptime works fine. sar -u also works fine. So there is something associated for some command which need some extra resource (Not sure what like ls -ltr vs ls or grep) are very slow and so attribute to outside application connection to Database freezing.
SA pointing everything to Oracle as there are more that 2000 Oracle Connection which anyway stays when everythig is running fine also during other part of the day.
Sanjay
From: Rodd Holman <rodd.holman_at_gmail.com> To: oracle-l_at_freelists.org
Sent: Wednesday, September 14, 2011 9:39 AM Subject: Re: Oracle/Solaris
What file system are you using? Could it be something in the zfs indexing. Since a standard ls works, and smaller directories work for sorted output, this sounds more like journaling or indexing. I'm not an SA, so there may be more technical ways to say this, but have them look at your file system settings and the indexing and journaling parameters on the server.
On 09/14/2011 08:30 AM, Sanjay Mishra wrote:
> Hemant
>
> Surely something is there on OS side. Did found few things like
> - If I am doing ls command in the directory with any number of files, it worked
> - If ls -ltr is done in the same directory , it hust hanged
> - If removed the file to around 100 files in the directory , then ls -ltr worked fast
>
> Also any other command which is linke finding or grepping is hanging including top
>
> CPU is surely not issue. Very strange situation. Yes it affect the application new connection. Will monitor the number of process today along with who owns them. This problem occured only some peak time and so surely have some link with Foring process or some swap or. There is plenty of Swap and TEMP space in Gigabytes
>
>
> From: "Chitale, Hemant Krishnarao"<Hemant.Chitale_at_sc.com>
> To: smishra_97_at_yahoo.com
> Cc: oracle-l_at_freelists.org
> Sent: Tuesday, September 13, 2011 11:34 PM
> Subject: RE: Oracle/Solaris
>
>
> It seems as if Solaris is unable to fork new processes.
> It could either be hitting process limits (global or *per user*) or it could be hitting limits with swap allocation for the processes.
> Can't recall what the Solaris parameters for this would be.
>
> Hemant K Chitale
>
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 14 2011 - 09:08:06 CDT