About Us

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

11 Responses

  1. Pavan Kumar N says:
    7 August, 2009 at 9:14 am

    Hi,

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

    Reply
  2. Ajit says:
    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.

    Reply
    • Amit says:
      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
  3. Ritzy says:
    22 August, 2010 at 12:38 pm

    Hey Amit,

    Nice to see you active in blogosphere.

    Regards

    Ritesh

    Reply
  4. Gavin says:
    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

    Reply
  5. Saurabh Gupta says:
    6 April, 2012 at 5:18 pm

    Hi AskDba team,

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

    Saurabh
    sbhoracle.wordpress.com

    Reply
  6. Saurabh Sood says:
    15 April, 2012 at 11:15 am

    Thanks Saurabh..

    Reply

Leave a Reply

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

Disclaimer!!

This blog reflect our own views and do not necessarily represent the views of our current or previous employers.

The contents of this blog are from our experience, you may use at your own risk, however you are strongly advised to cross reference with Product documentation and test before deploying to production environments.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 188 other subscribers