Gear up for #AIOUG OTN Yathra’ 2016


AIOUG is back again with OTN Yathra’ 2016. It is a series of technology evangelist events organized by All India Oracle Users Group in six cities touring across the length and breadth of the country. It was my extreme pleasure to be the part of it in 2015 and I’m pleased to announce that I’ll be speaking this year too. This year it starts on April 23rd and runs until May 01st, 2016. Check out the event schedule and objectives here

I will be speaking in Bangalore (Apr 24th), Hyderabad (Apr 26th), and Mumbai (Apr 30th). My session abstracts are as below –

1. Backup your databases to the cloud using Oracle Database Backup Service

Oracle Database Backup Service is a secure, scalable, reliable, and on-demand Oracle public cloud storage solution for storing Oracle Database backups. Businesses can access additional storage capacity in minutes with zero hardware investment. The Oracle Database Backup Service can be accessed from anywhere, at anytime, and from any Oracle database server connected to the Internet.

This session will touch upon several aspects of backup cloud service like subscription process, scalability, access, and security. The attendees will learn about the new backup-as-a-service offering that enables customers to store their backups securely in the Oracle cloud via a downloadable backup module that transparently handles the backup and restore operations.
2. Use Oracle BigData SQL to query for All Your Data

Oracle Big Data SQL provides unified query across Oracle database, Hadoop, and NoSQL datastores. It uses query franchising technique to maximize the performance and avoid the pitfalls of language-level federation using query franchising. Oracle BigData SQL uses Hadoop Smart Scan to quantify the performance and minimize data movement. This session will discuss the limitations of language level federation, capabilities of BigData SQL and the latest updates of a cutting-edge technology.

Please register for this event and confirm your availability in the event. I’ll see you there.



#DB12c feature – Secure External Procedures with DBMS_CREDENTIAL

Oracle Database 12c enables enhanced security for extproc by authenticating it against a user-supplied credential. This new feature allows the creation of a user credential and links it with a PL/SQL library object. Whenever an application calls an external procedure, the extproc process authenticates the connection before loading the shared library.

The DBMS_CREDENTIAL package is used to configure the credential. The CREATE LIBRARY statement has been enhanced for the credential specification.

A new environment variable, ENFORCE_CREDENTIAL, can be specified in extproc.ora to control the authentication by the extproc process. The default value of the parameter is FALSE. Another new environment variable, GLOBAL_EXTPROC_CREDENTIAL, serves as the default credential and is only used when the credential is not specified for a library. If ENFORCE_CREDENTIAL is FALSE and no credential has been defined in the PL/SQL library, there will be no user authentication; this means the extproc process will authenticate by using the privileges of the user running the Oracle server.

The following PL/SQL block creates a credential by using DBMS_CREDENTIAL.CREATE_CREDENTIAL. This credential is built using the ORADEV user:

credential_name => 'devhost_auth',
user_name => 'oradev',
password => 'oradev')

The library definition will include a new CREDENTIAL clause:

AS ''
CREDENTIAL devhost_auth

When the extproc process reads the call specification and finds the shared library with a secured credential, it authenticates the library on behalf of the credential and then loads it.


Note – this post is an excerpt from the book “Advanced Oracle PL/SQL Developer’s Guide – Second Edition

OTN Yathra 2015 just got over!!

Quite well said – Investment in knowledge is the gives you the best returns. It was a great fun last week to be the speaker at OTN Yathra 2015, organized by All India Oracle Users Group (AIOUG). The OTN tour covered seven cities and I was the part of it at three cities i.e. Hyderabad, Bangalore and Chennai. I sort of loved to be the part of it as the events were tightly packed with just a day difference. Back to back events in three cities within a week’s time. My piece of stage was on Oracle Multitenant enhancements and Oracle Database In-Memory option.

The Hyderabad venue was at TechMahindra facility with quite huge number of registrations. Thanks to Satyendra and team for attending and coordinating the event logistics. There was good amount of interest level from the participants to listen on latest technology trends. Surprisingly, headcount from audience who have evaluated Oracle 12c was quite less. But I appreciate their keenness to know more on the topics which we presented. Nice meeting Kuassi Mensah, Gurcan Orhan and Gustavo Gonzalez during the events.

The Bangalore chapter was organized in our Oracle (OFSS) facility. AIOUG – Bangalore chapter was a major update of the morning. Yet again, I was happy to have quality participation in my sessions. During the Multitenant enhancements, I spent more time explaining the Multitenant architecture as some of them were new to it. The sessions were pretty interactive and well received. It’s always good to meet acquaints from the industry during events and yes, such events help you to grow your professional grounds too.

The Chennai event was quite an interesting one as it was placed in Loyola College, Chennai. Having not visited a college campus for long time, it was a moment to see playgrounds and hostels. Back to our technical sessions, I appreciate the interaction of the participants. Multitenant was the talk of the hour but DBIM wrapped up their day with the conceptual understanding. And a surprise talk on Oracle Security was mesmerizing. Thanks to Sai for coordinating the events in Bangalore and Chennai.

If learning is an experience, sharing knowledge is a bliss. Thanks to AIOUG for hosting the speakers during the events which was truly appreciable. I would cordially invite your feedback/comments and suggestions on the sessions which I presented. If you have clicked the pics – don’t forget to share them too 🙂 See you again!!



Lets catch up at OTNYathra 2015


Its time to be at AIOUG stage once again and the event would be the OTNYathra 2015. The event has been a great success in the past and has been able to generate/receive wide recognition and appreciation. OTNYathra focuses to evangelize the Oracle technologies to a broader and passionate audience. OTNYathra is a grand tour which is conducted in 7 cities across India in the span of two weeks. Out of these seven, you can find me in three of them – Hyderabad, Bangalore and Chennai. If you are an Oracle professional and passionate about learning, we must see each other there. I believe its a great chance to share and learn and at the same time, meet and make friends in the community.

You can find the dates, venue info and registration page here – Follow  for activity updates on twitter. 

My sessions at the event venues –

1. Oracle 12c Multitenant – Changes in Database Release
Oracle 12c introduces Multitenant architecture which is designed for cloud infrastructure and enables the customers to easily consolidate multiple databases. The new architecture focuses on easy adoption and provides enhanced manageability. Oracle Multitenant delivers the benefits of “Manage many as One” while retaining the security, isolation and resource management at individual database level. Not only it complements all database options, but also provides quick provisioning of databases. With Oracle Database, Oracle has delivered multiple enhancements to the Multitenant option. Although, the Database In-Memory option is the most talked about feature of the release, but Multitenant option includes multiple additions to the pluggable database cloning, enables cross PDB querying, controls PDB in a data guard configuration, and many more features. These features allows the granular management of pluggable databases in a Multitenant environment. The Multitenant option, being compatible with Database In-Memory option, further raises the value bar in a consolidated environment. The session will discuss the motivations behind the enhancements to the Multitenant architecture and their applications in the real world.

2. Oracle Database 12c In-Memory option
The Oracle Database introduces the Database In-Memory (DBIM) option which transparently accelerates analytic queries by orders of magnitude, enabling real-time business decisions. Using Database In-Memory, businesses can instantaneously run analytics and reports that previously took hours or days. Businesses benefit from better decisions made in real-time, resulting in lower costs, improved productivity, and increased competitiveness. Oracle’s In-Memory columnar technology is a pure in-memory format.   The in-memory columnar format is not persisted on storage. With the introduction of Oracle Database In-Memory option, a single database can now efficiently support mixed workloads by delivering optimal performance for transactions while simultaneously supporting real-time analytics and reporting workloads. This is possible due to this “dual-format” architecture that enables data to be maintained in both, i.e. the existing Oracle row format (buffer cache) for OLTP operations, and a new purely in-memory column format optimized for analytical processing. Embedding the in-memory capabilities into the existing Oracle Database software ensures that it is fully compatible with all existing database features, and requires no changes in the application layer.

See you there!!