Starting with Oracle Database 12cR1 (220.127.116.11), a new static
pool in the SGA is designed to store data in the columnar format and is called
In-Memory Column Store (IMCS). Each table column is stored as a separate structure
in IMCS. The In-Memory column store does not replace the buffer cache, rather
supplements by storing data in columnar format.
Following the levels at which IMCS can be enabled at:
While presenting at a database event, I had a question from one of
the attendees on benefits of running Oracle databases in Single Tenant
Configuration. I thought this would be a
nice if I post it on my blog as it would benefit others too.
From Oracle documentation, “The multitenant architecture
enables an Oracle database to function as a multitenant container database
(CDB) that includes zero, one, or many customer-created pluggable databases
(PDBs). A (more...)
IOUG is organizing a two-day virtual Exadata Conference on 29-30 Jan, 2014. More importantly the virtual conference is FREE
. Following is the agenda as per the IOUG's website:
Minimizing Risks with Database Consolidation on Exadata using I/O Resource Manager (IORM)
Speaker: Sameer Malik, Exadata Technical Architect, Accenture
|11am-12pm CST |
Introduction to the New Oracle Database In-Memory Option
Speaker: Kevin Jernigan, Senior Director, Oracle
I installed Oracle Enterprise Manager Cloud Control 12c soon after it's release in a virtual environment for the purpose of testing. I normally save passwords, ip-address, ports, and other details in a text file. But unfortunately, I was not able to locate the file for this particular VM.
However, it (more...)
I found the following Database Architecture Diagram for Oracle Database 12c on Oracle Education's website. It lists all the processes and the relationship between processes and other database components. I recommend you to take a print on A3 paper.
And below is a YouTube link which gives database architecture overview.
There are different ways of upgrading to the latest release
of Oracle database and Oracle provides multiple methods to upgrade. Few are
- Database Upgrade Assistant (DBUA)
- Manual Upgrade
- Transportable Tablespaces
- Datapump export/import
- Oracle Streams
- Oracle GoldenGate
I chose DBUA to upgrade my test database as it was the
Today while installing Oracle 11gR2 (18.104.22.168) 64-bit on RHEL 6.1 64-bit on a VMWare box, I received the mentioned error. Looking up at MOS wasn't fruitful. However, this seems to be an RHEL bug.
Starting Oracle Universal Installer...
Checking Temp space: must be (more...)
To be frank, I consider myself novice when it comes to
advanced export/import requirements. This is because I don’t deal with these
utilities on a day-to-day basis.
A simple requirement came across my desk to export selected
tables from a schema based on a common filter.
Say, you have 5 tables T1, T2, T3, T4, and T5. All have “ID”
as the primary key column and you have to export data from these tables only if
it is found in COMMON_TABLE. The COMMON_TABLE stores “ID” to be exported.
The first place that I look for solution is “Oracle
Starting with RACcheck 2.2.0, RACcheck support is extended to Oracle Single Instance Databases, Oracle Restart and RAC One Node configurations.
I downloaded the latest version of the tool and tested it against my play database. Below is a sample RACcheck output from a single instance database:
[oracle@localhost raccheck]$ ./raccheck -v
RACCHECK VERSION: 2.2.0_20121109
List of running databases
Select databases from list for
checking best practices. For multiple databases, select 1 for All or comma
separated number like 1,2 etc [1-2].
Blogging right from Tom's session "database new features". Here are the new features as they are discussed:
1. Identity Columns
Remember I blogged on this topic earlier.
2. Default on null
A default value is inserted into the column When it's null.
3. Improved defaults - metadata only defaults
Now add new default columns to a table on the fly. 12c does that for you.
4. Increased size limit for Varchar2 and NVarchar2
The column types can be upto 32k.
5. Row Pattern Matching
Efficient SQL functionality for reporting row patterns like identifying V and W patterns for your stock
I would like to thank all the attendees for attending my session "Very Large Databases (VLDB): Challenges and Opportunities". I am glad, the hall was full to it's capacity. :)
You may download the presentation by logging into OOW-2012 schedule builder.
I request all the attendees to kindly rate my session by logging into OOW: Schedule Builder.
See you all !!!