Month: December 2012

Oracle SQL Developer Book?

I’m frequently asked about books for SQL Developer. There are a few out there, with the most obvious example being from former Product Manager Sue Harper. I love books, and I’m a voracious reader. But books pose a few problems in the techie space: they are out of date the day they are printed they […]

Nexus 4 : Crappy Design…

I had a HTC Wildfire for 2 years without any problems. Now, 2 days after posting about getting a Nexus 4, the glass on the back panel is broken. I hadn’t even taken off the protective sheets yet. The design of this back panel is a complete pile of shit! Why would you possible want […]

Cold Days…

Cold Days is the latest book in The Dresden Files series by Jim Butcher. So Harry is alive again and now he’s the Winter Knight. The enforcer for Mab, the crazy queen of the Winter Fairies. Maybe staying dead was the better option. So what’s the first thing Mab orders Harry to do? Kill an immortal, whilst fighting an […]

Top 10 postings in 2012

The following postings got most of your views here in 2012: 1. adrci: A survival guide for the DBA Many DBAs used this article to get a quick start with the new Automatic Diagnostic Repository feature in 11g. Although it is pretty much everything also documented, it requires quite an effort to dig through it […]

A tip for lazy Oracle users – type less with ANSI DATE and TIMESTAMP SQL syntax

I am lazy, therefore if I can type less, I will type less. Often people are surprised to see that Oracle supports the ANSI DATE and TIMESTAMP syntax in the SQL code, which allows me to shorten the lengthy TO_DATE( …. , ‘YYYY-MM-DD HH24:MI:SS’) syntax a bit. You can just type this if you want […]

Book on OEM 12c

My friend and former ACE Director Porus Homi Havewala’s new book on Oracle Enterprise Manager 12c Cloud Control, is now available.  This is the first published EM 12c Cloud Control book in the world.If you are interested in learning abou…

Nexus 4…

I accidentally bought a Nexus 4… I had been thinking about getting a new phone for some time and the talk of the Nexus 4 peaked my interest. Even so, I’m one of those rare people that prefers a small phone and typically uses a mobile phone as just a phone. I always have a […]

Differences of Oracle Database Editions

My  friend asked me what is the differences of  Oracle Database Editions? I answered his question and I sent him a  information for this topic from Oracle Documentation Library : Oracle® Database Licensing Information 11g Release 2 (11.2). 

I want share with you a following table from documentation, too. This tables shows  Feature Availability for Oracle Database Editions. 

SE1 – Oracle Database Standard Edition One
SE   – Oracle Database Standard Edition 
EE   – Oracle Database Enterprise Edition 

Feature/Option SE1 SE EE Notes
High Availability
Oracle Fail Safe
Y
Y
Y
Windows only
Oracle RAC One Node
N
N
Y
Extra cost option
Oracle Data Guard—Redo Apply
N
N
Y
Oracle Data Guard—SQL Apply
N
N
Y
Oracle Data Guard—Snapshot Standby
N
N
Y
Oracle Active Data Guard
N
N
Y
Extra cost option
Rolling Upgrades—Patch Set, Database, and Operating System
N
N
Y
Online index rebuild
N
N
Y
Online index-organized table organization
N
N
Y
ALTER TABLE … MOVE ONLINE operations
Online table redefinition
N
N
Y
Using the DBMS_REDEFINITION package
Duplexed backup sets
N
N
Y
Block change tracking for fast incremental backup
N
N
Y
Unused block compression in backups
N
N
Y
Block-level media recovery
N
N
Y
Lost Write Protection
N
N
Y
Automatic Block Repair
N
N
Y
Requires Oracle Active Data Guard option
Parallel backup and recovery
N
N
Y
Tablespace point-in-time recovery
N
N
Y
Trial recovery
N
N
Y
Fast-start fault recovery
N
N
Y
Flashback Table
N
N
Y
Flashback Database
N
N
Y
Flashback Transaction
N
N
Y
Flashback Transaction Query
N
N
Y
Flashback Data Archive (Total Recall)
N
N
Y
Requires Oracle Advanced Compression option
Scalability
Oracle Real Application Clusters
N
Y
Y
Extra cost with EE, included with SE
Automatic Workload Management
N
Y
Y
Requires Oracle Real Application Clusters
Quality of Service Management (Measure-Only Mode)
N
N
Y
Requires Oracle Real Application Clusters
Available starting with Oracle Database 11g Release 2 (11.2.0.3)
Performance
Client Side Query Cache
N
N
Y
Query Results Cache
N
N
Y
PL/SQL Function Result Cache
N
N
Y
In-Memory Database Cache
N
N
Y
Extra cost option
Database Smart Flash Cache
N
N
Y
Solaris and Oracle Linux only
Support for Oracle Exadata Storage Server Software
N
N
Y
Security
Oracle Advanced Security
N
N
Y
Extra cost option
Oracle Label Security
N
N
Y
Extra cost option
Virtual Private Database
N
N
Y
Fine-grained auditing
N
N
Y
Oracle Database Vault
N
N
Y
Extra cost option
Enterprise User Security
N
N
Y
End User Security with password authentication is an EE feature requiring OID to be licensed.
End User Authentication with strong authentication (PKI, Kerberos, Radius) is an EE feature requiring Oracle Advanced Security and OID to be licensed.
Development Platform
SQLJ
Y
Y
Y
Requires Oracle Programmer
Oracle Developer Tools for Visual Studio .NET
Y
Y
Y
Windows only
Microsoft Distributed Transaction Coordinator support
Y
Y
Y
Windows only
Active Directory integration
Y
Y
Y
Windows only
Native .NET Data Provider—ODP.NET
Y
Y
Y
Windows only
.NET Stored Procedures
Y
Y
Y
Windows only
Manageability
Oracle Change Management Pack
N
N
Y
Extra cost option
Oracle Configuration Management Pack
N
N
Y
Extra cost option
Oracle Diagnostics Pack
N
N
Y
Extra cost option
Oracle Tuning Pack
N
N
Y
Extra cost option, also requires the Diagnostics Pack
Oracle Provisioning and Patch Automation Pack
N
N
Y
Extra cost option
Oracle Real Application Testing
N
N
Y
Extra cost option
Database Resource Manager
N
N
Y
Instance Caging
N
N
Y
SQL Plan Management
N
N
Y
VLDB, Data Warehousing, Business Intelligence
Oracle Partitioning
N
N
Y
Extra cost option
Oracle OLAP
N
N
Y
Extra cost option
Oracle Advanced Analytics
N
N
Y
Extra cost option
Oracle R Enterprise Server is limited to operation on Oracle Linux 5 Update 6 or higher and Red Hat Enterprise Linux 5 Update 6 or higher
Oracle Advanced Compression
N
N
Y
Extra cost option
Hybrid Columnar Compression
N
N
Y
Requires Exadata, ZFS, or Pillar Axiom 600 storage
Basic Table Compression
N
N
Y
Deferred Segment Creation
N
N
Y
Bitmapped index, bitmapped join index, and bitmap plan conversions
N
N
Y
Parallel query/DML
N
N
Y
Parallel statistics gathering
N
N
Y
Parallel index build/scans
N
N
Y
Parallel Data Pump Export/Import
N
N
Y
In-memory Parallel Execution
N
N
Y
Parallel Statement Queuing
N
N
Y
Parallel capture and apply via XStream
N
N
Y
Transportable tablespaces, including cross-platform
N
N
Y
Import of transportable tablespaces supported into SE, SE1, and EE
Summary management—Materialized View Query Rewrite
N
N
Y
Asynchronous Change Data Capture
N
N
Y
Integration
Basic Replication
Y
Y
Y
SE1/SE: read-only, updateable materialized view
Advanced Replication
N
N
Y
Multi-master replication
Oracle Streams
Y
Y
Y
SE1/SE: no capture from redo
Database Gateways
Y
Y
Y
Separate product license
Messaging Gateway
N
N
Y
Networking
Oracle Connection Manager
N
N
Y
Available via a custom install of the Oracle Database client, usually installed on a separate machine
Infiniband Support
N
N
Y
Content Management
Oracle Spatial and Graph
N
N
Y
Extra cost option
Semantic Technologies (RDF/OWL)
N
N
Y
Requires the Oracle Spatial and Graph option and the Oracle Partitioning option
Spatial and Location Data
Parallel spatial index builds
N
N
Y
Multimaster replication of SDO_GEOMETRY objects
N
N
Y
Single master/materialized view replication for SDO_GEOMETRY objects is supported with both Standard Edition and Enterprise Edition
Partitioned spatial indexes
N
N
Y
Requires the Oracle Partitioning option

Regards
Mahir M. Quluzade

Quiz Night

Here’s a little puzzle if you have nothing better to do between now and the new year. The following extract came from 11.2.0.3, but could have come from 10.2.0.5 or 9.2.0.8 (and many others). I’ve got a simple heap table where the last thing I (or anyone) did was “alter table t1 move” before dumping […]

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569