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

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

Saurabh Sood has 4+ years experience as an Oracle DBA.Currently he is working as Database consultant with Oracle Consulting OSSI . Prior to it he has also worked for Oracle Support (India Support Center) in Server Technologies Group for 2 years. Hands on experience with Oracle Database 8i/9i/10g , OPS, ASM, RAC , DataGuard , DataVault, NLS and Implementing Oracle Security.

LeoSanil has been working as Oracle DBA for more then 3 years.

4 Comments for “About Us”

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

Hi,

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

Reply
- Amit says:
  August 8, 2009 at 8:13 pm
  
  Thanks Pavan for visiting
  
  Reply
Ajit says:
April 24, 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:
  April 25, 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