System News
 1 2 3 4 5 6 7 8 9 10 11 next
Archived Oracle Articles
20 Mar 2017
open to premium members only
Oracle Database 12c Release 2: Analytic Views & SQL Developer [61839]
By Jeff Smith

One of the major new features in Oracle Database 12c Release 2 is Analytic Views

Jeff Smith writes, "An analytic view is a type of view that can be used to easily extend the content of a star schema with aggregated data, measure calculations and descriptive metadata, and to simplify the SQL needed to access data.

Analytic views layer a hierarchical/dimensional model over data. Analytic views are defined over the dimension tables and fact table of a star schema. Hierarchies are defined over dimension tables. The analytic view references hierarchies and a fact table.

I'm not here to introduce this new feature itself, more just to let you know that Oracle SQL Developer v4.2 has a TON of support for it - courtesy the same team that built this database feature.

If you'd like to take a tutorial on this subject, LiveSQL has a nice on-line demo - no database required!..."
(Get More Information . .)

07 Mar 2017
open to premium members only
E-Business Suite 12.2 Certified with Oracle VM 3 [61395]
By Steven Chan, March 7th, 2017

Steven blogs, "Oracle VM 3.4 is the latest release of Oracle's server virtualization and management solution released as Oracle vM Server for x86 and Oracle VM Manager. Oracle VM 3.x is certified with E-Business Suite 12.2.x. This certification covers all current and future Oracle VM 3 updates including subsequent 3.x releases.

Oracle VM 3 was previously certified with Oracle E-Business Suite 11i, 12.0, and 12.1..."
(Get More Information . .)

02 Mar 2017
open to premium members only
Oracle Database 12c Release 2 is Now Available ... and so is our New VirtualBox Appliance! [61188]
By Jeff Smith

"Want to get started on learning everything there is to know about the latest version of our Database?

Don't want to really have to install or create anything?

Well, you're in luck.

Just go download our image...
(Get More Information . .)

13 Feb 2017
open to premium members only
Oracle Database 12.2 for Exadata/SuperCluster available [60737]
By Mike Dietrich, February 13th, 2017

Mike blogs, "Oracle Database 12.2.0.1 on-premises for Exadata and SuperCluster is now available for download from Oracle eDelivery/SoftwareCloud...

Please be aware that the software can be installed on Oracle Exadata and Oracle SuperCluster ONLY. To take advantage of the full potential of Oracle Database 12c Release 2 you should upgrade to the latest Exadata Software Release 12.2.1.1.0 before upgrading databases to 12c Release 2. Exadata Software 12.2.1.1.0 supports Smart Scan functionality for Oracle Database 12c Release 2 and is available via OSDC..."
(Get More Information . .)

30 Jan 2017
open to premium members only
New Product Launch: Oracle Database Programming Interface for C (ODPI-C) [60308]
By Christopher Jones, January 30th, 2017

Christopher blogs, "Oracle released a great new GitHub project - Oracle Database Programming Interface for C. It sits on top of OCI and offers an alternative programming experience.

  • ODPI-C is a C library that simplifies the use of common Oracle Call Interface (OCI) features for Oracle Database drivers and user applications.

ODPI-C's goal is to expose common OCI functionality in a readily consumable way to the C or C++ developer. OCI's API is extremely flexible and is highly efficient. It gives a lot of fine-grained control to the developer and has a very wide range of use cases. ODPI-C is also flexible but is aimed primarily at language driver creators. These creators are programming within the confines of a scripting language's type system and semantics. The languages often expose simplified data access to users through cross-platform, 'common-denominator' APIs. Therefore it makes sense for ODPI-C to provide easy to use functionality for common data access, while still allowing the power of Oracle Database to be used..."
(Get More Information . .)

12 Jan 2017
open to premium members only
GoldenGate 12c Certified with E-Business Suite 12.2 [59677]
By Steven Chan, January 12th, 2017

Steven blogs, "Oracle GoldenGate provides real-time capture, transformation, routing, and delivery of database transactions across heterogeneous systems. The GoldenGate Administrator's Guide shows six supported topologies for generic databases. Oracle GoldenGate 12c is now certified for a subset of three of those methods in Oracle E-Business Suite Release 12.2 environments:..."
(Get More Information . .)

 
 1 2 3 4 5 6 7 8 9 10 11 next