Blog Contributors


View amit bansal's profile on LinkedIn

Amit Bansal |Database Consultant| Data and Analytics




View Saurabh Sood's LinkedIn Profile

Saurabh Sood | Database Consultant | Embarking journey to Devops & Cloud computing

This Post Has 11 Comments

  1. Pavan Kumar N


    Nice to see you in oracle forums.,, ๐Ÿ™‚
    Nice blog tooo..

    1. Amit

      Thanks Pavan for visiting ๐Ÿ™‚

  2. Ajit

    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.

    1. Amit

      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.


  3. Ritzy

    Hey Amit,

    Nice to see you active in blogosphere.



    1. Amit

      Thanks Ritesh ๐Ÿ™‚ Added your oracle blog to my blogroll..


      1. Ritzy

        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.

  4. Gavin

    Hi – was wondering if you would like me to add your website as a link from my website – do let me know – cheers – regards – Gavin

    1. Saurabh Sood

      Thanks Gavin, you can add our website as a link..


  5. Saurabh Gupta

    Hi AskDba team,

    Nice efforts to make askdba a very useful site for Oracle professionals


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.