This year, 2016, is turning out to be an amazing year again, with #OOW16 being once again on of the apices!
After the discovery of the Oracle community in 2012, as a result of a very first trip to downtown San Francisco in 2010 for #OOW10, an amazing chain of events was set in motion. This very first introduction in the Oracle World was as ‘a mere participant’ in this awe-inspring, large (more...)
Jump-start your MySQL knowledge with this in-depth webinar that will assist you in learning the building blocks for creating a centralized service offering with MySQL Enterprise Edition.
This webcast will be offered in 3 languages: English (9/13), Spanish (9/14), and Portuguese (Brazil) (9/14).
We've pushed out a release of node-oracledb to
GitHub and NPM.
Top features: Connection Pool Cache
The node-oracledb driver connects Node.js to Oracle Database for fast
and functional applications.
The changes in node-oracledb 1.11 are:
Added a connection pool cache feature allowing pools to be
given a... [Read More
PHP OCI8 2.1.2 (for PHP 7) and OCI8 2.0.12 (for PHP 5.2+) have been uploaded to PECL. The OCI8 extension allows PHP applications to connect to Oracle Database.
Use pecl install oci8 to install PHP OCI8 2.1 for PHP 7.
Use pecl install oci8-2.0.12 to install PHP OCI8 2.0 for PHP 5.2 - PHP 5.6. Note: PHP 5.6 is the... [Read More
up to date with the Oracle Certification Program, view exams released into
production, get information on current promotions or learn about new program
First! Register for a Beta Exam:
Exadata X5 Administration | 1Z1-070
Database Cloud Service | 1Z0-160. Earns the
certifications below. Click the credential title to see the requirements.
Next Certification with NEW Exams:
Maarten wrote a post on Virtual Columns in the oracle database. I read a blogpost on preventing people issuing SELECT * on a table. This was done in a different database, so I decided to try it out in my Oracle Database.
First I create a simple table:
create table demo.emp_nuke
empno number(4) not null
, ename varchar2(10)
, sal number(7,2)
, deptno number(2)
, blowitup number generated always as (1/0) virtual
Last week we were struck by an issue, which turned out to be a bite from a bug!
SYSAUX table-space had quickly filled up to the “my data-file is full”-limit, which in the end was fixed by adding a data-file.
Strange thing though, that for a very small footprint database, we now have a very big SYSAUX table-space.
Some investigation brought me to the Unified Auditing being standard active in database 12c (you can read (more...)
Some time ago I was asked to assist in fixing or at least finding the cause of a performance problem. The application ran fine until the Virtual Private Database (VPD) policy was applied. Oracle claims there should be near zero impact on your application when you implement VPD, then how is this possible?
First of all, the policy applied was a rather complex one. A complex query should be executed to determine if the current (more...)
I bumped into this issue recently which prevents you INSERTING a date of 31-12-9999 into an INTERVAL partitioned table due to the fact that the LESS THAN partition value would be larger than an Oracle Date. After speaking with Jeff Moss he mentioned that we might be able to get round the problem by using a virtual
This script is used to set up the test table for the following blog posts: Oracle Database INTERVAL Partitioning Date Error With 31-12-9999 Oracle Database INTERVAL Partitioning and Virtual Columns [crayon-578913d2a047f830082062/]
You may have seen the below error when using dates at the extremes with an Oracle Database. This post focuses on the scenario where you’re inserting a high date, such as 31-12-9999 into an INTERVAL partitioned table. High dates such as this are often used in warehouse environments where from and to dates are specified
Apache Cassandra™ is a massively scalable open source NoSQL database. Cassandra is built from day 1 to be clustered to tick the usual clustering boxes; no single point of failure, and capacity and throughput scales with cluster size. This guide will look at creating a three node basic cluster within a single data centre. It is assumed
The following process will install the DataStax distribution of Cassandra on any Debian based system, such as Debian or Ubuntu. We’ll use the official DataStax apt repositories to install Cassandra using apt-get. Cassandra is written in Java and the latest version (at the time of writing) of Cassandra requires Java 8. You can use either OpenJDK or
After what seems like eons since we first started on it, I’m excited to announce a new book I co-authored is finally out. The book is called “Building Database Clouds in Oracle 12c” and is available on Amazon. Of course, it really isn’t that long ago that we started writing the book, but there’s been a lot happening between then and now!
The book was co-authored with Tariq Farooq and Sridhar Avantsa. Tariq asked me (more...)
Let’s Talk Database – Thursday, 28 July 2016
The next in Richard Foote’s popular Let’s Talk Database series – Let’s Talk Database: Oracle Database 12c – Built for Data Warehousing – is on in Canberra on July 28th. These are free events but due to limited places have often “sold out” in the past, so booking early is recommended to avoid disappointment.
The Oracle Database is the leading database in market but it (more...)
Higher eduction establishments around the world use Peoplesoft Campus Solutions from Oracle to manage their key business processes.
In this reference architecture we look at the key requirements for Campus Solutions and the technical solutions that can be deployed on the Amazon Web Services Cloud.
Availability: Campus solutions needs a high availability infrastructure to ensure that both the administrative and student users can access data at all times. This solution uses multiple web and (more...)
I have been considering writing this article for quite some time now.
APEX Connect 2016 in Germany’s capital Berlin and the DOAG Database days have finally persuaded me to talk more about #DBADev, let me explain why…
Whenever in the stone age…
During my career as DBA, I was always working closely together with Oracle Forms & Reports developers. In retrospect, the cooperation in that time was remarkable.
These Forms & Reports developers had always (more...)