Oracle Database Management Strategic Directions

This blog will focus on Database Management Topics such as:
1. Enterprise Infrastructure Management across Multiple Tiers.
2. Oracle Fusion Middleware (J2EE, ADF, XML, BPEL, SOA, Web Services, ...).
3. Multi-Database management of Oracle, SQL Server, DB2, MySQL, ...
4. Oracle Database Server (11g, RAC, Streams, Data Guard, RMAN, ...).
5. Application Servers (Oracle, JBoss, WebSphere, WebLogic).

 
 
Tuesday, July 01, 2008

Oracle Fusion Middleware Strategic Briefing

BEA Welcome and Oracle's Middleware Strategic Briefing

I just finished listening to the BEA Welcome and Oracle's Middleware Strategic Briefing by Charles Phillips (President) and Thomas Kurian (Senior Vice President) at Oracle.   As part of the user community, I heard a lot of good things in this presentation.  Oracle is continuing to excel at integrating acquisitions into their strategic directions.  The strategic roadmap for integrating BEA into Oracle Fusion Middleware looks like a win for Oracle and BEA customers. The entire presentation can be replayed using RealPlayer.

Overall, I was impressed with Thomas Kurian's details of the BEA integration into Oracle and how that impacts Oracle Fusion Middleware technology.  Thomas Kurian emphasized:
  • Oracle's solution offers a unified solution make up of modular components. 
  • Key areas continue to be SOA, business intelligence, content management, Web 2.0 and process management.
  • There is a clear well-defined strategy for Oracle and BEA products.   This will increase customer choices for how to implement their middleware solutions.
  • Oracle will continue to increase its investment in middleware technology.
  • Oracle has a number of local events planned for BEA customers and partners.

Key Points in Briefing

The key points that stood out to me:
  • Oracle's Application Integration Architecture (AIA) is demonstrating that Oracle picked the right framework for integrating Oracle and standards based solutions into enterprise solutions.  AIA is showing flexibility as Oracle technology evolves.
  • The Oracle Integrated Development Environment (IDE) is still going to have JDeveloper as the key development tool but will also use an Oracle Eclipse Pack that will address all the BEA developers that have worked with Eclipse for years.    This allows developers have have grown up with the Oracle JDeveloper tool and open source developers that use Eclipse to choose their IDE development tool of preference.
  • Oracle ADF will continue to be a key strategic piece of developing web based applications.
  • Oracle BPEL Process Manager will continue its key role in the SOA strategy.
  • Oracle Business Rules and BAM are going to continue their strategic roles.
  • BEA technology in areas where the BEA products or components excel, are going to be integrated into the Fusion Middleware modular components.  Products like JRocket and parts of AquaLogic will strengthen Oracle Fusion Middleware in the future.
  • In areas where there is overlap between Oracle and BEA products, there is going to be some merging of products.  This is something that should surprise no one.  Customers are going to have to address this transition area.
  • BEA customers will be able to continue to use BEA products for existing support lifespans and no forced migration strategies are in place.
  • BEA developer and technology groups will move into the OTN online community.
  • SOA governance will include BEA AquaLogic Repository, Oracle Web Services Manager, EM SOA Management Pack, BEA AquaLogic Services Manager as key pieces.
  • Enterprise Portals will use Oracle WebCenter, BEA WebLogic Portal, BEA Commerce Services, BEA Collabra, BEA Pathways and BEA Ensemble as key components.
  • The Oracle Service Bus will integrate the Oracle ESB and BEA's service bus.
Summary

As the old saying goes, "the devil is in the details".  However, the roadmap is clear and looks like a big win for Oracle and BEA customers.   I liked knowing that my knowledge investment in areas such as Oracle ADF, BPEL, Oracle Business Rules and the Oracle Application Server continue to play a major role in Oracle Fusion Middleware.  I also like knowing that leading edge components in BEA are going to integrate into the modular component design of Oracle Fusion Middleware.   BEA technologists are going to have a larger transition.

Oracle Middleware expertise is going to continue to play a larger and larger role in the IT industry as Oracle Fusion applications start rolling out and as customers want to protect their current customizations to make sure they integrate into next generation business applications.

Labels:

Tuesday, April 22, 2008

Collaborate 2008 - Oracle Users Conference

The Oracle users conference called collaborate 2008 just wrapped up. This users conference is a collaboration of three key Oracle users groups:
  • Independent Oracle Users Group (IOUG) is a users group supporting the technology side of Oracle.
  • Oracle Application Users Group (OAUG) supports users working with Oracle Applications.
  • Quest International Users Group (Quest) supports users working with PeopleSoft, JD Edwards and Oracle Utilities and their complementary products and services.
This conference is the largest Oracle users conference in the world. It allows someone to attend tracks for a specific user group or to attend presentations from different users group.

With my focus on the technology side, I usually attend presentations from the IOUG and then cherry pick key speakers and presentations from OAUG and Quest relating to Oracle Fusion Middleware. The OAUG and Quest both have a lot of presentations in the different Oracle application areas.

All three user groups try very hard to minimize the marketing presentations and focus on presentations related to Oracle technology or functional areas of Oracle applications.

For me, I attended some excellent presentations on the database server from the IOUG and some excellent presentations on Oracle Fusion Middleware from all three groups.

This is an excellent conference to attend with outstanding presentations and tremendous networking opportunities.

Thanks again to all the outstanding volunteers who are the heart and soul of the conference from all three groups.

And special kudos to Executive Editor John Kanagaraj and the Contributing Editors of Select Magazine. Select magazine is voted every year as the number one member benefit of the IOUG. The incredible effort of the Select team results in an outstanding and high regarded product. Way to go John, Tony, Don, Paul, Arup, Andy and April!


Labels:

Wednesday, April 16, 2008

Collaborate 2008 - Denver Colorado

The Collaborate 2008 Oracle users conference is definitely charged with a lot of energy and enthusiasm. Everybody seems to love the rooms at the Hyatt.
Sunday - A great start with a lot of excellent university presentations.
Monday - Fusion Infusion started with George Trujillo talking about the importance of Fusion Middleware to the user community. His presentation was followed by some excellent presentations by Fusion industry leaders such as Paul Dorsey, Peter Koletzke, Eric Marcioux, Basheer Khan and Duncan Mills. The words of wisdom and insights provided by these leaders was absolutely fantastic.
Monday ended with a great networking party "Oracle Tuning" that had a lot of members playing the guitar, singing songs, doing karaoke, and dancing. A great evening was had by everyone.
Tuesday - A lot of great presentations on Tuning, RAC and Fusion Middleware. The hands on Fusion development experience had to be the hit of the day.
Wednesday - Some excellent presentations on XML DB and Fusion Middleware. A lot of the buzz on the street is on Stellant and Hyperion. Oracle seems to be putting a lot more emphasis on WebCenter. Expect a lot more on WebCenter in the next year. Wednesday is a big party.

Everybody seems to really enjoy the networking that is occurring outside of the presentations.
Thursday, February 21, 2008

Top Trends in Oracle Environments

The one consistent part of the Oracle world is that it is constantly changing. How are you changing in this dynamic environment to make sure you stay marketable in the future. Here is a list of trends I see going on in the Oracle world.
  • VLDBs - Oracle databases are getting larger and larger. There is more complexity in managing very large databases running RAC, Data Guard, Streams. Storage and security are playing a larger role as well. People with strong skills sets in VLDBs are going to increase in demand.
  • Oracle Fusion Middleware - This going to be a great area to expand in. People with skills in SOA, BPEL, BAM, ESB, Web Services, J2EE, ADF, JSF and XML are going to increase significantly in demand. The issue here is Oracle Fusion Applications are not rolling out yet. This demand is coming in the future. So there is time for you to get up to speed to take advantage of this future hot area.
  • Application Server Administrators - People that can manage the middle tier are just as important as the Oracle DBAs. The Oracle Application Server, BEA, WebSphere are all complex applications that require a lot of skill to manage successfully.
  • Application DBAs - People with DBA experience that can work with middleware developers and application server environments.
  • Managing Complexity - People with strong skill sets in Grid Control or Quest and that can manage multiple tiers of an Oracle environment from the database server to the application server are going to increase in demand. DBAs that contribute more to the business versus heads down DBAs that just write scripts are needed more than ever.
  • Hetergenous environments - DBAs that can manage multiple database platforms such as SQL Server, MySQL and DB2 are going to be in strong demand.
  • Security - Security is playing a larger role every day. Experts in the area are going to be able to name their price.
  • Open Source - The LAMP stack is playing a larger role. Linux, Apache, MySQL and PHP are having almost exponential growth.
There is a summary podcast at http://web.mac.com/george. Trujillo. At the site, click on Oracle Podcasts.

Labels: ,

Tuesday, February 19, 2008

Maximize your ROI at the Collaborate 2008 Conference

The Oracle users conference, Collaborate 2008 is coming up. It's one of highest ROIs you can get for your Oracle training dollar. Just like anything else you do that is successful, plan on how you can maximize your attendance at a conference. If you don't attend conferences on a regular basis here are a few things you can do to maximize your experience:
  1. Volunteer! Best way to meet new people and feel a part of the conference.
  2. Join! There are often Special Interest Groups (SIGs) or other groups within a conference that try to bring people with common interests together.
  3. Introduce yourself! Try to meet as many people as you can at the conference. Challenge yourself to meet as many people as you can as possible. Ask them questions like: What's the best presentation you've attended so far? Are there any speakers you really like and would recommend to someone new to a conference attend? What area are you focusing on at the conference? A conference is the best way to work on your communication and networking skills. Buy a book on networking and try some of the techniques. If you are new to the conference no one knows you, what do you have to lose? Ask them about what environments they are running? What challenges are they having with their technology?
  4. Attend get togethers! Every conference has breakfast, unconference and birds of a feather meetings and other ways to network. If one doesn't work out, don't get discouraged. Remember you don't know anyone there how can you make a mistake.
  5. Business cards! Bring business cards and everyone you meet give them a business card. Who knows, someone might even give you there card. :)
  6. Prepare! Get organized. There are tons of great books, blogs, and Internet information on 10 ten tips for introducing yourself, networking and socializing. Try them.
  7. Submit! Submit a presentation. Awesome way to expand your comfort level and for people to get to know you. Most important thing people want at a conference is to learn from other people's experiences. You don't have to be a top expert. Do not underestimate what you have to say?
I consider myself a pretty social person. However, I remember when I first starting going to conferences it was pretty lonely. I wasn't comfortable walking up and talking to people. The first birds of a feather meeting I went to, I walked in the door, everybody looked up at me, I froze and I walked out. I realized I was too shy but was too embarrassed to walk back in. It can get really lonely if it seems everybody else knows each other.

Since then I have ran different areas of a conference, been on expert panels, given key note presentations and been on board of directors for conferences. All of these things occurred because I was willing to push myself past my comfort zone and began to submit papers for presenting and to join different groups at conferences.

Networking is always rated first or second in terms of benefits for people that attend conferences. If you would like to increase your networking skills I would recommend you read the book "Million Dollar Networking" by Andrea Nierenberg. This will give you a lot of great ideas, recommendations and things to say to greatly increase your networking skills. You are going to spend thousands of dollars to attend the conference, why not spend another $30 and maximize the networking you can do.

Everybody attending a conference has been in your shoes. Go introduce yourself to volunteers or speakers. Ask them about ways to maximize the time at the conference and what speakers they like to see. All volunteers I guarantee you want you to have fun and enjoy the conference and they know what its like to go to a conference for the first time. Most importantly, find out if any conference volunteers are around, they are some of the coolest, most enjoyable and high energetic people you'll find at the conference. :)

Labels: ,

Monday, February 18, 2008

The Right Strategy for Customers

There have been significant trends and changes in the IT industry. Some of them include:

* Main Frame systems
* Client/Server
* Distributed systems
* Multi-tiered platforms with application servers
* Open Source

It's important to understand each of these is a technology to help meet business goals. Open source is currently an area of high growth and interest in the industry. The cost benefits provide organizations with a lot of flexibility in how they put their infrastructures together. Global markets and competition are putting even more pressure on IT organizations to make the right decisions.

I was talking to a friend about what organizations are doing with open source strategies. The result of the conversation ended with it is not about an open source strategy. It is more about developing the "right customer strategy" and if and how open source can play a role in helping a customer meet their business objectives and goals.

I've always felt as a DBA/manager, the more options I have the better decisions I can make. Including open source solutions in the decision process helps make sure customers are looking at their overall strategy in addressing challenges they are facing. No one technology solution is the best solution for every problem that exists. Oracle Enterprise Edition, Oracle Standard Edition, Oracle Express, MySQL, Oracle Application Server, Apache, JBoss, BEA, Eclipse, JDeveloper, Linux, PHP, Ruby on Rails, etc. all have features that can leverage what customers are trying to do. I have nothing against Windows or IBM it has just been my preference to work with Oracle and MySQL environments. Oracle and BEA have played well in the large enterprise commercial environments. MySQL has played well in Internet and web applications. For anyone to say other vendors do not provide a good solution is pretty closed minded. What I like to do is understand what a customer is trying to do and weigh the pros and cons and let them make the decision that is best for customer.

Most companies are running different types of applications.
  • Java and SOA are extremely scalable and powerful solutions that are great when those benefits are needed.
  • APEX is a strong Oracle solution that does not need application servers but it does require an Oracle database. APEX can be a very strong solution for Oracle Forms and Reports and legacy client/sever applications that are looking to move to a web based environment.
  • Ruby on Rails and PHP are great for web based applications that do not need a lot of database features.
I have been very impressed with the feature/functionality of Oracle Express. I have not tried to deploy this in a production environment but in small case scenarios it has been really impressive. Especially if you are a technical Java or XML person.
  • Oracle Express and APEX can provide a strong low cost web solution.
There are current and future costs and ramifications associated with hardware, database, application server and application development decisions. Linux, APEX, Oracle Express, Oracle SQL Developer, Apache, JBoss, Ruby on Rails, PHP and SOA are providing more options than ever.
Saturday, February 16, 2008

Oracle Berkeley DB

At the RMOUG conference I was able to get a more detailed look at Oracle's Berkeley DB. I have to admit it is very coooool. I seen some XML demos using Oracle Berkeley DB and it was like waving a bone in front of a wolf's nose, it got my attention. The Oracle Berkeley DB, Oracle Berkeley DB XML and Oracle Berkeley DB Java Edition are all things that really interest the technologist in me. Right now Oracle Berkeley DB cannot compete with everything MySQL brings to the table in terms of commercial and business solutions but the developer in me really wants to play with this tool.
Friday, February 15, 2008

RMOUG 2008: MySQL and Oracle Fusion Middlware Presentations

I gave two presentations at RMOUG this year. I have retired from doing presentations at technical conferences but I had to pay a debt for crashing the RMOUG party last year. Doing a presentation was the price I had to pay. :) In all honesty, I really just wanted to help to contribute to the RMOUG because they are an excellent local Oracle user group and I wanted to help support them in any way possible. RMOUG gives out some of the coolest shirts, so I may try to come back next year to get one of the cool volunteer shirts they gave out to everyone.

My two presentations were on:
Understanding the MySQL Architecture for Oracle DBAs
  • This is a fast paced presentation focused on showing Oracle DBAs and Developers key features and benefits of using MySQL and the LAMP stack for projects. Topics will focus on: best practices for configuring a MySQL database server, understanding key differences between Oracle and MySQL and OFA versus MOCA. Attendees will also be introduced to MySQL replication and Cluster configurations. This is an excellent bootstrap presentation for developers and DBAs that may be looking at using MySQL and the LAMP stack for future projects.
  • Audience: Developers and DBAs
  • Summary: A bootstrap presentation focused on showing Oracle DBAs and developers key features of MySQL and the LAMP stack.
Demystifying Middleware Technologies
  • This presentation is designed to demystify popular Middleware technologies and explain how these technology components work together. Topics include: J2EE, Application Servers, Web Services, XML, Application Frameworks, WSDL, BPEL, SOA and business rule engines. Attendees will learn how each of these different Middleware components work together in application servers. This is an important presentation for developers and DBAs who would like to learn more about the middle-tier.
There is a podcast summary of the Demystifying Middleware Technologies presentation at web.mac.com/george.trujillo. Go to this site and then select Oracle Podcasts.

I really enjoyed giving both of these presentations. I always shoot from the hip when I give presentations and let my mood and the mood of the audience determine the focus of the presentation. The MySQL presentation got a lot of enthusiasm from the Oracle DBAs because whenever I discuss the MySQL database server, Oracle DBAs are always really surprised by how much it can do and why it is growing in popularity. So this presentation was very upbeat and high energy. The Middleware presentation was more of a fireside chat on what are important things to understand about middleware technology that is not in the documentation and in the books but you really need to understand.

I thank the attendees who laughed at my jokes even when they weren't funny. :)


Labels:

RMOUG - Excellent Ending, Now on to Collaborate 2008 in Denver

RMOUG ended yesterday, it was an excellent conference. There were a lot of excellent presentations. Conference highlights for me include:
  • Rich Niemiec's presentation "All Uncommon Leaders" was one of the best presentations I've ever seen in my life. I've been going to business and technical conferences for about 15 years and listening to great speakers such as Gene Kranz (NASA flight director), Henry Kissinger, etc. and Rich is in the upper echelon of outstanding inspirational speakers. Way to go Rich!
  • There were excellent presentations on Fusion Middleware, APEX, XQuery, etc.
  • Congratulations to the speakers from Raytheon, every presentation I went to from the Raytheon team was outstanding.
  • Noticed significant change in trends in topics selected and focus of presenters. When you looked at the presentation topics and how full the rooms were, you were definitely able to see where the interest resides in the Oracle user community.
  • RMOUG continues to attract the top presenters in the industry, naming a few: Thomas Kyte, Jonathan Lewis (met for the first time), Peter Koletzke, Paul Dorsey, Tim Gorman, John King, Duncan Mills, Michael Ault, Steve Lemme, Don Burleson, etc. I don't mean to leave anyone out these are just the list of people I have seen speak in the last year. Speaking to any of these excellent speakers is definitely worth its weight in gold.
It just continues to boogle my mind that local companies do not send more people to conferences like RMOUG and the IOUG. With all the complexity of database and development environments it's amazing that companies will not send more employees to listen to the top industry leaders for a few hundred dollars. Oh well, it was a great conference for me.

Labels: , ,

Tuesday, February 12, 2008

RMOUG Training Days - February 13, 14 2008 in Denver, CO

The Rocky Mountain Oracle Users Group (RMOUG) an alliance group with the IOUG every year puts on an outstanding conference in Denver, CO. This conference is one of the best returns on investment for training you can get anywhere in the world. This years agenda looks fantastic as always. When looking at the agenda, topics that stand out to me:
  • Lots of presentations on Oracle Database 11g New Features.
  • Application Express (APEX).
  • Oracle Fusion Middleware.
  • XML.
  • Security.
  • Oracle development.
RMOUG as always brings together some of the top industry leaders and presenters in the United States. The agenda for this year's training days looks fantastic as always. The leaders of RMOUG understand how to put on a great conference. If in the Denver area try to attend, I believe this is one of the don't miss training opportunities of the year. RMOUG always makes you feel welcome and creates a create atmosphere.

The conference always starts with the speaker and volunteer reception. We hope to see you there.

Labels: , , ,

Thursday, January 31, 2008

Leveraging Technology

In today's global Internet environment we all see things are changing faster and faster every day.  The side effect of this is organizations and individuals push back by trying to keep everything the same. It's more important than ever that to be thinking about:
  • How do we continue to adapt our business processes for a world where technology is constantly changing?
  • What are our sources to make sure we have the correct business insight into open standards and open source and we are increasing value to our customers?
  • Do we periodically make sure sure we have the right focus and alignment between user centricity and our corporate goals?
  • How do we measure the Reliability, Availability, Service and Security (RASS) within our technical infrastructures?
"Even if you are not moving in the right direction as an organization, you should at least be pointed in the right direction".

Labels:

Tuesday, January 22, 2008

Database, Application, Internet and Middleware Wars

As a student of history I went and listened to Henry Kissinger once. He said before World War I there was a tremendous amount of prosperity in the western world but everyone new war was coming. He said there was no reason for World War I to ever have occurred but everyone at that time knew it was inevitable.

If you look at the IT industry today and the different acquisitions that are occurring you can start to see how the competitors and strategies are lining up. Here are a number of the key groups that will define direction and have an impact on where the IT industry is going. I picked these due to their capability to act as change agents:
  • Oracle - Database server, middleware, applications.
  • IBM - Database server, middleware, professional services.
  • SAP - Applications.
  • Microsoft - Operating systems and software.
  • Sun, HP and Dell - Hardware and professional services.
  • Internet companies - Google, Yahoo, YouTube, MySpace, etc.
  • Open Source - The companies, products and initiatives of the community.
  • Web 2.0 - Wikis, Blogs, Social networks, Mashups, etc.
  • The Internet - The power of connectivity and access.
  • Startup companies - The fuel for the Internet.
As I said previously, 2008 is going to be a very interesting year. I'm especially interested in the database and middleware arena. New features and releases coming out towards the second half of 2008 is going to create some very interesting redirections of the IT industry.

As an Oracle DBA or developer where do you see yourself in this Internet picture? Also, how are your skills evolving to stay marketable in this changing world?

Labels:

Wednesday, January 16, 2008

Oracle and Sun start 2008 with a bang

This may be an interesting year of acquisitions. Oracle's purchase of BEA and Sun's purchase of MySQL are definitely starting the year out with a bang. Red Hat's purchase of JBoss is also going to be interesting. As the Internet and open source continue to evolve daily, we can definitely expect more fireworks in 2008.

Oracle right now seems to be the master of acquisitions. Oracle has proven the great ability to successfully integrate the companies they purchase. From the purchases of J.D. Edwards, Siebel, PeopleSoft, Retek, Hyperion, etc. we can expect that Oracle has a strong integration strategy for BEA. The winners are going to be Oracle customers and middleware technologists. With the power of the core of WebLogic and AquaLogic being added to Oracle's middle tier, it will add a lot of power to Oracle as it goes toe to toe with IBM for the enterprise middleware space.

From a pure technoogy view, this is a great move for Oracle. For how much Oracle paid for BEA and what Oracle will do with BEA, I'll leave it to the industry analysts and wall street to determine if it was a good purchase. I've been busy enough on the Oracle side with the BPEL process manager, SOA Suite, XML and JDeveloper platform, I'm getting a headache thinking about WebLogic and AquaLogic. Does anybody else feel their head leaking when they think about middleware. The year 2007 was a banner year for Oracle acquisitions. It will be fun to see what Oracle does in 2008.

Labels: , ,

Oracle to Acquire BEA

Today, January 16, 2008, Oracle announced an agreement to acquire BEA Systems, Inc. This is sure to bring new innovativeness to the strong middleware position Oracle currently has with Oracle Fusion Middleware. BEA is a strong leader in the middleware space. With this purchase we can all expect acceleration of the SOA and Java-based technologies Oracle is currently offering today. The interoperability of Oracle Fusion Middleware and BEA will offer customers more options and flexibility with middleware solutions in the future.

The middle-tier is playing an increasing role in database architectures with identity management, SOA, BPEL, XML and Java based applications. As customers requirements become more complex, the increased options and flexibility that this acquisition will bring is important to Oracle customers. This brings the power of Oracle's BI purchases such as Hyperion and the Web 2.0 and the SOA stack that BEA has. Instead of looking at this as Oracle purchasing BEA, it is also important to also look at the new stew ingredients that Oracle and BEA have with Hyperion, Web 2.0 components, AquaLogic, XML, SOA stacks, etc. When you look at the ingredients as if a stew is being put together, the components of this stew mix that Oracle and BEA can now set on the table is pretty interesting to middleware enthusiasts.

Labels: , ,

Wednesday, November 21, 2007

Oracle Open World - Following the Money

Oracle Open World from my perspective and a lot of people I've talked to was one of the best Oracle Open World in years.  Main reasons:
  • Lots of energy and excitement over Oracle products and applications.
  • Great user and vendor turnout.
  • Oracle and user groups (IOUG, OAUG, Quest, IOUC, HEUG, etc) all working really well together.  When this happens the entire Oracle user community gains.
  • Lots of innovation, Oracle Database 11g, Oracle Fusion Applications, Hyperion and Business Intelligence, Enterprise Web 2.0 and the new features in all the Oracle products.
  • Great networking with Oracle Connect, unconferences and an incredible array of evening networking events.
  • Great combination of Marketing presentations to understand strategic directions balanced with a very good technical presentations. There was plenty for everybody.
It was also an exciting conference for the future of the DBA.   Companies have been using software, hardware and outsourcing to greatly reduce the number of working DBAs in the market.   A key point that stood out to me is that there are going to be a lot of new opportunities for DBAs that are willing to learn new things they will be rewarded by being in hot demand for the next couple of years.   Some key areas where growth will create a demand and high revenue for Oracle DBAs and Developers:
  • Data Infrastructure Administrators (DIAs) - who can manage multiple tiers of an Oracle infrastructure.  These DBAs will support the Database Server and Application Server in an enterprise.
  • DBAs who can configure and support Hyperion and BI as it moves into the database.  Hyperion may grow at a tremendous rate over the new few years.
  • Developers who can develop and customize Oracle Fusion Applications using Oracle Fusion Middleware.
  • DBAs who can configure and support the Oracle Application Server and Enterprise Web 2.0.
  • DBAs who can support advanced Oracle configurations such as RAC, Streams, Data Guard and OEM.
  • DBAs that can support Oracle applications.

There are additional areas but these are the three that stand out to me.

Labels: , , ,

Tuesday, November 20, 2007

Getting your First Oracle DBA Job

Getting your first job as an Oracle DBA
I received a comment on the blog about how someone changing careers can get their first job as an Junior Oracle DBA. I thought this a very good question so I thought I would share my answer with everyone. There are specific areas I would work on to get a job as a Junior Oracle DBA.
  • Get certified to demonstrate some basic level of Oracle DBA knowledge.
  • Learn the Optimal Flexible Architecture.
  • Practice to get some hands on experience to develop basic skills.
  • Learn how to sell yourself and understand how to write a good resume, cover letter and prepare for a successful interview.
  • Get comfortable with the Oracle documentation and the key reference manuals.
  • Learn where to go to network.
Get Certified

Changing careers to become an Oracle DBA is a definite challenge. If you are looking at becoming an Oracle DBA and you are new to technology then I do feel the certification will definitely help you. It will at least show a certain level of knowledge and a commitment to learning the Oracle technology.

Learn the Optimal Flexible Architecture

The Optimal Flexible Architecture defines a set of guidelines and standards for how to configure an Oracle database server. Most companies follow OFA to some degree. OFA defines well known best practices for how to configure an Oracle database server.

Practice to develop basic skills

Along with that an Oracle DBA has to work in a technical environment. The more a potential employer can feel you can move into their environment and be successful, the more likely you are to get hired. Basic Unix and networking skills are also important to be an Oracle DBA. Understanding the fundamentals of Unix, shell programming and being able to install and manage Oracle in a Unix environment is also important. The good thing is that with VMWare in can be relatively inexpensive to install VMWare (around $80), then you can install a free version of Linux (i.e. Enterprise Linux) or Fedora or SuSE and you can then go through the installation steps to install Oracle on Unix/Linux. Practicing a little bit every day will add up to a lot over a period of time.

Basic skills you should work on:
  1. Read OFA 5 times and conform to its guidelines.
  2. Install Oracle according to OFA. Be able to setup a tnsnames.ora environment.
  3. Make sure you completely understand the Oracle architecture (SGA, background processes, server processes, data files, system tablespaces, redo logs, archive logs, init.ora and spfile).
  4. Be able to write a Unix script to perform a cold backup using a cron job.
  5. Be able to perform full and incremental backups using RMAN. Practice different recover scenarios.
  6. Get comfortable with the data dictionary main views (DBA_DATA_FILES, V$instance, etc.)
  7. Search on the Internet for Oracle DBA best practices to see what other DBAs are doing.
  8. Be able to set up archiving, perform backups and be able to clean up archived files that have been backed up.
  9. Read some introductory chapters on performance tuning. For SQL tuning understand how to understand an Explain Plan and how to perform a SQL trace and run a TKProf report.
  10. Read up on top 10, 20 top things to tune for an Oracle DBA.

Be able to present yourself successfully to a potential employer

Being able to sell yourself and the positive things you would bring to an organization. This is just as important as your technical skills. Companies are always looking to hire someone that has a strong work ethic, will contribute positively to a team and someone that has a great attitude and fits in with a team. The key part of getting your first opportunity as a Junior DBA is selling a potential employer on yourself.

What do you see as your key assets? What can you do to present yourself well to a potential employer? Read up on how to succeed in an interview and interview tips and interview mistakes. Dress professionally for your interviews and be early for your interview. Read up on the company, see what interests you about working for that company and ask the interview questions about the company that show you are interested in joining a quality organization.

To get an opportunity as a Junior DBA you need to show a potential employer that your personal assets and intangibles can make up for you lack of experience. I can tell you that I know a number of people that have changed careers to become an Oracle DBA and they sold the company on themselves to get their first job as an Oracle DBA. I assure you companies are looking for people that work hard, have great attitudes, are trust worthy and can contribute positively to a team. These type of people are hard to find, finding someone with just DBA skills is pretty easy for a company.

Key Oracle Reference Manuals

Below are key Oracle reference manuals you should be very comfortable with.
  1. Oracle Concepts Manual - has entire chapters on different parts of the Oracle architecture.
  2. Oracle Reference Manual - key chapters on data dictionary views and initialization parameters
  3. Oracle SQL Reference Manual - get comfortable reading documentation to add a tablespace, modify a user, add a redo log group, etc.

Learn how to network

Usually the best jobs you get are through networking. Spend some time going to different local networking events. These events are usually a little uncomfortable for people how are new to them. However most networking groups are very motivated to make new attendees welcome. Networking events are also a great way to develop communication skills, learn about different companies and to let people know you are enthusiastic and looking for an opportunity as an Oracle DBA. Ask them questions you have about business, Oracle and any recommendations they have for companies to look at and apply to.

Good networking events to attend:
  • Local Oracle user groups. Search on local Oracle user groups in your area. Most major cities have strong local Oracle user groups.
  • Local Linux user groups.
  • City Business chamber meetings
  • Local Toastmasters meetings
  • Local small business meetings
The first job as an Oracle DBA can be the hardest to find. Don't give up and develop a game plan on things you can do to increase chances for success.

Good luck!

Labels: , , ,

Thursday, November 15, 2007

Oracle Open World - Changing Role of the DBA

One thing that stands out at Oracle Open World 2008 in San Francisco is the changing role of the Oracle DBA. There are a number of presentations showing how new Oracle technologies and the next generation of Oracle Grid Control are going to change how DBAs manage databases. Oracle DBAs that want to stay marketable are going to have to make sure their skills are consistent with the demands of the market. Oracle DBAs in demand are going to need to specialize in some of the following areas:
  • Oracle High Availability - RAC and Data Guard
  • Storage Management - Automatic Storage Management (ASM)
  • Oracle Streams
  • Oracle Grid Control - Using new tools, advisors and metholdologies for managing the enterprise.
  • Oracle Fusion Middleware - Ability to manage multi-tiered architectures.
  • Identity Management - Ability to work with Oracle Internet Directory and other LDAP servers.
  • Ability to support Enterprise Web 2.0
  • Ability to support multiple database platforms like MySQL.
The old days of an Oracle DBA being able to get by on just performance tuning and backup/ recovery skills are not going to be enough to stay marketable in the future. Basic skill sets are easy to find and easy to outsource. To get a better vision of the future you should look at new features in Oracle Database 11g that can greatly simplify database administration. Some of these include:
  • Automatic SQL tuning
  • New Diagnostics Advisor
  • RMAN Advisor
  • SQL Tuning Advisor
This list is a very small subset of all the diagnostic and advisor tools available in the Oracle Enterprise Manager for Oracle Database 11g. These large set of tools are going to play a large role in managing Oracle production environments. The old days of writing custom scripts are almost over. DBAs are going to use more tools like Grid Control automate a lot of the day to day tasks DBAs typically perform.

Labels: , ,

Wednesday, November 14, 2007

Oracle Open World - Oracle Database 11g Expert Panel

There was an excellent expert panel on Oracle Database 11g New Features on Sunday that helped set the tone for Oracle Database 11g for the week. This panel had recognized leaders in the Oracle user community and key leaders that were part of the Oracle Database 11g beta program. Trubix has been part of the Oracle Database 11g Beta program since the fall of 2006. The panel included:

  • George Trujillo - Oracle Database 11g Beta Program Leadership Council
  • Dan Norris
  • John King
  • Charles Kim
  • Plamen Zyumbyulev
Oracle Open World is strongly emphasizing Oracle Database 11g and Oracle Fusion Middleware 11g throughout the conference. You can also expect that Oracle Database 11g will be emphasized at the upcoming Collaborate 2008 Conference in April, 2008 in Denver, CO. You can expect to see a quicker adoption of Oracle Database 11g with its outstanding features as well as its stability. This option will be a stronger consideration for leap frogging Oracle 10g.

There are blog entries below that summarize Oracle Database 11g New Features.

Labels: , ,

The Days of Fusion Confusion are Over

People used to have fun saying Fusion Confusion, etc. Those days are over. Oracle Fusion Applications and Oracle Fusion Middleware are emerging key areas of Oracle applications and technology. Saying “Fusion Confusion” is showing that you are not in touch with what is going on with Oracle technology.

This next generation of Oracle’s strategy will impact those directly involved in Oracle technology as well as those reliant upon it. Current and future Oracle DBAs and developers will need to be able to support Oracle Fusion Application environments. For Oracle DBAs, being able to support Oracle Fusion Middleware environments is going to be a steep learning curve. System administrators are starting to fill the gap of the need for administrators who can support the Oracle middletier. If you want to stay marketable as an Oracle developer, you are going to need to learn at least parts of Oracle Fusion Middleware.

Oracle EBS, PeopleSoft, J.D. Edwards, Siebel, Retek and Hyperion applications are all going to need administrators that can manage multiple tiers of Oracle and non-Oracle infrastructures as well architects, developers that understand Oracle Fusion Middleware technology. With the explosion of middleware technologies such as Application Servers, J2EE, Web Services, SOA, BPEL, Business Rules, XML, etc. there will be a strong need for Oracle Fusion Middleware professionals.

Oracle Open World 2008 - San Francisco

Sharing a few Oracle Open World Experiences


Oracle Open World in San Francisco is one of the best (maybe the best) conference Oracle I've been to. There is so much energy and excitement I thought I would share a few of my experiences.

Catching the Excitement of Oracle Open World in the Caribbean

I was on a flight from San Juan Puerto Rico heading towards San Francisco for Oracle Open World (OOW). Someone sitting next to me seen I was in the Oracle documentation on my laptop. She asked if I was going to OOW and I said yes. She said that she was too. She and a number of members of her team were headed for OOW as well. Before long we were talking about how excited we all were to be heading to OOW.

The excitement of everyone going to OOW seems to be a constant for everyone I talked to in San Francisco. I’ve been to a lot of Oracle Open Worlds and I can’t remember when there was so much enthusiasm for customers, vendors as well as Oracle employees. On Saturday and Sunday all the meetings I had seemed to be full of smiles and a lot of enthusiasm and energy.

Saturday night we had an IOUG board meeting and invited some key volunteers from the conference to join us. It was a great dinner and a lot of fun to discuss upcoming IOUG activities and events for the upcoming conference.

Sunday morning I had some early morning meetings and did some final preparation for a 90 minute expert panel I was leading on Oracle Database 11g New Features. I had a lunch meeting and headed over to the Moscone Center. I got registered and headed up to the IOUG booth where I ran into a number of board members from the IOUG and key leaders from the IOUG. It seems like everywhere I went I was running into people I knew and everyone was full of smiles and you could feel the excitement.

IOUG Helps Launch the Start of Oracle Open World

The International Oracle Users Group (IOUG) was given a large number of presentation slots to launch Oracle Open World. Key IOUG leaders delivered technical presentations ranging from Oracle Database 11g New Features (my presentation), RAC, ASM, Oracle Application Server, Security, Oracle Fusion Middleware, etc. all focusing on best practices.

The IOUG has always emphasized best practices. It was great to see the IOUG get recognized for leadership in the technology side of Oracle.

The agenda for the week is one of the best I’ve every seen at an Oracle conference. Some things that stand out to me at the conference include:

  • Great layout of technical presentations focusing on Oracle Database 11g.
  • Large emphasis on Oracle Fusion Middleware.
  • Strong focus on Enterprise Web 2.0 technologies.
  • Oracle Applications seem to be everywhere.
  • Great evening events with Billy Joel, Stevie Nicks and Fleetwood Mac.
  • New Unconference activities.
  • Open World Connect allows networking with other conference attendees. A great way to bring people together. This is a new level of networking at conferences which includes the opportunity to start your own blog.

Attendees had a choice of getting a flash drive with the conference technical presentations or getting a hard copy book. I liked being give that choice. I preferred the flashdrive. I’m slowly making a move off of hard copy materials and moving everything to a wiki or web sites. With Enterprise Web 2.0 growing in momentum we are all going to need to make the move to more electronic materials.

Friday, October 19, 2007

Oracle Open World Top Ten Areas to Focus On

Oracle Open World (OOW) is right around the corner. With the size of OOW, its become more important than ever to preregister for events. There is a lot of excitement and energy around all the new and evolving technology around Oracle. Don't forget the IOUG SIG day on Sunday. We hope to see you there.

What are a number of evolving areas to stay up to speed on? We took an internal poll and here are the top areas our teams were interested in on the technology side:
  1. Oracle Database 11g New Features
  2. Oracle SOA Suite
  3. Oracle Fusion Middleware
  4. Hyperion
  5. Oracle Data Vault
  6. Oracle Audit Vault
  7. Oracle ILM
  8. WebCenter and Web 2.0
  9. Oracle technical DBAs and Oracle Apps Administration
  10. Oracle Application Server
It took us a long time to get it down to a top ten. To get us to agree on the order of the top ten would have involved jousting. So this order was picked from a hat.

A constant theme of a number of the articles on this site is the importance to keep expanding your technical skill set. Hope to see you there.

Labels:

Tuesday, September 04, 2007

Driving business with Middleware Tools BPEL and Business Rules

The current wave of technology is the alignment of IT applications (software) with business processes. Middleware technology tools are driving this direction. Increasing competitiveness in global markets, changing customer needs are requiring businesses to respond faster and faster to this change. Along with this is the importance of compliance and governance.

Two middleware tools are addressing these demands: the Business Process Execution Language and Business Rules. Both of these tools allow business users and processes to drive the direction of IT applications. Tools such as the Oracle BPEL Process Manager and Oracle Business Rules are providing customers with more agility and flexibility so they can have their IT applications be able to change quickly in a well-defined way.

The success of SOA projects are increased significantly with the use of BPEL. Adding more agility and flexibility with applications occurs when using business rules.

The Oracle Fusion Middleware technology stack continues to grow with Oracle Business Rules being added to the stack.


Labels:

Thursday, July 19, 2007

Oracle Fusion Middleware: SOA and BPEL, like Harry Potter and Hermione

I get a lot of questions on SOA and BPEL, so I wanted to talk a little about them to make sure that if you are at a party and the topics of SOA and BPEL come up, you can join the conversation. When people are talking about the BPEL, WSDL, or the shizzle you need to understand what they mean. This is important because a few years ago RAC and margarita parties were very popular, now Oracle Fusion middleware and mojito parties are all the rage. In fact, I was at one of my favorite restaurants in San Francisco, Colibri a Mexican Bistro and while having a mojito the person next to me started talking about middleware.

Aligning Business Processes and Applications

Batman and Robin, the Green Hornet and Kato, Harry Potter and Hermione and now SOA and BPEL. For most of these you can't imagine one without the other. A key for enterprise organizations is focusing on improving the alignment of business processes with technology (software applications). Business processes are constantly changing and organizations need to be very good at managing that change.

Web services, the Service Oriented Architecture (SOA) and the Business Processing Execution Language (BPEL) have become very popular approaches to address the following important challenges:
  • Managing changes to business processes and reflect those changes with its applications.
  • Getting all kinds of different types of applications to work together.
Services
A service is an endpoint in a connection. The endpoint contains a standalone function (provider service) that can accept input (from a consumer service) to perform a task and then return a result. This function is self-contained and is not dependent on any other service to perform its specific task. A number of services can communicate with each other to perform more complex tasks. The services communicate using XML based WSDL service descriptions.

Web Services, WSDL, UDDI, XML and ESB
Web services is the technology for connecting services. Web Services has become the technology for achieving interoperability with different languages, operating systems and hardware platforms. Web services is a distributed technology for connecting different types of applications that are supported by all vendors. A web service is an application that provides some type of business functionality while hiding the details of how it works. Software applications can then use web services (software applications that provide specific functionality) to perform a task or operation.

The technology components that make Web Services work includes:
  • Web Services Description Language (WSDL) - Uses XML data structures for describing services as a set of endpoints. Service requests use WSDL to understand how to communicate and how to send information back and forth.
  • Universal Description, Discovery and Integration (UDDI) - (UDDI) is a registry that stores information (WSDL) on services. Kind of like a phone book stores phone numbers.
  • The eXtraction Modification Language (XML) is a data structure containing metadata and data that is used for sending information back and forth. You can think of XML as being the plumbing that makes everything work.
  • Simple Object Access Protocol (SOAP) - SOAP is the protocol for how XML based messages get sent across the Internet using HTTP/HTTPS.
  • An Enterprise Service Bus (ESB) is a communication infrastructure that allows different middleware products and protocols to communicate. The ESB provides routing, transformation, the management of services and message processing capabilities. All your applications may not be using web services, so the ESB can function as an intermediary for different types of communication.
The Service Oriented Architecture
The Service Oriented Architecture (SOA) provides services (web services), messaging (exchange of data), self-describing interfaces (WSDL), service registries (UDDI), service quality and the organization of services (BPEL) into business processes. SOA does not specify the technology components to use. SOA uses services that can be used without the service knowing anything about the application calling it and the calling application not needing to know how the service performs its task. SOA is an architecture that facilitates the creation of loosely coupled services (applications) that can be executed from any platform. Services communicate using well-defined descriptions or contracts using WSDL. This complete hides which language a service is written in. Services can be written in Java, .NET, C#, PL/SQL and PHP to name a few.

Changing Environments
The computer industry has gone through significant changes. From mainframes, to client-server, to multi-tiered web environments and now to a service oriented architecture. Every technology has had its place. Business flexibility, integration, coordinating business processes with applications have forced the move to a service oriented environment. What's funny is that SOA and web services can increase the life of legacy systems.

BPEL a common language.
The problem in getting technical and business people to communicate well is they need a common language. For example, technical people speak languages like Oraclese and business people speak languages like Parseltongue. The Business Processing Execution Language (BPEL) for Web Services (WS-BPEL) or (BPEL4WS) is a high level language that both technical and business people can both speak.

BPEL is a business process modeling language that can be executed. BPEL defines business processes for web services using XML. This is why BPEL plays such a strong role in the Service Oriented Archiecture.

Some of the features that BPEL offers:
  • Organizing how services (software applications) are aligned with business processes.
  • Definition of business processes.
  • Automation of web services.
  • Managing synchronous and asynchronous operations.
  • Executing services in sequence or in parallel.
  • Managing short or long running transactions.
  • Resuming interrupted or failed operations.
  • Scheduling activities.
  • Define business processes with several scopes.
  • Route messages.
  • Define business logic through the organization of services.
  • Create business processes from smaller processes.
BPEL is definitely helping organizations make the implementation of SOA successful. Tools such as the Oracle BPEL Process Manager are making it a lot easier to introduce BPEL into an organization and increasing the adoption of SOA. The Oracle BPEL Process Manager can be used by business analysts and technical people to communicate on how to align business processes and software applications.

The Oracle BPEL Process Manager runs in the Oracle JDeveloper product or it can be installed into tools such as Eclipse. The Oracle BPEL Process Manager also works with the majr application server vendors. Although we mention the Oracle BPEL Process Manager, BPEL products are available from IBM, Sun, Microsoft and a large array of 3rd party companies. The OASIS Technical Committee (WSBPEL TC) is currently working on the WS-BPEL 2.0 draft. This draft focuses more on extentions to the the existing WS-BPEL 1.1 version.

BPEL is a standard that manages web services and is language independent. However, most web services are implemented with the Java Enterprise Edition or Microsoft .NET. There are also BPEL servers that are provided by a number of different companies. BPEL helps the success rate of SOA projects. One way of looking at this is, think of a service of being a house or building that generates a product or needs a product, web services as being the houses or buildings, XML (WSDL) being how people in the houses and buildings communicate, SOA as being the town and BPEL defining how the town is organized.

Organizations that are using SOA and BPEL are having much more success with higher end-user satisfaction versus the companies that are trying to just implement web services. Hopefully this will put a little more shizzle in your conversations on SOA and BPEL.

Labels:

Oracle Database 11g Launch in New York City

An Exciting Launch!
It was exciting to be invited to the Oracle Database 11g launch in New York City. As part of the Oracle beta leadership council, it was great to see so much energy and interest surrounding the Oracle Database 11g release. One thing that is very important with the growth of data and the need of businesses to be able to be nimble and respond to change quickly, is that databases need to constantly get faster, improve diagnostics and troubleshooting, reduce the cost of ownership and improve manageability. The Oracle Database 11g release definitely succeeds in all these areas.

I thought one of the highlights was for the Independent Oracle Users Group (IOUG) to get so much stage time with Charles Phillips. I felt is showed the tremendous input the IOUG has provided with the Oracle Database 11g product and Oracle's recognition of that. As a board of director for the IOUG and my involvement with the Oracle beta leadership council it was nice to see the important role the IOUG plays in the industry be recognized at such a high profile event. The IOUG is also continuing to play an ever increasing role in the Oracle 11g Middleware beta program due to the IOUG's profile in the Oracle Fusion middleware space.

Oracle Releases
Historically speaking the first Oracle release of Oracle Database 5, 6, 7, 8, 8i, and 9i were definitely bleeding edge releases. However Oracle 10g and Oracle Database 11g have been by far the most stable and well tested first releases in the history of Oracle. While a lot of people were talking about not moving to the first release of Oracle 10g, they did not realize that Oracle 10g had a lot of bug fixes for Oracle 9i and had a lot of improvements in the advanced features of Oracle.

I feel the Oracle beta program has had a significant positive impact on the Oracle 10g and 11g releases. By getting industry leaders from user groups such at the IOUG allows recognized industry leaders to have direct input and to provide feedback directly to Oracle product managers and developers. It has been wonderful to see how open Oracle has been to listening to the user groups and the incredible effort the Oracle product teams have put into the release. As Charles Phillips mentioned, Oracle Database 11g is the gold standard of Oracle releases and the Oracle beta program has been a large part of that success.

Be Careful of Old Sages
I understand the important need to be cautious about upgrading and to minmize risk and downtime. Everyone understands it is important to be careful about upgrading. You'll see an old sage say, well the new software release is interesting but I think I will wait for a later release. You'll then see a number of DBAs nod their heads in agreement. That's also like saying I am going to save my company money and reduce risk by continuing to run my company with old techniques that are out of date. Companies like this are running their databases more like the way they did 5 or 10 years ago with a sprinkling of new features being used. They are bragging about their up time yet not leveraging features that would help the organization and save it money. Safe is important but so is maximizing your ability to be competitive in the industry. The old saying, "if it isn't broke, dont' fix it" isn't always the best approach.

Technology needs to leverage what businesses are doing and to give business a competitive advantages. Companies need to look more carefully at the benefits of new features and how these features can benefit the business. I am not saying take your highest profile database and move it to Oracle Database 11g when it first comes out. What I am saying is that customers looking to migrate lower profile Oracle 9i databases should strongly consider migrating to Oracle Database 11g to leverage the benefits of the new features. If the new features of Oracle Database 11g are used out of the box, a company has the opportunity to significantly reduce their cost of ownership, increase availability, improve performance and manageability.

Benefits of Oracle Database 11g
Oracle Database 11g definitely hits the mark in:
  • Making the database and database applications run faster in key areas.
  • Improves important features related to Real Application Clusters, Data Guard and Oracle Streams.
  • Reduces cost of ownership with Change Assurance (Database Replay) and Lifecycle Management.
  • Greatly improves manageability and diagnosability.
A few features I really like that may not make a top ten list but I really liked include:
  • PL/SQL gets faster and easier to adminster with native compilation without the need for an external compiler.
  • Java in the database gets significantly faster.
  • PHP in the database who would have ever thought.
If you are an organization that needs to leverage technology to improve the business and make it more competitive then I highly recommend a detailed review of Oracle Database 11g features to see what benefits can help your business. You may decide not to move to Oracle Database 11g but to keep your organization as competitive as possible, a through analysis of Oracle Database 11g should be done.

Labels:

Tuesday, June 12, 2007

Trubix releasing Oracle 11g classes soon

In Oracle 11g, everyone is going to be amazed with the level of new features in the Oracle 11g database server. The Oracle 11g Database Server contains new features and enhancements in the areas of Manageability, High Availability, Performance, Content Management, Security, Information Lifecycle Management, Data Warehousing, Business Intelligence capabilities. There are also a number of new features related to development including PL/SQL, Java, .SQL Developer, Application Express, .NET, PHP and BI Publisher.

Once Oracle releases Oracle 11g to the public, we will finalize our set of topics and have new classes in Oracle 11g available immediately. We look forward to seeing you in our Oracle 11g classes and showing how to lower your cost of ownership and increase your managability of the Oracle 11g database server.
Wednesday, May 30, 2007

Oracle Fusion classes by Trubix.








To address the need of Oracle DBAs and developers, Trubix is launching a full series of Oracle Fusion classes. These classes are designed specifically to teach Oracle Fusion technology from an Oracle perspective. You can visit the Trubix website to look at our Oracle Fusion classes in more detail.

We are pretty excited about these classes because the design and layout of these classes were generated by feedback from our top clients as to what was the specific training they needed for them to be successful with Oracle Fusion.
Tuesday, April 24, 2007

Oracle Database 11g New Product Features: Summary

The Oracle database continues to evolve with key outstanding features that will provide a high return on investment immediately out of the box with the new features in Oracle Database 11g. Every database vendor offers a database that offers specific benefits. What I have always liked about Oracle, is the Oracle Database Server has by far more feature functionality than any other vendor. This offers the DBA an extremely rich set of tools to solve complex problems in today's environments. In Oracle Database 11g, Oracle takes a very large leap in innovation and feature functionality.

Key features that everyone will be interested in include:
  • Awesome change ensurance features with Database Replay and SQL Replay.
  • Secure Files (next generation LOBs). Significantly faster than LOBs with more flexbility.
  • SQL Plan Management.
  • Java, XML DB, PL/SQL, APEX and PHP add a lot of performance and feature enhancements.
  • Excellent enhancements in compression and encryption across the board.
  • Very nice enhancements to partitioning, including automatic partitioning. New Partition Advisor.
  • Read only tables, Virtual columns and invisible indexes
  • Upgrade and downgrade enhancements.
  • Solid enhancements in RMAN, RAC, Data Guard and Data Pump
  • Automatic Diagnostic Repository.
  • ASM enhancements include Fast Mirror Resyncs, rolling upgrades, new SYSASM role and migrations to ASM.
  • Enhancements to temporary tablespaces.
  • Read only tables.
The Oracle Database 11g New Product Features blog (below) goes into more details of Oracle 11g New Features.

Labels:

Oracle Database 11g New Product Features

I was telling a friend about the new Oracle Database 11g server and they said, "You're kidding, we haven't even moved all of our databases to Oracle 10g. Why should I care about Oracle Database 11g? I hope to be retired by the time the Oracle Database 11g is introduced into my company". I answered with, I've spend the last five years watching companies make bad hardware, software and database management decisions because they did not know how the new features in Oracle 10g could impact their database environments. Or understand the high cost of ownership of their databases because they are managing their databases today pretty much the same way they were ten years ago. Reasons why you should care about features in a new release of the Oracle database:
  • It is very important that a company understand how features in a new release of the Oracle database server will impact their current database management practices and decisions.
  • The correct decisions made today will reduce migration issues in the future.
  • The only way to make the right decisions today, is by understanding where database management is going in the future.
  • Understanding current and future skill sets needed for IT staff.
  • I believe you don't always have to be moving in the right direction, but you should always try to be pointed in the right direction.
  • With Oracle Database 11g Database Replay and SQL Replay, the migration to Oracle Database 11g might be done at significantly reduced costs versus Oracle 10g.
  • As Oracle 9i moves towards being desupported, Oracle Database 11g m