Asif Momen

Subscribe to Asif Momen feed
Views expressed here are solely that of my own. Please make sure that you test the code/queries that appear on my blog before applying them to the production environment.
Updated: 2 hours 51 min ago


Tue, 2012-09-25 06:39
PARALLEL_MIN_TIME_THRESHOLD initialization parameter controls which statements are candidate for parallelism. 

As per MOS, this parameter is set to 10 seconds while Oracle documentation claims that it is set to 30 seconds. Now who's correct ??? Seems like it's a documentation bug.

Below are the links to both Oracle documentation and MOS article:

Speaking at Oracle OpenWorld 2012

Mon, 2012-09-24 07:59
Well, it's time for Oracle OpenWorld again. This is the place to meet & learn from the industry experts. Glad I am making this year. 

This year I will be speaking on my experiences managing Very Large Databases. Following are the details of my session.

Session ID: UGF3662
Session Title: Very Large Databases: Challenges and Opportunities
Venue / Room: Moscone West - 2000
Date and Time: 9/30/12, 10:00 - 11:00

These are the activities on my OOW to-do list:

1) Attend lots of sessions
2) Oracle ACE dinner
3) Blogger meetup
4) Oaktable World

I’m looking forward to seeing you in San Francisco!

Win A Free Copy of Packt's Oracle Database XE 11gR2 Jump Start Guide eBook

Mon, 2012-08-13 02:00

I am pleased to announce that Packt Publishing is organizing a giveaway especially for you. All you need to do is just comment below the post and win a free copy of Oracle Database XE 11gR2 Jump Start Guide. Two lucky winners stand a chance to win an e-copy of the book. Keep reading to find out how you can be one of the Lucky One.

Overview of Oracle Database XE 11gR2 Jump Start Guide eBook
Build and manage the Oracle Database 11gR2 XE environment with this fast paced, practical guide. The book helps beginners to install, administer, maintain, tune, backup and upgrade the Oracle Database Express Edition.

Read more about this book and download free Sample Chapter:

How to Enter?

All you need to do is head on over to this page and look through the product description of this book and drop a line via the comments below to let us know what interests you the most about these books. It’s that simple.


The contest will close on 26-AUG-2012. Winners will be contacted by email, so be sure to use your real email address when you comment!

All the best !!!

Book Released: "Oracle Database XE 11gR2 Jump Start Guide"

Thu, 2012-08-02 08:59

I am pleased to announce my first book "Oracle Database XE 11gR2 Jump Start Guide" published by Packt Publishers. The book is available in two formats "Print Book" and "ebook".  

Please let your friends and colleagues know about the book. Have a look at the contents by following the below link:

The book is available for purchase from the publishers website ( and other leading consumer websites like Amazon, Barnes and Nobles, Waterstones etc. 

Thanks to all my readers who have encouraged me to write this book. 

Oracle Database 12c - New Feature: Identity Columns

Wed, 2012-07-25 05:20

Well, Oracle Database 12c is not yet available but new features seems to be popping out in MOS. While troubleshooting Oracle Enterprise Manager Cloud Control 12c startup issues I came across Oracle Database 12c new feature called “Identity Columns”.

An Identity Columns is auto-incremented at the time of insertion just like in SQL Server. Going forward, I think you will not use Oracle Sequence anymore to generate unique values instead use Identity Columns.

For more information on this read:

Happy reading!!!