Macrotone Blogs

Macrotone blogs upon Joomla, our products and other matters.

Oracle–Flashback Query

oracleWay back in 2001 Oracle announced Oracle9i with a new feature named ‘Flashback Query’. The implication was that Flashback technology would permit one to query past data, no matter how old it was days, weeks or even months old. In fact the actuality was very different since Flashback Query relied upon the undo information contained within the database Undo-Segments.

Later releases refined what was possible. It was named ‘Total Recall’ in Oracle 11g, and now goes by the name of ‘Flashback Data Archive’.  This recent blog goes into a little detail of the recent changes available in Oracle release 12c.

It is an easy read, but at the back of the mind one can’t help but think how much disk storage is required on a busy site to enable one to search back over long periods of time. The feature is useful, and is available ‘free-of-charge’ with all versions of Oracle 12c,  but at what cost in terms of system resources and performance?

Oracle Database 12c (12.1.0.1.0) released for Windows 64bit

oracleWe note that Oracle has now released the latest version of its database for Windows 64bit to go with the earlier released Solaris (Sparc and x86-64)  and Linux platform versions. Interested readers can obtain a copy from Oracle via its Technet site.

The official release docs follow:

Oracle Database 12c, the latest generation of the world’s most popular database, has been developed for the Cloud and will enable customers to make more efficient use of their IT resources while continuing to improve their users’ service levels. In addition to a raft of enhancements and new features, including a new architecture, Oracle Database 12c makes it easier for customers to take advantage of the Cloud through:

bullet  Consolidating multiple databases with Oracle Multitenant

bullet  Automatically optimizing data storage and compression according to usage patterns

bullet  Providing continuous access with Oracle’s Maximum Availability Architecture

bullet  Securing enterprise data with comprehensive defense-in-depth strategy

bullet  Simplifying in-database analysis of Big Data

bullet  Efficient database management using Enterprise Manager Cloud Control

Free Toad for Oracle 12.0.0.61 released

Toad World - Connected IntelligenceWe are pleased to note the release of Toad for Oracle 12c is available on the Toadworld site. This is hot after the official Oracle release itself.

We have used the tool for more years than we care to remember, and it is highly recommended. They are invaluable for good database development and support.

Oracle Database 12c (12.1.0.1.0) released for Solaris and Linux

oracleWe note that Oracle has released the latest version of its database for Solaris (Sparc and x86-64)  and Linux platforms. The release for Windows is not yet available. Interested readers can obtain a copy from Oracle via its Technet site.

The official release docs follow:

Oracle Database 12c, the latest generation of the world’s most popular database, has been developed for the Cloud and will enable customers to make more efficient use of their IT resources while continuing to improve their users’ service levels. In addition to a raft of enhancements and new features, including a new architecture, Oracle Database 12c makes it easier for customers to take advantage of the Cloud through:

bullet  Consolidating multiple databases with Oracle Multitenant

bullet  Automatically optimizing data storage and compression according to usage patterns

bullet  Providing continuous access with Oracle’s Maximum Availability Architecture

bullet  Securing enterprise data with comprehensive defense-in-depth strategy

bullet  Simplifying in-database analysis of Big Data

bullet  Efficient database management using Enterprise Manager Cloud Control

DBMS_FEATURE_USAGE_REPORT

oracleRead an interesting article/blog post upon the Oracle package DBMS_FEATURE_USAGE_REPORT that once one ignored the ‘Star Wars’ trivia, brought back recollections of the scripts that I used to run to achieve the same results. i.e.  Produce evidence that the company was only using certain features of the Oracle product, which in turn influenced the ‘price’ that one paid to Oracle Corporation for the licenses.

Tags:

Moving APEX application to the Oracle cloud

Just read an interesting blog post about moving an Oracle APEX application to the Oracle cloud.  Interesting because I have previously used APEX and migrated some of the apps to Joomla.

Tags:

Oracle 12c - Pluggable databases.

oracle
Larry Ellison at the Oracle OpenWorld conference earlier this week, provided the information that the forthcoming Oracle Database 12c (the c standing for ‘cloud’) will  feature a radical new architecture called pluggable databases.

Currently a server running an Oracle database has an individual set of server processes.  Adding a second database to the server adds additional processes for the second database.  Pluggable databases will allow multiple databases to run under one copy, or instance, of the Oracle database software, a feature he called "multitenancy."

As the name implies, pluggable databases allow multiple tenant databases to run under one copy of Oracle 12c.  An arbitrary number of up to 250 user databases, can be run under the new architecture, and the architecture could probably support more. The new database is reportedly compatible with older Oracle databases.

This change in architecture brings a number of benefits that Oracle touted through the week, including improved efficiency, stronger security and easier upgrades.

However there are a few challenges for database administrators especially in the area of allocation computational resources. How will the new workload characteristics of running multiple databases on a single server be determined. The characteristics of the optimum size of a server, in reference to memory and storage space, may also/will need to be reconsidered.

Interesting times lay ahead.  Oracle Database 12c is set for availability in 2013.

New Releases Oracle SQL*Developer * SQL*Developer Modeller

Having been busy recently I nearly missed the recent announcement of Oracle SQL*Developer 3.2.0.09.30 and SQL*Developer Data Modeller 3.1.2 (704).

Both available on Oracle Technet.

Oracle Goldengate


I was talking with a colleague the other day about Oracle Goldengate and it was strange that I saw this article which describes the recent release. Having used the product and its ‘relation’ Streams, it was interesting to catch up on the recent changes.

Tags:

End of the line for Oracle Discoverer?

Having used Oracle Discoverer for many years and developed a few applications for clients using the tool, it was sad to see the statement of direction from Oracle in January 2009 encouraging users to migrate to Oracle Business Intelligence.

Whilst recognising that things cannot stand still Oracle Discoverer was a very good relatively light weight product.  Oracle Business Intelligence whilst being a good product doesn't really class as light weight, which ever way one looks at it, requiring a Web server and all that that entails.

This recent article is just another encouragement to those Discoverer users to migrate.  Could we soon be seeing the nail in the Discoverer coffin?

Go To Top

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries