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]

Unix

We intend to keep this page as easy reference for Unix commands/links which are useful to DBA in day – day work.  If you too have some command’s which can be useful , then you can use the comment’s section to add it and we will include in main page after cross-checking it. In case there are any corrections, then also let us know.

These commands have been categorised into sub-pages such as AIX, Solaris, Linux and HP-UX.

Generic

Awk Tutorial – http://www.vectorsite.net/tsawk.html

Sed & Awk (Oreilly ebook) – http://docstore.mik.ua/orelly/unix/sedawk/index.htm

Blog Articles

Share

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