Posts Tagged ‘Database’


E-Business Suite and Database Parameter Recommendations

September 16th, 2009 by Robert McMillen • No Comments »

I’ve seen several posts recently about changes in the recommended database parameters for use with the E-Business Suite and wanted to pass along this information for your consideration.  In these updates Oracle is recommending that parameters be retired, updated and added.  While the changes might seem minor Oracle is saying that there are significant performance benefits from making them.

For those who are using Release 11i, there is an updated white paper on Oracle Support (216205.1) that provides the latest updates as of August 11th.

The updated white paper for Release 12 (396009.1) was release September 9th.

While I always recommend checking the latest version on Oracle Support (formerly Metalink), I’ve created PDF copies of the white papers for 11i and R12 so that you can download from for your convenience.

Database Initialization Parameters for 11i

Database Initialization Parameters for R12

No Comments »

 

New Release of the Database 11g R2 Now Available

September 10th, 2009 by Robert McMillen • No Comments »

Oracle has just announced availability of a new release of their 11g Database.  This is the second release for 11g and since many customers like to wait for a second release of new products before considering them production-worthy this version is one that many customers will be considering.

Oracle is offering local events around the country where customers can find out more about this new release.  Just follow the links below to register for an event in your area of the country.  Also, if you are going to Open World there will be a number of sessions there on the new release.

Oracle is advertising that this new release will

  • Reduce server costs by a factor of 5
  • Reduce storage requirements by a factor of 12
  • Improve mission critical systems performance by a factor of 10
  • Increase DBA productivity by a factor of 2
  • Eliminate idle redundancy in the data center, and
  • Simplify their overall IT software portfolio.

More overall  information can be found HERE.  The Oracle Technology Network (OTN) information can be found HERE and allows you to download an evaluation version.

The Oracle database continues to be the leading database worldwide.  Gartner’s 2008 Worldwide RDBMS Market Share Report shows Oracle with a 48.9 percent share, and IDC’s 2008 Worldwide Data Warehouse Platform Software 2008 Vendor Shares reports a 40 percent share.

No Comments »

 

What Oracle is Doing Right

August 3rd, 2009 by Robert McMillen • No Comments »

For a change of pace I thought it would be good to  mention a few of the things I think that Oracle is doing right.   Over the last several years I continue to be impressed with what I see coming out of Oracle related to their product directions and new products.  Here’s my take on the things I see Oracle doing right.

The first one I’ll note is that Oracle is doing a great job at maintaining a Leadership Role in software innovation.  It’s obvious if you look at various evaluations such as the “Magic Quadrant” by Gartner that Oracle’s products are consistently in the top right quadrant where market leaders are found.  Here are a few Oracle products that I’ve had the opportunity to work with.

  • E-Business Suite R12 – R12 is more evolutionary than revolutionary but it significantly improves on what was a solid release in 11i by expanding the international capabilities of this massive applications suite.  With over 224 separate modules, R12 is mind-boggling in it’s scope of capabilities.  Oracle gets some dings for the bugs that were found in the first year  but they’ve quickly addressed the core issues in the releases leading up to release 12.1.  While there is an improved user interface the real changes are beneath the surface and which improve the productivity of everyday users.
  • 11g Database – there are many people who are better qualified to speak on this product than I but as one who has been working with the Oracle database since the last legs of version 6 I’m amazed that  Oracle continues to add useful and valuable capabilities to this workhorse of a database system.  In the areas of performance, operating systems supported, scalability and reliability the Oracle database keeps most of the world’s business working smoothly.  Yes the management interfaces are not as slick as they could be but the newer versions of Oracle Enterprise Manager tend to overwhelm me with information.  The power of PL/SQL remains a constant in the middle of all of the changes we have seen over the years.  Each new release allows more parameters to be changed on the fly rather than requiring downtime.  Recently introduced capabilities that I think will change the future of data management include Real Applications Testing, Active Data Guard, Database Vault and Total Recall.  There’s much more and I’ll probably get dinged in my comments for leaving it out but enough said.
  • Fusion Middleware 11g – Just released and while most of us are still trying to digest it all let me summarize it as a significant statement of Oracle’s capabilities to innovate dozens of products and continually integrate them in ways that architects, developers and management can better deliver business solutions that evolve more and more quickly.  The introduction of better technologies from the BEA acquisition has positioned Oracle to be the dominant player in this market.
  • JDeveloper 11g – This IDE has to compete with dozens of other great Java IDE’s like Eclipse and Aptana but still is a stand out.  This product offers all the bells and whistles including the ability to interact with all areas of the database and middleware environments that Oracle offers.  Additionally the capabilities of the Application Development Framework simplify the development of very robust user interfaces incorporating the best Web 2.0 goodies.  Using JDeveloper I can do Use Case design, write code, test, develop a database design and still not delve all of its capabilities.
  • Fusion Applications – Though not yet  released this coming Applications Suite will introduce an innovative User Interface that is a mash-up of the best of Web 2.0 and what Oracle has learned from it’s product acquisitions (such as PeopleSoft).  Built on Oracle Fusion Middleware capabilities this application will bring Service Oriented Architecture and more industry-standards to the underlying technology stack.    The focus on improving user productivity already seen in the UI will be much appreciated by those who do the real daily work of running the details of a business.
  • Miscellaneous - Kudos to Oracle for supporting the Open Source community by releasing versions of products that they have developed (see here).

Ok, it’s time to take a rest from this area of adulation and move to the second item I think Oracle has done well.  I’ll cover that in the next post.

No Comments »

 

New 64-Bit Database Tier Configurations available for E-Biz 11i

February 21st, 2008 by Robert McMillen • No Comments »

Three new 64-bit database tier only certifications are now available for E-Business Suite Release 11i Oracle Enterprise Linux 5, Red Hat Enterprise Linux 5, and Sun Solaris.

All the details are available here.

No Comments »

 

DB Vault now certified with E-Business Suite 11i

February 7th, 2008 by Robert McMillen • No Comments »

For years companies have had to guess whether their DBAs were avoiding the temptation to run a few SELECTS on confidential financial information. After all, who doesn’t occasionally wonder what their manager is making?

And I’ve seen at least one case where it happened deep in the heart of Texas. Of course the person had also made the mistake of saving the information on their hard-drive. Not good…

After the ENRON debacle and the introduction of the Sarbanes-Oxley requirements there has been a greater emphasis in companies on maintaining separation of duties (SOD) including those at the database level. Thus the introduction of Oracle Data Vault.

Data Vault manages the SOD within the database to restrict “highly-privileged user” aka DBA’s from viewing information that is restricted. Using Data Vault, owner of the “realm” (sounds very royal doesn’t it?) gets to decide who, what and when for their data.

For the thousands of Oracle E-Business Suite users, this announcement will be of interest since it offers the first time they’ve been able to use Data Vault for E-Business Suite. It will also improve their ability to have the right answers during the next SOX audit.

The particulars are that Oracle Database Vault 10gR2 10.2.0.3 is now certified with the E-Business Suite Release 11i.

For even more details visit here.

No Comments »