Category Archives: Oracle

What is multitenancy? Why it’s becoming so important?

The term “Software Multitenancy” refers to a software architecture in which a single instance of software runs on a server and serves multiple tenants. A tenant is a group of users who share a common access with specific privileges to … Continue reading

Posted in Cloud Computing, Database Technologies, Emerging Trends, Oracle | Leave a comment

Oracle 12c top 12 features

Tom Kyte has picked his top 12 features of Oracle Database 12c and put them into a presentation. Here are his picks: Even better PL/SQL from SQL Improved defaults Increased size limits for some datatypes Easy top-n and pagination queries … Continue reading

Posted in Database Technologies, Oracle | Tagged , , | Leave a comment

In-Memory Column Store in Oracle Database 12c Release 1 (12.1.0.2)

In-Memory Column Store in Oracle Database 12c Release 1 (12.1.0.2) In-Memory Column Store feature in Oracle Database 12c Release 1 (12.1.0.2) promises to address such kind of real-time reporting and statistic requirements at ease. This feature offers users best of … Continue reading

Posted in Cloud Computing, Database Technologies, Oracle | Tagged , , , , , , , , | Leave a comment

Re-Organize / Defrag database schema using ALTER TABLE MOVE TABLESPACE option

There are several ways for a complete reorganization and space reclamation:- EXPORT/IMPORT DBMS_REDEFINITION CREATE TABLE AS SELECT (CTAS) DATA PUMP ALTER TABLE MOVE TABLESPACE This post provides a trick to reorganize all schema objects using the following script using ‘ALTER TABLE MOVE TABLESPACE’ … Continue reading

Posted in Database Technologies, Oracle | Tagged , , , , , , | Leave a comment

Oracle Database License price with OEM

Product Named-User License Processor License Oracle Database Server Standard Edition One $180 $5,800 Standard Edition $350 $17,500 Enterprise Edition: $950 $47,500     – Real Application Clusters (RAC) $460 $23,000     – Active Data Guard $120 $5,800     … Continue reading

Posted in Oracle | Tagged , , | Leave a comment

Oracle Database 12c : Deprecated and Desupported Features

Oracle Database Changes Oracle Database 12c introduces changes that affect Oracle Database in general. This section contains these topics: Deprecation of catupgrd.sql Script and Introduction of New catctl.pl Utility Desupport of Oracle Enterprise Manager Database Control Changes for Deinstallation and Cleanup … Continue reading

Posted in Database Technologies, Oracle | Tagged , , , | Leave a comment

AMM vs ASSM : Oracle Auto Memory Management

When you have large SGA sizes you can get considerable benefits from using HugePages. Automatic Memory Management ( AMM) and HugePages on Linux are not compatible, which means AMM is probably not a sensible option for any large systems. Instead, … Continue reading

Posted in Database Technologies, Oracle | Tagged , , , | Leave a comment