upgrading oracle database 8i to 11g
I've been given the task of explaining the advantages of upgrading our ancient oracle 8i to 11g.
We use the DB to serve a few web sites - a few thousand online users but rarely more than 70-100 at a time. We do not use the DB anywhere near it's capabilities but Oracle was the choice the company made years ago and I'm stuck with it.
I realize there must be innumerable changes since 8i but we would be interested in just a couple of areas:
- new SQL commands for more efficient retrieval of data
- better maintenance tools for recovery and monitoring the DB
Can anyone come up with a short list?
We're using Windows 2003 Server OS. Is 11g compatible with that? Could we go with 10g and save some money?
I am not a DBA but am required to perform many of those duties. I'm basically a programmer and web designer who happens to be using an Oracle DB.
HELP!
Thanks
We use the DB to serve a few web sites - a few thousand online users but rarely more than 70-100 at a time. We do not use the DB anywhere near it's capabilities but Oracle was the choice the company made years ago and I'm stuck with it.
I realize there must be innumerable changes since 8i but we would be interested in just a couple of areas:
- new SQL commands for more efficient retrieval of data
- better maintenance tools for recovery and monitoring the DB
Can anyone come up with a short list?
We're using Windows 2003 Server OS. Is 11g compatible with that? Could we go with 10g and save some money?
I am not a DBA but am required to perform many of those duties. I'm basically a programmer and web designer who happens to be using an Oracle DB.
HELP!
Thanks
ASKER
Thanks for the input. I too think it's a good idea to upgrade but this will be expensive for us and Oracle is used for an area that doesn't generate all that much money for us (we're a book publisher and the DB is used solely for our interactive websites).
The owner of the company is a hard-sell so I have to give him as many reasons as I can for spending the cash. Am I right in thinking we will eventually be forced to upgrade Oracle when we want to upgrade the OS to Win Server 2008 or above?
The owner of the company is a hard-sell so I have to give him as many reasons as I can for spending the cash. Am I right in thinking we will eventually be forced to upgrade Oracle when we want to upgrade the OS to Win Server 2008 or above?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
While this was a fairly thorough answer I was hoping for more specific information regarding specific Oracle tools available on 11g and not available on 8i ... not an easy thing to do, I admit.
Really appreciate how fast the response was!
Really appreciate how fast the response was!
11g is leaps and bounds better in performance over 8i.
There are some 'new' sql commands but unless performance is bad, why rewrite any code?
Monitoring is also night and day. The latest Grid Control has a lot of new info.
If you license the options, it also has some very good Wizards to analyze the database and offer advice.
As far as saving money with 10g, not likely.
Yes, 2003 is supported. Go 64Bit if you can!