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.
Working with Network Access Control Lists in Oracle 11g (part 2)
Part 1: http://www.e-e.com/A_8429.html
Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access. For many…
A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines