Gear up for #AIOUG OTN Yathra’ 2016

Guys,

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 http://www.otnyathra.com/

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.

Regards

Advertisements

#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:

BEGIN
DBMS_CREDENTIAL.CREATE_CREDENTIAL (
credential_name => 'devhost_auth',
user_name => 'oradev',
password => 'oradev')
END;
/

The library definition will include a new CREDENTIAL clause:

CREATE OR REPLACE LIBRARY myextlib
AS 'HelloWorld.so'
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

#C15LV Collaborate’15 updates!!

Hi All,

IMG_20150411_203427~2

Last week, I registered my presence at Collaborate’15 in Las Vegas as a speaker, attendee and at Oracle demo booth duty. It was an awesome experience meeting some polished brains and smart minds. After the first day of registration, I attended the #DBIM12c session by Maria Colgan, #DB12c Multitenant by John McHugh and #Exadata session by Dan Norris – its always good to hear the most recent updates on something you have been working on.

IMG_20150414_145303IMG_20150412_142332~2

The topic of my talk was “I/O Resource Management on Exadata”. Thanks to all those who attended my session 662 at Banyan D conference room (inspite of Database In-Memory bootcamp and other concurrent sessions). The objectives of my session was to discuss the management of server resources in the cases of database consolidation, including the configuration, monitoring and best practices. At the same time, provide the latest updates on IO Resource Management. I appreciate the interaction of the audience who came forward with their experiences, problems and understand how IORM can resolve resource conflict issues. The hour long session was well received, which reminds me to remind all the session attendees – do fill in the session evaluation 🙂

IMG_20150413_184947

IMG_20150414_174609

 

 

 

 

 

 

 

 

After my stint as speaker, I took over the demo booth duty for Oracle Database 12c. Thanks to all those who passed by booth#54 and showed interest in understanding Oracle Database 12c, Multitenant, In-Memory. Glad we were able to help but sorry, our booth didn’t had freebies though!! We discussed some complex database deployments and tried to figure out better and easy solutions for those. On and off, I also visited partner booths and I truly appreciate their efforts in installing really nice structures and innovative ideas to attract more people.

One of the challenge which I could see and experience was planning the sessions to attend. Many concurrent sessions left the attendees in confusion as to which one to attend and which one to leave. But believe me, thats the beauty of this conference, you get things in extra size only. Just grab a cup of coffee and get set go.

Special mention to all those involved in coordinating and event administration. Thanks to IOUG for organizing the bring some great minds together. Hope to see you all next year as well. Thanks all

Saurabh

 

 

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 12.1.0.2 Multitenant enhancements and Oracle 12.1.0.2 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 12.1.0.2 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!!

Saurabh

 

Lets catch up at OTNYathra 2015

All,

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 – http://www.otnyathra.com/. Follow  for activity updates on twitter. 

My sessions at the event venues –

1. Oracle 12c Multitenant – Changes in Database Release 12.1.0.2
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 12.1.0.2, 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 12.1.0.2 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!!

Saurabh

AIOUG Tech Day at Hyderabad (Aug 23rd)

Hi there,

Last week, I spoke at AIOUG Tech Day at Hyderabad. All India Oracle Users Group (AIOUG) in association with TechMahindra organized one full day of techtalk event. Believe me, the Danube auditorium was a state-of-art facility with 500 capacity. Fabulous venue and huge crowd with similar interest. I thought of sharing my experience through a blog post.

The day started saw the green signal with a welcome speech from Narayanmurthy K, followed by a keynote from Satyendra Kumar (President, AIOUG). The first session from Satyendra touched on various aspects of Oracle 12c – primarily focused on Pluggable Database. Oracle 12c implements the concept of Multitenancy in database by allowing multiple application backends to run securely within a single database (The Container) and thereby, appearing as physical databases (Pluggable database).

Next was my turn to adore the stage by introducing Oracle 12c In-Memory – Oracle’s latest baby. My objective was to drive the motivation behind the innovation and let the audience know what exactly was the motivation. We have been hearing the buzz named “In-Memory” from quite a sometime. Columnar stores too are not new to the tech space. Innovation lies in bringing the two worlds together i.e. clubbing row store and columnar store within a single SGA. The whole architecture ensures that existing potential of row store (buffer cache) is not disturbed but the analytics (reporting and ad-hoc queries) makes use of columnar paradigm to be real-time analytics. IMCS is a native database feature, therefore no additional installation required. We learnt how to enable the feature, optimizer becomes in-memory aware, SGA gets a new static component, and storage indexes to skip columnar units. I was happy to see the growing curiosity in the audience and multiple rounds of QA. In the interest of time, I wrapped up the session but yes, there was a lot to talk about.

In the sequence were the sessions from YV Ravikumar and Nassyam Basha. Ravi briefed the audience on Flex ASM and flex cluster. He did an excellent job in demonstrating the evolution of ASM and how 12c adds flex behavior to ASM and clusterware. He showed some real time examples on his laptop which made the things more practical. Nassyam’s session on Oracle 12c Data Guard (Far sync and Fast sync) were well received. He touched upon the implementation part of the features and multiple use cases. Excellent job while taking the queries and he answered with utmost precision. One hour slot for each session was looking bit less. Far sync topology is a new stuff and planning is an important aspect. Location of the light-weight instance, how many far sync sites, and what is the failover policy must be the part of planning.

Later, we saw sessions from Mr. Phani Arega on Indexes. When to use an index and when not – was the objective of session. He had several use cases and citations to be discussed. I was back again on stage with SQL and PL/SQL enhancements in Oracle 12c. I did spent some time on introducing Multitenant 12.1.0.2 as well. The last session for the day from Satyendra was on Big Data essentials. He gave some excellent figures to show how the world is transforming and where lies the opportunity. The day wrapped up with thanks note. Though hectic, but it was great day and I must thank the audience for their patient listening on variety of topics.

Overall, the event was well received and appreciated by the audience. Thanks AIOUG for building up a great stage.

AIOUG Tech day team

AIOUG Sangam 11

 Hi Guyzzz

Just back from AIOUG Sangam11. Wonderful effort, event, sessions and most important grrat stage to share with some great names. Arup Nanda, Murali Vallath, Kuassi Mensah and many more. Kudos to the arrangement and and event management too.

The Day 1 (9th Dec) started off with registration. Was glad to see our bags and great material. Saw Murali at the doorstep and the day started off.

Murali addressed the session and thanked the event management team and introduced Arup to kick off the session. Arup Nanda ‘The LONGTIME DBA’ was the Show Stopper of the whole event. And he should be !!

Rich Niemiec started off with a session on Rolta. He showed us some pics of Oracle Corp…was amazed to be the part of it.

 

 

 

 

 

 

Arup started off with a session on Profiler in PL/SQL. Great sessions, great views and great information. Kuassi Mensah delivered a nice session on Oracle Net security. Murali too gave a presentation on RAC subject, but couldn’t catch up match as I have no background. Hemant came up with the day to day challenges of a DBA, their role and expectations. Fabulous !!

Day 2 (10th Dec) again saw a long session from Arup until Lunch. Superb stamina and grasp !! Got to know some new concepts on Cache fusion, DBA best practices, and introduced the logic behind Exdata. I could see the roadmap of DBA to DMA (Database Machine Administrator). Again a good one!!

Meanwhile I got introduced to Arup Nanda with a handshake and told him about myself. Told him about my online works and he asked me to get in touch for SELECT journal too. Nice chat time !!

Later I attended session by Hemant on Partitioning. Though it was an elementary one but enough to fill up 1 hour session. The next session by Prabhakar Gongloor was another masterpiece where he showed some screendumps of Oracle 12C. I believe we would be only of those few ones who could see it within 2 months of the version release. I could see him hiding something by saying its ‘Special Technique’ through which EM can connect to DB even if it is down (as far as I could understand).

As I referred one of my colleague for the seminar, I received a coupon worth INR500, redeemable on the same day against the books at the counter. I got one copy of Oracle XML DB.

The conference ended with photo sessions. I too got few with Arup, Bryn, Rich and Mensah. Soon I would publish on my blog. Received a Tshirt from OTN too.

Next year, it would be in August, 2012…I will be happy to volunteer the event and would surely like to see myself at the stage right there 🙂

Once again, Thanks Oracle, Thanks AIOUG !!

By for now

Saurabh