March 2011 Blog Posts (14)

Attend4FREE April 2011 Oracle PerfaThon Webinar Series 6 Sessions 6 Experts!

Attend4FREE! "The Oracle 11g PerfaThon - Six Sessions - Six Experts! The Oracle 11g Performance Tuning Event". Event Details:


"The Oracle 11g PerfaThon - Six Sessions - Six Experts"! Learn ALL about Oracle Database Performance Tuning for FREE from the experts at BrainSurface Oracle, Java & MySQL Users Group (BOJMUG).


Note: You…


Added by Tariq Farooq on March 21, 2011 at 12:00pm — No Comments

opportunity for oracle Functional Financials R12 with Vertex


Functional Financials R12 with Vertex

Location: CA

Duration: 6+ months

Rate: open


Need: Strong Functional Vertex resource with Oracle R12 Financials implementation experience.  Hands on vertex experience is required.  Client is a large manufacturing company.





Added by vikram reddy on March 18, 2011 at 7:29am — No Comments

Oracle Database on Amazon RDS

I have captured my thoughts around Oracle's entry into Amazon RDS world. Please read it here.

Please share your thoughts -




Added by Siba Prasad on March 17, 2011 at 5:00am — No Comments

11gR2 ASM – Inside story – Part4 (ASM Preferred Read Failure Group)


In the previous post of “11g ASM – Inside story – Part3″, we have seen how to to create a datapump dumpset within ASM diskgroup.

In this Part4 of the story, we will see how to configure the ASM instance with a list of preferred disk failure group names to use when accessing ASM disks.

This new 11g parameter is really useful especially for Real Application Clusters (RAC) instances on disks miles apart.

You can configure each instance to be able… Continue

Added by Wissem EL KHLIFI on March 11, 2011 at 3:27pm — No Comments

11g ASM – Inside story – Part3 (Export Datapump)


In the previous post of “11gR2 ASM – Inside story – Part2″, we have seen how to restore a diskgroup after a failure.

In this part 3, we will create datapump export dumpsets within ASM diskgroup.

The procedure is valid for 10g Oracle database,

We should follow the steps below:

1- Create a directory from ASM.

2- Create a directory object in the database.

3- Create log file directory. The datapump log file cannot be stored within… Continue

Added by Wissem EL KHLIFI on March 11, 2011 at 3:04pm — No Comments Launches New Website

Technology Certs has launched its new website, at  The significantly redesigned site, personifies the organization’s vision and commitment to affordable, quality IT training. Technology Certs is not new to the IT world, you have seen them before. Their IT training products have been used by companies, individuals and government agencies for years, but they just recently went public with their training, allowing their…


Added by Frederick F Dietz on March 10, 2011 at 10:48am — No Comments

GetPaid2Speak! Call4Papers! No Travel Required! JavOraThon | The online conference for the Oracle, Java & MySQL Communites

Get Paid to Speak! - Call for Papers Deadline: March 31, 2011.

No Travel Required to speak at JavOraThon! Interested in speaking at the largest Online Conference for the Oracle, Java & MySQL Communities? Accepted Speakers will get paid upto a maximum of $5000*. The Speaker Compensation will be based on a factoring model taking into consideration various parameters such as presentation history, popularity…


Added by Tariq Farooq on March 9, 2011 at 11:38am — No Comments

10g vs 11g add a column with not null default value


Prior to Oracle database 11g, adding a new column with a default NOT NULL value were a challenge. Especially, when the concerned table contains thousands or millions of records. Oracle 10g updates ALL the rows of the concerned table with the new default value. In my busy real time OLTP databases, I had to create another intermediate table with the same structure plus the new default not null column. This solution needs a switch to the second table and a…


Added by Wissem EL KHLIFI on March 8, 2011 at 4:24am — No Comments

Edition based redefinition

I have captured my thoughts around "Edition based redefinition" on My blog - here



Added by Siba Prasad on March 8, 2011 at 2:45am — No Comments

11gR2 ASM – Inside story – Part2 (Diskgroup restore)

In the previous post of “11gR2 ASM – Inside story – Part1″, we have seen how to install grid infrastructure for standalone server and how to setup and configure an ASM instance.
In this Part2 of the story, we will see how to restore a diskgroup after a failure.

Read the complete article here:

Added by Wissem EL KHLIFI on March 5, 2011 at 7:41am — No Comments

Tired of the Traditional? The Expense? The Timetable? CareerSaver has a solution

New technology changes the way we learn, for the better

Close your eyes, and picture yourself learning some new kind of new material in a classroom. You hear the endless drone of the instructor, the books and paper sitting in front of you, the fact that no one is really paying attention. This traditional style of learning is what many of us imagine when we think of continuing our education or learning new subject matter.…


Added by Frederick F Dietz on March 3, 2011 at 7:30am — No Comments

Episode Deux - The Oracle 11g RACaThon Online Conference @BrainSurface

Register here:


Learn ALL about Oracle Real Application Clusters (RAC) 11g from the experts! This event is a continuation of the popular "Oracle 11g RACaThon Online Conference Series" including Expert Insight, Tips, Tricks, Interactive Q/A & Interview Questions atBrainSurface | The…


Added by Tariq Farooq on March 2, 2011 at 10:53am — No Comments

Upgrade from 11i to R12.

Hi Guys,


we at our organisation are planning to upgrade our existing Oracle E-Business Suite 11i to R12

however we will be doing this on new hardware, Therefore I request you all to voice in your experience on the same


Do mention the EBS Architecture & Hardware Specs.



Added by Viquar Ahmed Ali on March 2, 2011 at 12:36am — 5 Comments

11gR2 ASM – Inside story – Part1 (including grid infrastructure installation)


This is a series of articles which contains several important enhancements to Automatic Storage Management in Oracle 11gR2.

In this part1, we are going to prepare, install our 11gR2 ASM environment.

In this ASM inside story articles, we are going to use Oracle Linux 5 as the guest operating system, Oracle 11gR2 as database version.

Oracle VirtualBox is our virtualization software.

Oracle Linux Installation

Download and…


Added by Wissem EL KHLIFI on March 1, 2011 at 12:20pm — No Comments

Blog Topics by Tags

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

Verify and Fix Corruption in Oracle Databases, Efficiently

Oracle database system stores massive amounts of data, aiming for secure data storage and management. With a number of predefined queries, this database system lets you insert and retrieve data that is stored in multiple tables inside it. For smoother functioning of a database system and its respective databases, your machine must be free of every single issue that is supposed to cause adverse effects on the data. For…


Posted by Mark Willium on June 3, 2014 at 11:00pm

esProc Enables Oracle JDBC to Speed Up Retrieve Process

Recently, a performance issue occurs in a big detail report, where the original data volume in the two data tables as it involves has exceeded 3 million rows; the data volume that the report can retrieve after filtering remains at round 2 million rows. As we expected before, by using paged retrieve method, this report would present a much higher performance. However, for the fact that the user also needs to…


Posted by Jim King on May 29, 2014 at 7:00am

Oracle DBaaS in Private Database Cloud workshop

Designing Database as a Service (DBaaS) in own Database Cloud is very comprehensive topic and it requires a lot of things: clear concept and strategy, solid planning, important architecture decisions, considerable involvement of different stakeholders, extra budget, etc. To start talking about this topic I’ll give my own definition of DBaaS which is a managed database service, hosted and offered by DBaaS provider on pay-per-usage basis, which provides access to own database resource with…


Posted by Kirill Loifman on May 5, 2014 at 12:37am

© 2014   Created by Steve Karam.

Badges  |  Report an Issue  |  Terms of Service