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.