About Us

We are group of professionals who have expertise in Oracle Databases in areas such as RAC, RMAN, ASM,Dataguard, Performance tuning, Security and Oracle Internals.We would like to use this platform to share our ideas with Oracle community and also learn new things with Technical discussions arising out of the content posted on this blog.

Blog Contributors

 

View amit bansal's profile on LinkedIn

Amit Bansal has 14+ years of IT experience . He has experience of working in both Production and Development environments with Oracle 8i/9i/10g/11g Databases, PostgreSQL,MySQL. This  includes 3 years stint with Oracle Support (India Support Center) and Oracle Consulting(OSSI). Currently working with Amazon Hyderabad,India.

View Saurabh Sood's profile on LinkedIn

Saurabh Sood | Database Consultant | Ex-Oracle |14 years Work Exp.| Currently spending my time on exploring SQL Server and AWS. 

11 thoughts on “About Us

  1. 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.

    • 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

Leave a Reply

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