Writing About Our Experiences With Oracle Databases
Sunday February 5th 2012

Latest Topics

11gR2:Listener Startup Issues

In this blog post I will be discussing listener startup issues faced in 11gR2 RAC. I will be constantly updating this [Read More]

Get Upgrading: Upgrade to Enterprise Manager Cloud Control 12c

Get Upgrading: Upgrade to Enterprise Manager Cloud Control 12c

This post describes the steps to upgrade an existing 11g Enterprise Manager Grid Control (11.1.0.1.0) to 12c [Read More]

Cluster SSH tool Utility

Cluster SSH tool Utility

Many times you come across scenario’s when you wish to open multiple ssh windows and execute same commands.e.g [Read More]

11g: Multiple failed login attempt can block New Application connections

In Oracle database 11g, a new feature/enhancement has potential of bringing down the application due to multiple [Read More]

Optimizer Choosing Nested-Loop Joins Instead of Hash-Joins

In one of my databases, one application query suddenly started to pick Nested-Loop joins instead of Hash-Joins and took [Read More]

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

View Saurabh Sood's profile on LinkedIn

Saurabh Sood has 6+ years experience as an Oracle DBA. Currently he is working as DBA Advisor @ Dell Services . Prior to it he has also worked for Oracle Consulting and Oracle Support for 4 years. Hands on experience with Oracle Database 8i/9i/10g in critical production/development environments.

 

Abhishek Bhargava has 6+ years of IT experience with exposure in domains like Oracle Database Administration, System Administration, Implementation and Enterprise Product Support. Current working with Yahoo SDC, India

 

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

Share

9 Comments for “About Us”

  • Pavan Kumar N says:

    Hi,

    Nice to see you in oracle forums.,, :-)
    Nice blog tooo..

  • Ajit says:

    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 says:

      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

  • Ritzy says:

    Hey Amit,

    Nice to see you active in blogosphere.

    Regards

    Ritesh

  • Gavin says:

    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


Leave a Comment

*

Recent Comments

Saurabh Sood had this to say

Hi Pawan, We cannot force the writes to a specific disk. At least I am not aware of any such thing. Oracle will Read the post

Amit had this to say

hi Pawan, ASM_PREFERRED_READ_FAILURE_GROUPS is mainly used for RAC instances and that too stretch clusters i.e when Read the post

PAWAN had this to say

HI, i am newbie.... please guide me! My manager asked me to configure ASM in 11g with single instance Read the post

PAWAN had this to say

HI, i am newbie.... please guide me! My manager asked me to configure ASM in 11g with single instance Read the post

Saurabh Sood had this to say

@Ganesh: The global stats were up-to-date for both the databases, though I did not check the col stats. But the Read the post