December 2009 Blog Posts (11)

No Test --> Emergency Response

Last Week, i have work a week-end to resolve a current situation in extended cluster, a

de-synchronisation between disks of a disk group. On this site, the installation is CRS version, ASM, DB

The DBA knew this situation in cluster 10.2 with Database 10.2. and they don't have tested this situation after the 11g migration.

Or they is a BUG : 7311909 .

A test before the start of production would avoid 1 day of downtime for several hundred… Continue

Added by Pierre BOIZOT on December 23, 2009 at 12:06pm — No Comments

Oracle EDI-Techno-Functional Consultant @ Redmond,WA


LOCATION: Redmond,Wa

DURATION - 4+ months

START DATE - As early as 4-Jan-10

Strong techno functional EDI consultant (Senior Functional Consultant) to help design and map Out bound PO (850), PO Change Order(860) to suppliers, Inbound ASN(856) from suppliers and the corresponding acknowledgements with Oracle Applications 11.5.10


Must have… Continue

Added by mohanrao on December 21, 2009 at 10:12am — No Comments

viva las vegas

viva las vegas!

Added by Allan Farias on December 15, 2009 at 8:09am — No Comments

knowledge sharing initiative from

knowledge sharing initiative from

Index Hints

What is index hint and what hint is not

Index hint is suggestion to optimizer not a command to it. If u provide hint it doesn’t h=mean that it will definitely get used . this decision is taken care by Optimizer itself.

Specifying index:

Select /*+FULL(table_name) */ col1 ,col2

From ….

Using Index hints:

1 ) using CHOOSE… Continue

Added by http://linux-oracle-dba.blogspot on December 11, 2009 at 2:57am — No Comments

Can't recompile stored procedure + high library cache pin

On OLTP database or ..., You may get some request from developer...

"Help me! I recompiled package and it's waited a long time".

When you check your database, you'll see high "library cache pin" event on "Concurrency" wait class

Sure... before you recompile that stored procedure, you should close applications what call it. (that can help no that stored procedure pin on library cache)

However, that stored procedure may pin on library cache anyway. that make you… Continue

Added by Surachart Opun on December 10, 2009 at 12:28pm — No Comments

Explain plan

What is SQL–PLAN

The EXPLAIN PLAN shows execution plans chosen by the Oracle optimizer for SELECT, UPDATE, INSERT, and DELETE statements.

It’s a is the sequence of operations performed by Oracle to run the statement.

How Execution Plans Can… Continue

Added by http://linux-oracle-dba.blogspot on December 10, 2009 at 10:30am — No Comments

Overview and Requirements for Oracle RAC Part 2

Preinstallation tasks :

I n this chapter we will see how to check system requirement s are ready / complete to install clusterware and Oracle Application Cluster.

What is CVU (Cluster Varification Utility)

CVU used to perform system checks before starting Clusterware and Oracle Real Application installation.

Syntax for CVU

$ /mountpoint/crs/Disk1/cluvfy/ options

read more here :… Continue

Added by http://linux-oracle-dba.blogspot on December 10, 2009 at 2:01am — 1 Comment

oracle coaching centre in vadodara,gujarat.

Now,.....Oracle 10g DBA Training On Unix Available Vadodara.

Myself OCP Certified Oracle DBA , I am having 4 Years CORE DBA Experience and Currently working in well known MNC in London.

I am coming vadodara for few months. and want to offer tuition in Oracle 10g.

In real time 95% Oracle database run on Unix Operating system.

And mostly no one offer Oracle training On Unix in all over Gujarat .

Think !!!

Course content having motley all… Continue

Added by Hemesh Patel on December 9, 2009 at 5:05am — No Comments

Oracle Coaching Centers in Pune

Hello friends.I want to build a carrier in Oracle.Can anyone guide me and let me know some of the coaching centers in pune where i can learn about Oracle and complete certification as well.

Added by Swapnil Dere on December 8, 2009 at 10:00pm — 2 Comments

Monthly Archives











Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins



Blog Posts

Streamline Your Business Process with Real Estate Data Entry Services

People in the real estate business have to deal with huge volumes of data on a regular basis. It includes the data that is generated from legal documents, property valuation statements, latest commercial and non-commercial property information, etc. This database should be regularly updated and processed properly to help you in your business procedures. With access to relevant real-time data, your business organization can thrive in the commercial real estate market. In…


Posted by Alvaro Dee on March 27, 2017 at 2:48am

Augment the Speed and Efficiency of Website Development with Joomla

Over the past few years, Joomla has emerged out as one of the greatest platforms for designing, developing, and deploying websites and web applications worldwide. Joomla scales up extremely well, uses less memory and gives a brilliant performance. Hire skilled and experienced Joomla developers to use Joomla CMS for developing simple and complex corporate websites. You can even enhance the functioning of your existing website by using this open source platform.

By outsourcing Joomla…


Posted by Alvaro Dee on March 20, 2017 at 4:00am

Top 10 Interview Questions & Answers for Java Developers

An organization hiring a Java developer is looking for someone who can code the applications flawlessly. For the period after Java training, the following is a very important list of ten Java interview questions. Make sure you tap the benefits of this comprehensive list of questions shared by our Java counterparts to crack your next interview.

1. What is immutable…


Posted by Michael Warne on March 17, 2017 at 3:00am

Get the Best Website for Your Business in a Set Time Frame

If you sell products online, you must be knowing how time-consuming and mundane it is to upload products. There are chances of you looking for someone to handle your product data entry tasks. A company that has a wealth of experience and is known for providing its customers with data entry services for a variety of eCommerce solutions can deal efficiently with high volumes of work without any hassle.…


Posted by Alvaro Dee on March 17, 2017 at 2:47am

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service