Oracle 12c was released yesterday (25-Jun-2013). I’m a little bit underwhelmed by a first look at the new features guide – if that’s all there is, Oracle is going to continue to struggle against Microsoft SQL Server. Main change with 12c is concept of container databases and pluggable databases: Container databases by default hold SGA, […]
Read More Oracle 12c new featuresMaterialized views work ok even when their dependent database link is dropped from under them. This can be used as a security improvement if you don’t want database links lying around during the day outside the refresh window. Script used to test (with complete refresh) was: create database link temp_link connect to user identified by […]
Read More Drop and create database links at materialized view refresh timeAdd a quote in front of a field (useful for excel to mark cell as text datatype) with any of: SELECT CHR(39) || address1 FROM customers ; SELECT q'[‘]’ || address1 FROM customers ; SELECT ”” || address1 FROM customers ;
Read More Oracle single quote marks for excel text datatypeMain highlight Oracle User Group Scotland Conference 2013 was a presentation by Dean Richards of Confio Software on VMWare performance for Oracle. Confio’s servers were at 1-5% CPU, so underutilised, but databases use memory rather than CPU. They virtualised 50 physical servers > 1 esx host – was at 40-50% CPU. Later moved to two […]
Read More VMWare performance for Oracle at Oracle User Group Scotland Conference 2013It is better to use scp/sftp rather than ftp – because ftp transmits passwords in plain text and also requires extra firewall openings to work. 1) Simplest way – use sftp specfiying the password in the script, like this: lftp -u user:password sftp://server.domain.com << END_LFTP put /directory/file.txt quit END_LFTP Use the -O option to put […]
Read More scp and sftp either with or without a password using authorized keys