Oracle 12c new features

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 features
June 26, 2013

Drop and create database links at materialized view refresh time

Materialized 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 time
June 26, 2013

Oracle single quote marks for excel text datatype

Add 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 datatype
June 13, 2013

VMWare performance for Oracle at Oracle User Group Scotland Conference 2013

Main 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 2013
June 13, 2013

scp and sftp either with or without a password using authorized keys

It 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
June 5, 2013

One Comment