Sunday, September 17, 2017

Oracle preps autonomous database at OpenWorld

Oracle preps autonomous database at OpenWorld

IMHO The new database version will probably use the Oracle Management Cloud (OMC) to monitor and tune, the OMC has machine learning using big data analytics to aid performance tuning. Since version 10g, the Oracle DB has had self-tuning capabilities, i.e. auto application of SQL profiles using the Tuning pack license. Everything else was done by the DBA, perhaps with advice gained from the Tuning Advisor, but the DBA had to make the final call. Probably the self-tuning has been carried further in the coming version with expertise from machine learning. Regarding AWS databases, I would agree that the AWS capability of performance insights is only at its starting stage so databases on AWS Aurora cant really be compared to what Oracle will offer in this regard.

Wednesday, September 13, 2017

No-Win, No-Fee Oracle Licensing Review Offer for your Oracle usage

Dear Friends,

As we all know, Oracle Licensing is a complex subject and a lack of its complete understanding can attract millions of dollars in contractual non-compliance during an official audit. Non-compliance on Oracle Licensing can be due to several reasons, including vague rules and inaccurate analysis. If your Oracle licensing is not fully managed or optimised, then you also risk over-paying for support costs that could have been avoided. Over-Licensing or Under-Licensing can both bring large financial exposure for an Oracle end-user organisation. 

Exclusively for the members/friends of our 'Oracle Senior DBA' group on Linkedin, we have negotiated with 'Konnagar Limited' >> << to help you reach a safe harbor with compliance on Oracle licensing. Konnagar Limited won the Gold Award from UK-OUG for 'Independent Services', and is run by Sibaji Dey Choudhury - an ex-Oracle License Auditor with 12+ years of Oracle licensing experience across 300+ customers. 

How is this a good proposition for you? Sibaji will run a complimentary Oracle License Review, exclusively for the members/friends of the group (you need not be a member, just mention the group). If any contractual non-compliance (and therefore, commercial exposure) is identified, only then you pay the fee for the engagement. If no non-compliance is identified, then you DO NOT pay anything. Simple! 

Please note that Konnagar Limited is independent of any Oracle partnership and also does not resell Oracle licenses (or recommend resellers), and therefore has no conflict of interest. The only objective is to help you uncover non-compliance arising out of mismanagement of Oracle Licensing. 

Please reach out to to register your interest. This offer is on a 'No-Win, No-Fee' basis exclusively for the members and/or friends of the 'Oracle Senior DBA' group, so please mention the group name in your email to them even if you are not a member.

Best regards, 

Porus Homi Havewala, 
Oracle Certified Master.

Sunday, August 27, 2017

Hands-on 5 week Sunday workshop for Oracle 12c RAC, ASM and Clusterware

My friend and fellow Oracle Certified Master Gavin Soorma is offering this five week online workshop on Sundays, which looks very interesting for people seeking to learn about these advanced Oracle technologies. 

This online training workshop will help you build your own personal two-node Oracle 12c Release 2 Real Application Cluster environment and learn in-depth about Oracle 12c RAC, ASM and Clusterware Administration.

The five week, 20 hour online workshop commencing on Sunday, September 10th will include hands-on lab exercises for each module (for which remote support will be provided) and cover a wide variety of topics including :

<> How to install and upgrade Oracle 12c (R1 and R2) Grid Infrastructure 
<> How to administer and manage Oracle Clusterware including Flex Clusters 
<> How to create and manage policy and admin-managed RAC databases 
<> ASM architecture, Diskgroups, ACFS, Flex ASM 
<> Applying a patch to Grid Infrastructure and Database Home
..... and more!

This course will cover the main topics from three separate Oracle University Courses (12c RAC Administration, 12c ASM Administration and 12c Clusterware Administration).

The cost of the training is 599.00 USD which would otherwise have costed close to 10,000 dollars for attending all three official Oracle University trainings! There is a further ten percent discount if you use the discount code mentioned below.

Kindly register for the training course via the URL mentioned below.

Registration URL:

On this form, type the discount code "OracleSeniorDBAGroup" in the Discount Code field for a further special TEN PERCENT DISCOUNT on the 599 USD cost of the course.

Porus Homi Havewala.

Tuesday, July 25, 2017

Licensing|Circle - Oracle Licensing Comprehensive training course (12 modules)

We finally can release the pre-launch discount code for Licensing|Circle - the comprehensive training course on Oracle Licensing. The discount code for the full course is "OracleSeniorDBA10" and this code is valid until 15-Aug-2017. The full course with 12 modules is here:

As mentioned earlier, Oracle Licensing can be a complex subject, and a lack of its understanding for Oracle professionals (including DBAs) could almost certainly lead to substantial financial risk exposure due to contractual non-compliance. To help avoid such scenarios, training on licensing is essential. Licensing|Circle is globally the first and only comprehensive & online training, reference, assessment and certification platform on Oracle License Management.

I hope you have enjoyed the free module of Licensing|Circle. If not, you can still request FREE ACCESS to the first module ('Oracle Licensing Overview') of the training by following the instructions in the link below.

If you need any support, you can write to

Best Regards,

Porus Homi Havewala

Friday, July 14, 2017

Thursday, July 13, 2017

Comprehensive Training on Oracle License Management

With the current "Journey to Cloud" scenarios, one of the main reasons cited is Oracle licensing.

Oracle Licensing can be a complex subject, and a lack of its understanding for Oracle professionals (including DBAs) could almost certainly lead to substantial financial risk exposure due to contractual non-compliance. Depending on the size and complexity of the Oracle license estate, the commercial value of the non-compliance could run into $$ Millions during an official audit.

To combat this, we now have Licensing|Circle, which is globally the first and only comprehensive & online training, reference, assessment and certification platform on Oracle License Management.

You can now request free access to the first module ('Oracle Licensing Overview') of the training by following the instructions in the link below.

After a few days, we will announce a discount code for the full course.

I am sure this will be a huge value add for all members. I suggest you request access to the free module initially for a head start into the course. If you need any support, you can write to

Monday, June 12, 2017

Wednesday, May 24, 2017

New Blog "Clouds and Databases"

Dear Friends,

I have started to write on a brand new blog "Clouds and Databases" that I created recently.

On the new blog, I will be writing about different cloud technologies and databases. Please also join me there if interested in the cloud.

The blog address is and this is how it looks:



Saturday, May 6, 2017

Enterprise Manager Functionality without the Packs

A friend asked:
“I know we can use Oracle Enterprise Manager without the packs. However, is there any document that shows in detail what database monitoring and alerting functionality is provided by Enterprise Manager (12c version) without using any packs.”
The answer was:
This information is in the “Enterprise Manager Licensing Information” guide.   Chapter 10, “Base Enterprise Manager Functionality” outlines the list of features that are included with the base functionality of Oracle Enterprise Manager. 
For the database side of things, See the “Base Database Management  Features” section in this chapter. This includes things like the following (that you can do without any pack licenses in Enterprise Manager):
  • Set up and Schedule RMAN backups
  • Set up and manage Data Guard Standby databases
  • Use Data Pump to move data
  • Manage Oracle Automatic Storage Management (ASM) and Clusterware
  • Use some Advisors such as Segment Advisor and Memory Advisor
  • Manage critical errors via Support Workbench
  • Manage database objects such as tables, indexes, views, materialized views etc.
  • Manage optimizer statistics and SQL plans
  • Set up Resource Manager for the database
  • Manage database users, roles, profiles etc. 
  • Manage control files, datafiles, tablespaces, log files etc.
  • View SQL execution history, execute SQL statements
  • Use Scheduler Central to manage jobs maintained by the database as well as Enterprise Manager
  • Get My Oracle Support (MOS) Critical Patch Recommendations
  • Perform PDB operations in Database 12c with some caveats for the free stuff, as described in an earlier blog entry here.
The link for the full set of base database features is here. Thanks for your question, and hope you have gained an understanding of what can be done as part of the base functionality.

Saturday, January 7, 2017

Article series "Consolidation Planning for the Cloud"

This is the 6th installment of my article series "Consolidation Planning for the Cloud":

  This series is an extract from the first chapter of my Oracle Press book on the Oracle Database Cloud. The Book link is at the end of the article.


Opinions expressed in this blog are entirely the opinions of the writers of this blog, and do not reflect the position of Oracle corporation. No responsiblity will be taken for any resulting effects if any of the instructions or notes in the blog are followed. It is at the reader's own risk and liability.

Blog Archive