I have been tasked with upgrading from Oracle 9i to 11g. I am a student doing this for my work study / internship for my college.This database is accessed by students using sql developer to learn sql and plsql. We have purchased a new server to run Windows 2012r2 and to install 11g on it. The server appears to be very overbuilt for the limitations of 11g. It has dual octa-core cpus and 128GB of RAM.
1.Will 11g use all eight cores on one cpu or does one cpu refer to one processing core?
Looking at the current installation of Oracle 9i on Win2K3 the Oracle folder on the C drive is using 260GB.
2. Is the entire contents of the Oracle folder on the C drive considered user data (user data limit 11Gb)?
a. If the entire Oracle folder is not user data, then where do I look to determine how much user data we have?
3. Will 11g support 100+ user accounts accessing it via sql developer?
Should we be looking for a different version of Oracle (perhaps 12c standard) for this task?