GIS Degree or Self Study?

Today I presented a slide deck to HR on why a Masters in GIST is a smart decision. It sounds likely that I can get funding, but should I do it?

First of all, reimbursement is capped $250 per credit hour below the rate of the program I’m considering, and you must get an A to be reimbursed. The money obstacle might be overcome if I apply to several programs. Surely I can find a package to get an effective rate near what my employer will pay? The grades should not be a problem either.

I’m worried most about time and quality of life. I got my MBA from University of Denver in my late twenties going to school in the evenings, so I know how much work it can be. That was along time ago. Now I’m 53 and have 14 and 16 year old daughters at home. Do I really want to spend their last few years at home working on another masters degree? It feels a little selfish. I should be looking for colleges for them, not me.

I’m really excited about the spatial stuff I’ve been doing at work, and I’ve enjoyed learning about GIS on my own, so I know that I would enjoy my classes. Still, it’s a tough decision.

 

Spatial Vector Acceleration in Oracle Spatial and Graph 12c

12c_logo

Dan Geringer, Senior Software Development Manager at Oracle, was on site this week working with our DBA, Tim Gerber, and they steered me towards documentation about the spatial vector acceleration available in 12c. The parameter is documented in the Oracle Spatial and Graph Developers Guide:

To accelerate the performance of spatial operators, it is recommended that you enable the Vector Performance Accelerator (VPA) feature by setting the SPATIAL_VECTOR_ACCELERATION database system parameter to the value TRUE.

Simply run the following command from a suitably privileged account.

SQL> ALTER SYSTEM SET SPATIAL_VECTOR_ACCELERATION=TRUE SCOPE=BOTH;
System altered.

ORA-65049: creation of local user or role is not allowed in CDB$ROOT

12c_logo

I really hate the response “RTFM” in the forums, but sadly it was appropriate in my case. Let me save you some grief when you start playing with 12c. If you do not need to use a CDB (container database) or PDB (pluggable database), then uncheck the “Create as Container database” check box during the installation.

Step5of9

If you leave that checked you will quickly learn that you can’t create a local user in the root container.

$ sqlplus sys as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Wed Jun 26 07:08:11 2013
Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Enter password:
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> GRANT DBA, CONNECT, RESOURCE TO STEVE IDENTIFIED BY dbl-secret-pwd;
GRANT DBA, CONNECT, RESOURCE TO STEVE IDENTIFIED BY dbl-secret-pwd
*
ERROR at line 1:
ORA-65049: creation of local user or role is not allowed in CDB$ROOT