Tag Archives: OTN

More minds meet at Sangam 2015…

Diary on Sangam’15
21st, 22nd Nov 2015 at Hyderabad International Convention Centre, HITEC City, Hyderabad, India

In the recently concluded two day Oracle conference – Sangam 2015, there were more number of attendees than last year (Sangam 2014). Sangam – An annual conference for Oracle Technologist across India is organised by AIOUG (All India Oracle Users Group) and aptly has tagline of ‘meeting of minds…’.

It was a privilege to attend such a large scale event for third consecutive year. It was an honour to get in touch with the Oracle ACE and Oracle ACE Directors and hear them speak in front of august gathering. There were numerous sessions lined-up as always. I had briefly shared the sessions attended by me during the two days conference.

Day 1: 21st November 2015

Tim Hall – Oracle ACE Director (Day 1 | Day 2) – It was treat to hear him again and his session on Oracle 12c Consolidations and pros/cons was very relevant and updated.

Kamran Agayev – Oracle Certified Master – His session on “Oracle 12c ASM new features” with webetorial was very crisp and provided lot of insights into the world of Oracle 12c for ASM.

Aman Sharma – Oracle ACE – His session on “Oracle RAC Node Eviction” was overwhelming and demonstrated his expertise in the RAC yet again. It was very useful.

Anju Garg – her session on Oracle ACFS High Availability over NFS Service was enthralling and was studded with illustrations. It was good to know that ACFS now supports all types of files.

Day 2: 22nd November 2015

Oracle VM and Oracle Linux – Kamal Dodeja (Sales Consulting Manager) and Ritesh Kumar (Senior Technical Consultant) from Oracle India Pvt. Ltd. – Their session on Oracle Linux and Oracle VM was primarily revolving around the Technical features offered by Oracle Linux and Oracle VM and concluded with the pricing details.
I had previously blogged about installation of Oracle VM, Oracle Linux and Installation of Oracle 12c on Oracle Enterprise Linux which is available here.
One interesting takeaway from this session of theirs was ksplice – which actually provides high availability and reduces downtime. Overview, Downloads and Documentation on ksplice is available at OTN here. It was a strategic acquisition made by Oracle in 2011. This enables important kernel patches to be applied without reboot or without bringing down any application services in Oracle Linux.

Debaditya Chatterjee – Product Manager Oracle USA – Oracle Database In-Memory Options – It was a good review of Oracle In-Memory database which was delivered by Maria Colgan in the last edition of Sangam. His session focused on the what’s and why’s of Oracle In-Memory database.

Satyendra Pasalpudi – Oracle ACE Director – His session on “Oracle Cloud DBA” showcased the next thing from Oracle – Oracle Cloud. The session was mainly for DBAs.

The conference closed with a motivational speech by “Dr. Rajdeep Manwani” – who shared his priceless life experiences about hard-work, patience, perseverance, failure, success and imaginary finishing line in marathon when most of the contestant gives up.

Thanks to AIOUG and Oracle Technology Network (OTN) for organising such events and providing Oracle fraternity in India a splendid opportunity to hear the speakers from elite Oracle community 🙂

Vijay Mahawar

Leave a comment

Posted by on 24 November, 2015 in DBA, Oracle, PL/SQL, Uncategorized


Tags: , , , , , ,

Webinar Recording on Oracle Analytical Functions now available

Thanks for attending the webinar on Oracle Analytical Functions.
Those who had missed the webinar can watch the recorded version below.

Hope you all find it useful.

Keep looking for this space for more updates on upcoming webinars.

Leave a comment

Posted by on 18 February, 2012 in Oracle


Tags: , , , , , , , , ,

Webinar: 18 Feb 2012 – 3:00 p.m to 4:00 p.m IST on Oracle Analytical Functions

Dear Friends,

Join me for a Webinar on February 18, 2012 (Saturday) from 3:00 p.m to 4:00 p.m IST

Oracle Analytical Function by Vijay Mahawar

Register for the webinarSpace is limited.
Reserve your Webinar seat now at:

Looking forward to see you all for the webinar.

Keep watching this space for more updates.


About the presenter:
I am Vijay Mahawar, an Oracle Technologist. I am a member of AIOUG, ODTUG and OTN. I am certified in Oracle and hold OCP in Oracle 11g DBA and OCP in Oracle 11g Advanced Developer Track. I am also OPN Certified Specialist. To know more about me please visit the know me section of the blog.

Leave a comment

Posted by on 15 February, 2012 in Oracle


Tags: , , , , , , , , ,

Now I am OCP in Database Administration 11g

OCP DBA in 11gOPN Certified Specialist

Its gives me immense pleasure to inform you that now I am Oracle Certified Professional in Database Administration 11g.
I am also issued the OPN Certified Specialist certificate along with this.

I have successfully upgraded my OCP 10g in DBA to OCP 11g DBA. I had appeared for the bridge paper 1Z0-050 (Oracle Database 11g: New Features for Administrators) and passed by securing 70% in the exam. The pass mark for paper 1Z0-050 is 61%. There were 77 questions which had to be answered in 105 minutes.

Exam topics in 1Z0-050 is depicted in following image

1Z0-050: Exam Topics

My success mantra for clearing the paper:
1) Undergone one 5 day course from Oracle University.
2) Referred Oracle-base website for latest and new features in 11g
3) Download the software from oracle software and practice the new features.
4) Join forums and visit blogs of Oracle Guru’s (shared in the right hand panel of my blog)
5) Attend OTN events to get to know the latest in Oracle Technologies.

I heartily thank my faculty at Oracle University and friends and family who had been instrumental in this.

Leave a comment

Posted by on 24 January, 2012 in Oracle


Tags: , , , , , ,

Diary on OTN – Developer Day Event (The Claridges, New Delhi)

17th January 2012
“The Claridges”, New Delhi

Today I happen to attend another OTN(Oracle Technology Network) – Developer Day Event. This time the event was held in Hotel “The Claridges”, New Delhi.

For those of who are not aware of OTN

What is OTN?

Oracle Technology Network is the world’s largest community of application developers, database admins, system admins/developers, and architects using industry-standard technologies in combination with Oracle products.

Millions of members collaborate online to share real-world expertise and best practices about how to best design, build, deploy, manage and optimize applications. OTN is also a provider of free developer workshops across the globe, as well as a sponsor of third-party conferences, user group meetings, and events.

How to register for the event?

OTN events happen round the year at different venues across the globe. All Oracle Certified Professional, who have registered at Oracle website ( may receive the email invite at their email with which they have registered (Usually the SSO id)

The nomination/invite for this event is sent from Oracle. After the invite is received the candidate has to register for the event at Oracle website or the link mentioned in the mail. Oracle confirms the registration on the basis of the role of the Oracle Professional and seats available for the event.
On successful confirmation candidate should receive an email at their email id.

About the Event

The event kicked-off by filling up registration form and distribution of badge and agenda followed by breakfast.

09:30 a.m. – 10:00 a.m. Welcome and opening remarks
10:00 a.m. – 10:45 a.m. Keynote: What’s New In Oracle Application Development
10:45 a.m. – 11:30 a.m. Migrating from non-Oracle Databases to Oracle Database with Oracle SQL Developer
11:30 a.m. – 11:45 a.m. Tea/coffee Break
11:45 a.m. – 12:45 p.m. Updating Your Database Design with Oracle SQL Developer Data Modeler
12:45 p.m. – 01:30 p.m. Lunch Break
1:30 p.m. – 2:15 p.m. Data Subsetting and Masking: Advanced Techniques for A Secure Test Data Management
2:15 p.m. – 3:00 p.m. Worry-Free Application Upgrade with the Change Management Capabilities in Oracle Database Lifecycle Management Pack
3:00 p.m. – 3:45 p.m. Big Data – Are You Ready?

Session 1: Keynote: What’s New In Oracle Application Development
This was the first session and focused on new features and enhancements in various oracle tools and products viz. Oracle SQL Developer 3.1, Apex 4.1, Oracle PL/SQL Result Cache, Times Ten in-memory Database Cache, Oracle 11g,
In the interest of the time last few topics were discussed only in brief.

Session 2: Migrating from non-Oracle Databases to Oracle Database with Oracle SQL Developer
This session showcased the migration feature of the SQL Developer tool shipped by Oracle. It discussed various kinds of migrations:
a) Windows to Linux migration
b) Sybase to Oracle 11g
c) VB to Java
d) MS SQL Server to Oracle 11g
e) MS Access to Apex
f) Teradata to Exadata

All this migration are done in 5 stages from 3rd party to Oracle. The 5 stages are:
Connect -> Capture -> Convert -> Generate -> Data Move
The Migration can be done online as well as offline.

Databases supported are:
1. Sybase
2. MS SQL Server
3. MS Access
4. MySQL (3.x, 4.x, 5.x)
5. IBM DB2 UDB(8 & 9)
6. Teradata (12,13)

The presenter with help of video demonstrated how drivers to different databases can be added to SQL Developer and configured.
Interesting URLs shared at the end:

Session 3: Updating Your Database Design with Oracle SQL Developer Data Modeler
This session was primarily of interest for the Database Architects and who are involved in designing and modelling of the database. It discussed three kinds of Models: Logical, Physical and Relational.
It also discussed Top Down Model (Business Info to Physical Model) and Bottom up Model (Reverse Engineer DB, Revise/modified model and Generate the modified DDL)
Interesting Visits: (Oracle Learning Library link for more videos and tutorials on Data Modeler tool by Oracle)

Session 4: Data Subsetting and Masking: Advanced Techniques for A Secure Test Data Management
This session showed how production data can be made available on non-production environment like Development, UAT and Staging. Sensitive data can be masked and made available to non-production environment. Types of masking discussed were:
a) Compound Masking
b) Condition Masking
c) SQL expression Masking
d) Key based Reversible Masking

Intersting URLs: (Oracle Learning Library)

Session 5: Worry-Free Application Upgrade with the Change Management Capabilities in Oracle Database Lifecycle Management Pack
The session showcased the features of Database Lifecycle Management Pack:
1. Discoverer (Auto-Discoverer – new in 12c)
2. DB Provisioning
3. Patch Management
4. Database Upgrade
5. Change Management
6. Dictionary Baseline
7. DBMS_COMPARISION package (new in 12c)
8. Configuration Management
9. Drift Management (Cell to Cell, RAC to RAC and Intance to Instance)

Session 6: Big Data – Are You Ready?
Data is classified on basis of Volume, Velocity, Variety and Value.

This session stressed on Hadoop architecture, Oracle Exadata, Exalogic and Exalytics with help of following video

Overall the event was very informative and gave first hand info on latest technologies in Oracle 11g  and Oracle Enterprise Manager 12c from developer and DBA perspective. I have tried to highlight most of the features showcased in the event.

Hope you find it useful!

Leave a comment

Posted by on 18 January, 2012 in Oracle


Tags: , , , , , , ,

%d bloggers like this: