2012/12/28

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/OptionSE1SEEENotes
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

2012/12/03

Last meeting of the year 2012 - AZEROUG

At 01.12.2012 I attended AZEROUG (Azerbaijan Oracle User Group) - Last meeting of the year 2012 at Qafqaz University. 

This meeting is started with  speech of  Kamran Agayev, Oracle ACE Director (www.kamranagayev.com). Kamran spoke about AZEROUG meetings of this year and thanked all  users.

Kamran Agayev  


Technical part of this meeting is started with  Ulfet Tanriverdiyev's (ulfet.blogspot.com) session. Ulfet's topic is Oracle Streems : general concepts and hand-on demo. He talked about streems very good , oracle replication technology and end of the session  he showed very  interesting video demo. 



Ulfet Tanriverdiyev


We planed  two  technical  session for this meeting. Last session of this meeting was my session. I talked about Oracle ASM technology with topic Oracle ASM : Most asked 5 question.  I showed video demo, Migration database to ASM with RMAN.




Mahir M. Quluzade
My special  thanks to rector of Qafqaz University and thanks all  users of Azerbaijan Oracle User Group.

Members of Azerbaijan Oracle User Group

See you next meetings next year ! 

Mahir 

My presentation :  Oracle ASM : Most asked 5 question
(in Azerbaijani  - Oracle ASM : Ən çox soruşulan 5 sual)

Oracleasm - Instantiating disk : failed

When I configure ASM disks with ASMLib on Oracle Linux 6.2
I got a error


This error is depend  with  SELinux. I  forget set disabled SELinux configuration.

You can disable SELinux on duration of installation Linux



or after installation with change /etc/selinux/config




It is very important for correct operations!

And following video demo showing solve problem when oracleasm createdisk fails.




You can found Oracle Support note : oracleasm createdisk fails with selinux enabled [ID 1430947.1]

Oracle recomended is disable SELinux before installation Oracle RAC!


Regards
Mahir M. Quluzade

2012/10/23

Oracle RAC Traning


I completed, "Oracle 11g: RAC and Grid Infrastructure Administration Accelerated Release 2" course at "Metod Oracle Academy" in Istanbul / Turkey with Oracle Instructor, Oracle Certified Master - Cem Zorba. 


Me with Oracle Instructor,
OCM Cem Zorba

Cem Zorba is very experienced oracle expert and very nice speaker. I got enjoy to talk about Oracle with OCM Cem Zorba. He gave very  additional information from Oracle RAC duration of course.

2012/10/22

The biggest event of the year in Turkey : TROUG DAY2012

TROUG DAY2012 was started with  Keynote: High Availability 11g New Features  by  Syed Jaffar Hussain (OCM, Oracle ACE Director, DBA of the year 2011). His presentation is created very professional and he spoke new features Oracle Real Application Clusters and Syed shared with us his valuable experiences.

Syed Jaffar Hussain
Syed Jaffar Hussain
After keynote of Syed, TROUG DAY'12 was continued with two streams, DBA and Develeper Stream. I attended to  DBA Stream. 

DBA Streem was continued with Husnu Sensoy's (Oracle ACE Director, DBA of the year 2009) session, his presentation was very interesting for me, he talk about System Design for Million TPS and shared very valuable information.

Husnu Sensoy
After Husnu, sessions continued with  Gokhan Atil's (Oracle ACE)  session. His presentation was very interactive with questions, he was talk about EM 12c Database as a Service.

Gokhan Atil
Orhan Biyiklioglu was spoke about Oracle Cluster Internals. His session was very interesting for me and he was spoke very well about Evictions in Oracle RAC.

Orhan Biyiklioglu
Before my session Talip Hakan Ozturk (Oracle ACE) was spoke about Real Application Testing. He was showed very interesting video demos in presentation.

Talip Hakan Ozturk
Last session of TROUG DAY2012 DBA Stream, I spoke about Oracle Data Guard Heteregenous Data Guard Configurations (in Turkish). I showed video demo, oracle data guard configuration with Linux and Windows.


My session at TROUG DAY 2012

My session at TROUG DAY 2012

I'm very glad there was an opportunity to meet and talk with my friend during the TROUG DAY12. I  want share with you  my other photo with Oracle ACE and ACEDs.

Me with Oracle ACE Director, OCM, DBA of the year 2011
Syed Jaffar Hussain

Me with Oracle ACE Emre Baransel

Me with Oracle ACE Gunes Erol.

Me with Oracle ACE Director, DBA of the year 2009
Husnu Sensoy

Me with Oracle ACE Talip Hakan Ozturk

Me with Talip and Husnu
TROUG DAY12 was very biggest Oracle event of this year. My  special thanks to organizators and managers of TROUG.

Thanks TROUG!
Mahir M. Quluzade