Menu
Your Cart

Oracle Database

Oracle Database

Need more information on this product?

Please contact us on +44 (0)20 8733 7100 or via our online form.

Contact Us

If you are not currently a customer, you can apply for an account.

Register here


  • SKU: ORACLEE
Oracle Oracle


Relational database management system providing a full range of tools that encompass all areas of data processing and storage. Editions are built using a common code base, enabling database applications to scale without the need to change code.

Oracle Database is a relational database management system providing a full range of tools that encompass all areas of data processing and storage. This product provides the foundation for IT to successfully deliver more information with higher quality of service, reduce the risk of change within IT and make more efficient use of their IT budgets.

By deploying Oracle Database their data management foundation, organisations can utilise the database to: reduce server costs, reduce storage requirements, improve mission critical systems performance, increase DBA productivity, eliminate idle redundancy in the data centre, simplify their overall IT software portfolio, cluster and consolidate enterprise application databases onto fast, reliable and scalable private clouds, accelerate performance by compressing data onto low-cost storage partitions, cecurely protect information and enable compliance.

Oracle Database is available in the following editions:

  • Express Edition
    Is an entry-level, small-footprint database based on the Oracle Database 11g Release 2 code base.  It is free to develop, deploy and distribute; fast to download; and simple to administer.
  • Standard Edition
    Is a full-featured database for servers with up to four sockets. It includes Oracle Real Application Clusters for higher availability, provides enterprise-class performance and security, is simple to manage and can easily scale as demand increases.
  • Standard Edition One
    Is a full-featured database for servers with up to two sockets. It provides enterprise-class performance and security, is simple to manage and can easily scale as demand increases.
  • Enterprise Edition
    Delivers scalability, security and reliability on a choice of clustered or single-servers running Windows, Linux and UNIX. It provides comprehensive features to easily manage the most demanding transaction processing, business intelligence and content management applications.

All editions are built using the same common code base, which means users database applications can easily scale from small, single-processor servers to clusters of multi-processor servers without changing a line of code.


Oracle Database - Features

Feature

Editions
High Availablity Express Edition Standard Edition One Standard Edition Enterprise Edition
Oracle Active Data Guard
Provides secure, efficient, easy-to-use and application-transparent solution for long-term storage of historical data.		 Option
Data Guard Yes
Transaction Guard Yes
Cross-Platform Recovery Yes
Cross-Platform Backup Yes
Fail Safe
Configure, verify Windows clusters and automatically fail over fast and accurately through high availability software integrated with Microsoft Cluster Server.		 Yes Yes Yes
Flashback Query
Recover older versions of data without complex, time-consuming operations.		 Yes Yes Yes Yes
Flashback Table, Database and Transaction Query
Diagnose and undo errors to reduce recovery time.		 Yes
Oracle Secure Backup
Secure, high performance tape backup management for the Oracle Database and heterogenous file systems reducing the cost and complexity of networked data protection.		 Oracle Secure Backup is its own product that works with each database edition
Server Managed Backup and Recovery
Simplify, automate, and improve backup and recovery performance with Oracle Recovery Manager (RMAN).		 Yes Yes Yes
Scalability Express Edition Standard Edition One Standard Edition Enterprise Edition
Oracle Real Application Clusters
Run any packaged or custom application unchanged across multiple connected, or "clustered," servers.		 Yes Option
Oracle Real Application Clusters One Node
-Oracle RAC One Node is the one-node version of Oracle RAC which enables customers to standardise on a single deployment model for all their database needs.		 Option
Adaptive Execution Plans
 Yes
Integrated Clusterware
Built-in clustering services to protect any Oracle application or any other kind of application within a cluster.		 Yes Yes Yes
Automatic Workload Management
Route service connection requests to appropriate server with lowest load; on failure, automatically reallocate surviving servers to services.		 Yes Yes
Java, PL/SQL Native Compilation
Write stored procedures deployed in the database in both Java and PL/SQL. 		PL/SQL only Yes Yes Yes
Oracle In-Memory Database Cache
Increases responsiveness and throughput by caching frequently used data in memory. 		Option
Security Express Edition Standard Edition One Standard Edition Enterprise Edition
Data Masking
 Requires Oracle Data Masking Pack
Real Application Security
 Yes
Oracle Database Vault
Restricts super-user and privileged-user access across applications and data.		 Option
Oracle Audit Vault and Database Firewall
Automates the collection and analysis of audit data from multiple systems, turning audit data into a key security resource.		 Oracle Audit Vault is its own product that works with each database edition
Oracle Advanced Security
Address privacy and compliance requirements.		 Option
Oracle Label Security
Provides out-of-the-box row-level security. Compare user security clearances with data classification labels attached to data rows. Read More		 Option
Secure Application Roles
Enable roles only after a user passes any number of security checks.		 Yes
Oracle Virtual Private Database
Enforce data security and privacy with customisable, policy-based access control down to the row level.		 Yes
Fine-Grained Auditing
Allows highly focused auditing with almost no 'background noise'.		 Yes
Proxy Authentication
Detects and authenticates users connecting through a middle-tier application.		 Yes Yes Yes
Data Encryption Toolkit
Protect vital data by providing an extra layer of protection for data on storage media.		 Yes Yes Yes Yes
Application Development Express Edition Standard Edition One Standard Edition Enterprise Edition
Oracle Oracle Flashback Data Archive
   Yes Yes Yes
SQL Pattern Matching
   Yes Yes Yes
Temporal Database
   Yes Yes Yes
Oracle SQL Developer
 Yes Yes Yes Yes
Oracle Application Express
Develop and deploy fast, secure applications with a rapid web application development 		Yes Yes Yes Yes
Java Support
Grid-enable databases through Web Services		 Yes Yes Yes
Comprehensive XML Support
Store and retrieve XML natively with support for the W3C XML data model; use standard access methods for navigating and querying XML. 		Yes Yes Yes Yes
PL/SQL and Java Server Pages
Utilise a server-side Java and stored procedural language; secure, portable and seamless with SQL.		 PL/SQL only Yes Yes Yes
Comprehensive Microsoft .Net Support, OLE DB, ODBC
Support multiple Windows data access methods.		 Yes Yes Yes Yes
Manageability Express Edition Standard Edition One Standard Edition Enterprise Edition
Oracle Real Application Testing
Reduces risk and costs of adopting new technologies, whether it's operating systems, servers, or software.		 Option
Oracle Enterprise Manager
Manage and monitor all applications and systems based on the Oracle stack via a single, integrated console.		 Yes Yes Yes
Automatic Memory Management
Automate management of shared memory used by an Oracle Database instance.		 Yes Yes Yes Yes
Oracle Automatic Storage Management
Consistent storage management interface across all server and storage platforms.		 Yes Yes Yes
Automatic Undo Management
Monitor configuration of all Oracle systems for parameter settings, security set-up, storage and file space conditions.		 Yes Yes Yes Yes
Data Warehousing Express Edition Standard Edition One Standard Edition Enterprise Edition
Oracle Advanced Compression
Compresses all types of data, including structured and unstructured data, to help you use resources more efficiently and lower storage costs.		 Option
Oracle OLAP
Use built-in analytical workspaces for Online Analytical Processing (OLAP).		 Option
Oracle Partitioning
Enables large tables and indexes to be split into smaller, more manageable components, without requiring changes to underlying applications.		 Option
Oracle Advanced Analytics
 Option
Transportable Tablespaces, Including Cross-Platform
Transport a set of tablespaces from one database to another, or from one database to itself.		 Yes
Star Query Optimisation
Join a fact table and a number of dimension tables.		 PL/SQL only Yes Yes Yes
Information Lifecycle Management
Understand how data evolves, determine how it grows, monitor how its usage changes and decide how long it should be kept.		 Yes
Summary Management - Materialised View Query Rewrite
Automatically recognising materialised view usage to satisfy requests.		 Yes
Integration Express Edition Standard Edition One Standard Edition Enterprise Edition
Basic Replication
   Yes Yes Yes
Distributed Queries/Transactions
Query or update data on two or more distinct nodes of a distributed database.		 Yes Yes Yes Yes

Unstructured Data Management

 Express Edition Standard Edition One Standard Edition Enterprise Edition
Oracle Spatial and Graph
Support for sophisticated GIS deployments.		 Option
XML DB
High-performance, native XML storage and retrieval technology.		 Yes Yes Yes Yes
Multimedia
Develop, deploy, and manage traditional, Web, and wireless applications that include rich media in the most-popular formats.		 Yes Yes Yes
Text
Build text query applications and document classification applications.		 Yes Yes Yes Yes
Locator
Manage geospatial data to leverage the business value of location.		 Yes Yes Yes Yes
Oracle Secure Enterprise Search
Internet-like search experience to users searching secure content inside the enterprise while protecting sensitive data from unauthorised users.		 Oracle Secure Enterprise Search is its own product that works with each database edition

Back to top


Oracle Database - System Requirements

Key System Requirement Express EditionStandard Edition OneStandard EditionEnterprise Edition
Maximum 1CPU 2 Sockets 4 Sockets No limit
RAM 1 GB OS Max OS MaxOS Max
Database size 11 GB No limitNo limitNo limit
Windows Yes YesYesYes
LinuxYesYesYesYes
UnixYesYesYes
64 Bit SupportYesYesYes