About Us

Pavan Kumar N

7 August, 2009 at 9:14 am

Hi,

Nice to see you in oracle forums.,, 🙂
Nice blog tooo..

Amit

8 August, 2009 at 8:13 pm

Thanks Pavan for visiting 🙂

Reply

Ajit

24 April, 2010 at 2:53 pm

Dear Amit & Saurabh,

Came across your blog by sheer accident; via a Google search with different search parameters and ordering.

Here is my question:

We have a production environment – SUN V445 with dual SPARC processors; 6 GB memory and a SUN 2540 diskarray. We are having the SUN Java System Application Server Enterprise Edition 8. 2 and Oracle 9i R2.

Is there a realtionship between a high run queue in Solaris and a high DB connections in the App Server? Is there any effect by a JDBC – ODBC connection on these two parameters: one or two clients in the network make calls to a PC to obtain data.

Amit

25 April, 2010 at 10:52 am

Hi Ajit,

I dont think high DB connections will lead to high run queue. Only when process is using CPU, it would be on a run queue. Check if you can co-relate the OS top process and wait events for sessions in Db (use OS process id and spid from V$process), and look for wait events and also see their execution plan.

cheers
Amit

Reply

Ritzy

22 August, 2010 at 12:38 pm

Hey Amit,

Nice to see you active in blogosphere.

Regards

Ritesh

Amit

22 August, 2010 at 12:45 pm

Thanks Ritesh 🙂 Added your oracle blog to my blogroll..

Regards
Amit

Reply
- Ritzy
  
  22 August, 2010 at 12:49 pm
  
  I’m honoured:)
  I have to say that unlike most of the other Oracle blogs sites, this one is really really very neatly organized. Kudos to you and your friends who have set this up.
  
  Reply

Gavin

18 April, 2011 at 10:23 am

Hi – was wondering if you would like me to add your website as a link from my website http://www.gavinsoorma.com – do let me know – cheers – regards – Gavin