Oracle

High System Time on Windows Running in a VM

Recently I’ve seen an issue with CPU usage on a server running Windows 2003 Server in a VMware. This is a small Virtual Machine with just 2 cores allocated (which are possibly mapped to “threads” on a host level but I don’t know the details). For some reason very high System CPU time was reported…

An Introduction to Extended Data Types in Oracle 12c

One of the lesser known new features that comes as a boon to many developers and DBAs is the provision of implicit handling of large data strings using scalar data types like VARCHAR2 and RAW. When creating tables, each column must be assigned a data type, which determines the nature of the values that can…

Oracle E-Business Suite Updates From OpenWorld 2014

Oracle OpenWorld has always been my most exciting conference to attend. I always see high energy levels everywhere, and it kind of revs me up to tackle new upcoming technologies. This year I concentrated on attending mostly Oracle E-Business Suite release 12.2 and Oracle 12c Database-related sessions. On the Oracle E-Business Suite side, I started…

Is X a Big Data Product?

Virtually everyone in data space claims today that they are a Big Data vendor and that their products are Big Data products. Of course, if you are not in Big Data then you are legacy. So how do you know whether a product is a Big Data product?

Fixing Windows RAC Listener to Listen On IP Address of Hostname

Recently, there was an issue after a node was added to an existing Windows RAC cluster. After everything was set up, the local listener was not listening to the IP address (192.168.0.37) corresponding to the node’s hostname. Oracle version was 11.2.0.4. The listener.ora was configured properly with the following line: LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by…

Oracle Database: Script to Purge aud$ Table Using dbms_audit_mgmt Package

With an increase in requirements on database security, database auditing is part of most production databases nowadays. The growth on Oracle database audit table”‘aud$” always add spice on a DBA’s life. Since this table growth directly impacts the database performance, this table got special place on every DBA’s heart. Traditionally we follow many methods to purge…

12c: How to Restore/Recover a Small Table in a Large Database

As a DBA, you will receive requests from developers or users, indicating that they deleted some data in a small table in a large database a few hours prior. They will probably want you to recover the data as soon as possible, and it will likely be a critical production database. Flashback will not be enabled, and the recycle bin…

12c: Fun with WITH!

Last night I couldn’t sleep and what else you’re going to do? I was thinking about Oracle stuff. In Oracle version 12, Oracle has enhanced the WITH clause – traditionally used for sub-query factoring – to allow the declaration of functions and procedures. This can be (ab)used to create a very interesting scenario, that is not very…

In-Memory Column Store: 10046 May Be Lying to You!

The Oracle In-Memory Column Store (IMC) is a new database option available to Oracle Database Enterprise Edition (EE) customers. It introduces a new memory area housed in your SGA, which makes use of the new compression functionality brought by the Oracle Exadata platform, as well as the new column oriented data storage vs the traditional…

Page 3 of 13912345...102030...Last »