OTNYathra 2016 -Noida

DBA friends, once again AIOUG- North India Chapter has taken intiative and organised the OTNYathra 2016 in Noida location , This time all sessions will be mainly inclined to RAC, Performance Tuning and New features of 12c database and 13c OEM.

This oppurtunity should not be missed!

Description

Timings Room 1 Room 2
9:00 to 9:30 Registrations
9:30 to 10:00 Oracle ACE Program Overview – Sai Janakiram
10:00 to 10:50 RAC Cache Fusion Internals –
Riyaj Shamsudeen
Experience of being a Cloud DBA – Satyendra Kumar
10:50 to 11:10 Tea/Coffee/Networking Break
11:10 to 12:00 RAC performance tuning –
Riyaj Shamsudeen
Oracle 12c-What’s New in High Availability –
Aman Sharma
12:00 to 13:00 Networking Lunch
13:00 to 13:50 In-memory internals-
Riyaj Shamsudeen
Troubleshooting Oracle GoldenGate
Hariharaputhran Vaithinathan/ Veeratteshwaran Sridhar
13:50 to 14:40 Advanced performance diagnosis using UNIX Tools –
Riyaj Shamsudeen
Oracle Data Security-
Chethan Vithlani
14:40 to 15:00 Tea/Coffee/Networking Break
15:00 to 15:50 Oracle ACFS High Availability NFS Services (HANFS) –
Anju Garg
Oracle DevOps for Dummies – 

Sai Janakiram

15:50 to 16:40

The ART of Interpreting the AWR Report –
Karan Dodwal

Oracle OEM 13c –
Deepak Sharma
16:40 to 17:10 Expert Panel
17:10 to 17:30 Closing

NOTE: Agenda and speakers subject to change without notice.

Registration:
Please take note of the appropriate venue /date of the event. The registration for the event is free, however there will be a non-refundable fee of Rs 500.00 ( to cover lunch and incidental expenses ) to be paid at the time of registration.

Click here to register!

Session Title:

RAC Cache Fusion Internals


Session Abstract:

A demo of internal working of RAC and cache fusion. Audience will understand the core concepts behind RAC internals. Conceptual understanding will lead to better performance tuning and debugging RAC related issues. I use Wireshark, output from internal structures to explain these concepts.


Session Title:

RAC performance tuning


Session Abstract:

Part 1. This presentation is a logical extension to RAC Cache Fusion Internals session. Audience will be able to understand the RAC wait events and performance statistics better.


Session Title:

In-memory internals


Session Abstract:

In this presentation, I will discuss the inner working of in-memory column store. Conceptual understanding of internals will help the customers to use the product better.


Session Title:

Advanced performance diagnosis using UNIX Tools


Session Abstract:

This presentation introduces tools such as strace, truss, pmap, stack, dtrace etc to troubleshoot some real word performance issues.


Speaker Bio:

Riyaj Shamsudeen is considered industry recognized RAC Expert, Performance Tuning Specialist with 20+ years of Experience in implementing, using, and tuning RAC and Oracle products. He is an Oracle ACE Director and proud member of OakTable member. He has co-authored many books about Oracle and Performance. He is an active blogger at http://orainternals.wordpress.com and frequent international speaker in major conferences such as UKOUG, HOTSOS, Open World, RMOUG, etc.


Session Title:

Understanding 12c Adaptive Query Optimization


Session Abstract:

From 11g onwards, optimizer has been constantly getting enhanced. From Adaptive Cursor Sharing to Cardinality Feedback, it’s been evolving to correct the mistakes that it does. In 12c, with Adaptive Query Optimization, these endeavors have been pushed to one step ahead. Not only the query optimizer can tune the 1st execution of the query but also can optimize the subsequent executions of the query as well. This presentation would focus on this new change that has been introduced in the 12c optimizer.


Speaker Bio:

Aman Sharma is an Oracle Database consultant and instructor. He holds a Master’s degree in Computer Applications and has been working with Oracle Database for over a decade. His main focus is to understand how Oracle Database works internally. Besides the core database, he has a very strong knowledge of Linux, Solaris, Oracle RAC, Data Guard, RMAN, Oracle Exadata and Oracle Enterprise Manager. He is an Oracle Certified Professional and also an Oracle Certified Expert in Oracle RAC, SQL and Linux. He is also an Oracle Certified Implementation Specialist and a certified Solaris System Administrator. In 2010, he was awarded the prestigious Oracle ACE award from Oracle Corporation. He loves to share his learning with the Oracle community, so when he is not delivering an Oracle related session, he spends a lot of his time participating in OTN (Oracle Technology Network) discussion community spaces. He also shares his research and findings over his Oracle blog (http://blog.aristadba.com). He has co-authored two books-Oracle Backup and Recovery: Expert secrets for using RMAN and Data Pump-Rampant TechPress (USA) and Oracle Database 12c Backup and Recovery Survival Guide-Packt Publishing (UK). He is an avid supporter of Oracle user groups and is a member of All India Oracle Users Group (http://www.aioug.org). He also manages the AIOUG’s North India Chapter. He has presented at various Oracle conferences organized by AIOUG i.e. Sangam, OTNYathra and Tech Days. He is also an associate member of IOUG (http://www.ioug.org).


Session Title:

Experience of being a Cloud DBA


Session Abstract:

Cloud has become new normal. Cloud Computing has changed the IT landscape and how we think and work and DBA is also no exception. The session talks about what learning and unlearning one has do to be a Cloud DBA from traditional on premise DBA. It talks about how one has to look for various features and options in cloud in order to match the on premise workloads to ensure the same performance levels. It also discusses how to utilize some of the cloud advantages in backup & archival, scalability, high availability and ease of provisioning. Case studies and best practices discussion of couple of database customers who have been migrated from on premise to cloud.

 

As Cloud being the new normal, DBA’s will know how it is different from on premise management of database against cloud.


Speaker Bio:

Satyendra Pasalapudi is an Oracle ACE Director & MBA graduate with 16+ years of diversified international experience in the IT industry that spans across multiple continents. He is an accomplished database professional, author, and speaker with right blend of business and technology skills. Pasalapudi has bootstrapped various Strategic Business Units in his career and is currently working as a Practice Director at Apps Associates Pvt Ltd heading their Infrastructure Managed Services and Cloud practice at GDC and has worked with APTS, Pointsoft, Kenexa, DELL and Megasoft in his earlier assignments. Pasalapudi is the Co-Founder and President of the All India Oracle Users Group (AIOUG) and is a frequent speaker at the Oracle Open World, AIOUG Sangam, IOUG Collaborate and other conferences. He blogs at orakhoj.blogspot.com and created http://www.ora-search.com an exclusive oracle search engine for DBAs and Developers.


Session Title:

Oracle DevOps for Dummies


Session Abstract:

Application development and IT operations teams travel different roads with different points of view. These separate roads slow the delivery of new apps and features to customers. Relations between Development and Operations are generally viewed as poor, with some even characterized as toxic.

Ready to begin your journey to DevOps? The journey to continuous everything. DevOps brings together your development and IT operations professionals early in the application process, enabling them to collaborate closely and function as an integrated team. Along the way, DevOps automates many processes so one organization isn’t left waiting on the other. Integration, automation, and collaboration are keys to DevOps success. This session is going to help Oracle Customers to understand how DevOps can benefit their business.

Speaker Bio:

Sai is an Oracle ACE Director and Oracle Certified Professional. He is having more than fourteen years of experience in Oracle & Cloud technologies. Currently working with Hewlett Packard Enterprise (HPE) as Lead Cloud Architect. He is one of the founding member of All India Oracle Users Group (www.aioug.org – a non-profit organization) and currently serving as Vice-President & Director of Finance. He is frequent speaker in Users Group conferences inside and outside of Oracle including Oracle Open World, UKOUG, OTNYathra (India OTN Tour) and AIOUG Sangam Conferences & Java One. He was part Oracle Database 12c Beta testing. His Oracle Application DBA blog – http://www.oadba.com. Oracle 12c blog http://www.oracle12c.info. He is also leading Oracle VM Special Interest Group (SIG) http://www.oraclevmsig.org. Presented more than 35 conferences, major conference including Oracle Open World (2015,2014,2013), UKOUG (Tech14), Java One India (2013), Sangam (AIOUG Annual Conference 2014,2013, 2012, 2011, 2010, 2009), OTNYathra (India OTN Tour 2014,2013, 2012)

Session Title:

Oracle Data Security Introduction

Session Abstract:

Databases make very attractive targets as they have all the data neatly arranged in columns and rows, properly structured and linked with relevant information.

Hackers may try to enter from network, operating system, storage, databases, applications, storage, backups, etc. if you can sniff the wire, copy the database files from the operating system, exploit someone already in the database, or the application, you can get away with all the data. Passwords can now be obtained by the hackers as well, and you have to make sure that those privileges are not getting abused. The scope of the problem is thus slightly larger than typically what can be addressed by just encryption.


Speaker Bio:
  Chetan Vithlani

Enterprise Security Solutions Architect with two decades of Information Technology experience. Currently work as Principal Security Technology Consultant with Oracle focusing on Enterprise Security.

Chetan worked in BFSI, Tele Communications, Web Hosting and many other domains. Extensive experience as Production and development Database Administrator, Architect, Data Migration & ERP.

AIOUG Bangalore chapter Core Team member.

Specialist:

$11.Data Security: on premise as well as cloud

$12.Big Data (HDFS, NoSQL & RDBMS) Security

$13.Presales

Certifications:

2014: Oracle Database RAC 12c certified implementation specialist (OCE)

2014: Oracle Database 12c certified implementation specialist (OCS)


Session Title:

SQL Tuning – Proven Methodologies


Session Abstract:

Have you told Oracle all that you know about your data?, Do you want to know how to communicate with Oracle Optimizer to achieve better performance, Would you like to understand the design techniques which are development friendly but yielding bad performance. Yes, this session helps you to understand these areas through proven techniques, methodology to achieve better SQL performance.  The session also explains various real time scenarios in the areas of Application Design, Query Transformations, Indexing Techniques and Troubleshooting Query Performance.

Session talk covers

  1. 1. Application Design impacts over Query Performance
  2. 4. Understanding Query Transformation and applying them for better SQL Performance.
  3. 5. Step by Step iterative approach for SQL Tuning explained with real time examples.


Session Title:

Oracle Big Data Deep Drive


Session Abstract:

Are you carried away with the buzz words Big Data, Hadoop, MR etc., Are you looking for a deep dive session to understand how these would help on a day to day life of an Oracle Developer and DBA, then this session is for you. With the data growing trend, Big Data is all about how to create value from data.  This session provides an overview of big data with an emphasis on Hadoop.  The session answers the below questions in detail with real time examples


Speaker Bio:

Hariharaputhran Vaithinathan – Technology and Business Professional with 12 years of experience in data architecture, data integration business intelligence, Professional Services Delivery. Recognized as a strategic thought-leader with a consistent track record of client-focused innovation and execution. Extensive global experience in Finance, Banking and Telecom projects. He has extensive experience in design, development, support and management of large scale data systems and deploying enterprise level global solutions.  His area of interest includes Data Modelling, Replication, SQL Tuning and Big Data. He is currently heading the AIOUG Chennai Chapter. Hari is a speaker at User Group Conferences including India OTN Tour, AIOUG Sangam Conferences, AIOUG Tech days, Oracle Open World 15. He was the recipient of the award from Cognizant Technologies Ltd- Chennai Top Trainer for Q1-2013. He shares his experience in his blog www.puthranv.com


Session Title:

Oracle ACFS High Availability NFS Services (HANFS)


Session Abstract:

With Oracle Database 12c R1, Cloud FS includes Highly Available NFS (HANFS) over ACFS which enables highly available NFS servers to be configured using Oracle ACFS clusters. The NFS exports are exposed through Highly Available VIPs (HAVIPs), and this allows Oracle’s Clusterware agents to ensure that HAVIPs and NFS exports are always available. If the node hosting the export(s) fails, the corresponding HAVIP and hence its corresponding NFS export(s) will automatically fail over to one of the surviving nodes so that the NFS client continues to receive uninterrupted service of NFS exported paths.


Speaker Bio:

Anju Garg is an Oracle Ace Associate with over 13 years of experience in IT Industry in various roles. She is a Certified Expert in Oracle RAC, Oracle Database Performance Tuning and SQL Statement Tuning. She has trained more than a hundred  DBAs from across the world in various core DBA technologies like RAC, Data guard, Performance Tuning, SQL statement tuning, Database Administration etc. She was a member of Expert Panel at SANGAM 2014 and is a regular speaker at SANGAM and OTNYathra. She is an author at All Things Oracle and is passionate about learning. She has keen interest in RAC and Performance Tuning. She shares her knowledge via her  technical blog at  http://oracleinaction.com/

 

Session Title:

The ART of Interpreting the AWR Report

Session Abstract:

In this session attendees will learn to Interpret the AWR Report on various sections. This will help attendees diagnose the problems in a better way within their databases. AWR has been available since the release of Oracle 10G Version and it is the most important report which any DBA should be able to interpret. This session will help attendees to be able to interpret the AWR report easily.

Speaker Bio:

Karan Dodwal is an Oracle Architect with specialization in Oracle High Availability Environments, He is an Oracle Certified Master DBA (OCM 11G) with several years of expertise on Oracle Database and Oracle Development. He works as an Oracle Consultant and he has given several services and trainings on Oracle Products in the Asia Pacific, Asia South & Greater China region.


Session Title:

Oracle Enterprise Manager 13c {What’s New}.


Session Abstract:

This session will cover OEM13c Architecture, Basic Components, Overview of new features and how they can be used for monitoring various targets. EM12c and EM13c comparison.
• Introduction to EM 13c.
• Architecture of EM 13c.
• Whats new for DBA’s in EM 13c.
• 12c and 13c Comparison.

Speaker Bio:

Deepak Sharma, working as SR. Application Administrator with experience of 6+ years has worked on technologies like Oracle Enterprise Manager 11g Grid Contol, Oracle Enterprise Manager 12c Cloud Control, Oracle Enterprise Manager 13c, Oracle Database. He is currently working with “Oceaneering International Inc.” from last 4 years and before that he has been employee of “Bebo Technologies” for 2 years. He is Co-Founder of AIOUG-North India Chapter and core team member of AIOUG itself {http://www.aioug.org/aiougnichapter.php}.He has presented at various Oracle conferences organized by AIOUG i.e. OTNYathra and Monthly Tech Days etc. He also shares his research and findings over his Oracle blog (https://deepaksharmaem12c.wordpress.com). He can be easily reachable at { sharma.deepak345@gmail.com} and {https://in.linkedin.com/in/dksharmaemdba}

 

Session Title:

Troubleshooting Oracle GoldenGate

Session Abstract:

Process Abended – oh!!! Not Again. My processes are up and running, but my data is not getting replicated. If you are looking for troubleshooting Oracle GoldenGate, then this is the session for you. Prevention is always better than cure, on following this quote, the session not just troubleshooting but also explains the key areas which has to be considered so as to prevent or avoid the errors and problems which occur frequently in your Oracle GoldenGate environment. A step by step methodology on how to troubleshoot Oracle GoldenGate problems will be showcased based on real time scenarios.

Speaker Bio:

Hariharaputhran Vaithinathan – Technology and Business Professional with 12 years of experience in data architecture, data integration business intelligence, Professional Services Delivery. Recognized as a strategic thought-leader with a consistent track record of client-focused innovation and execution. Extensive global experience in Finance, Banking and Telecom projects. He has extensive experience in design, development, support and management of large scale data systems and deploying enterprise level global solutions.  His area of interest includes Data Modelling, Replication, SQL Tuning and Big Data. He is currently heading the AIOUG Chennai Chapter. Hari is a speaker at User Group Conferences including India OTN Tour, AIOUG Sangam Conferences, AIOUG Tech days, Oracle Open World 15. He was the recipient of the award from Cognizant Technologies Ltd- Chennai Top Trainer for Q1-2013. He shares his experience in his blog www.puthranv.com

Veeratteshwaran Sridhar is an Oracle Database Administrator with 8 Years of Experience working as Senior Software Engineer, Oracle GoldenGate Global Customer Support in Oracle India Pvt Ltd. He is an Oracle 11g Certified Professional and Oracle GodlenGate 11g Certified Implementation Specialist. He is also having good knowledge in Oracle Technologies such as GoldenGate, Data Guard, RAC and RMAN. He is also a speaker in AIOUG Chennai Chapter, Sangam, Oracle Technology Network and He actively participates in Oracle related forums such as OTN (ID – ORASCN). He constantly publishes articles on his blog http://www.oracle-scn.com and he is reachable at veeratteshwaran.sridhar@oracle.com / veeratteshwaran.s@gmail.com

When and Where

  • Start Time:

    5/1/16 9:00 AM

  • End Time:

    5/1/16 10:00 AM

  • Location:

    BirlaSoft H–9, Sector 63, NOIDA – 201306

Advertisements

Cloud TechDay – Noida

Hello DBA Friend,

Once again AIOUG- Noth India Team has organized a big tech event in Oracle Noida. Focus of this event would be a deep dive knowledge on Oracle EM Cloud and Oracle Cloud Databases.

All presentation will be core in their subject area, There will be no marketing talk or session, Seats are filling fast so book your seat before its too late.

Here is link to register for the event http://www.meraevents.com/previewevent?view=preview&eventId=96892

 

Cloud TechDay – Noida

 
Venue:  Oracle India Pvt Ltd, Building 3C, Tower A, Ground To 6th Floors, Plot No. 8, Express Highway, Sector 127, Noida, Uttar Pradesh 201301
 
Date & Time: 2nd Apr 2016, 9 AM to 4 PM
 
Registration Link:

http://www.meraevents.com/previewevent?view=preview&eventId=96892

 
Contact Person: Aman Sharma/ Deepak Sharma (ni.chapter@aioug.org)

Time

Session Title

Speaker

9.00 to 9:30 AM Registration
9:30 to 10:00 AM North India Chapter & OTNYathra 2016 Updates Aman/Navneet/Deepak
10:00 to 11:15 AM Manage the Modern Cloud using Oracle Management Cloud (OMC) Neelima Bawa
11.15 to 11.30 AM Tea Break & Networking
11.30 to 1.00 PM Hybrid Cloud Management for DevOps using Oracle Enterprise Manager Akshay Sangaonkar
1:00 to 2:00 PM Lunch Break
2:00 to 3:15 PM Oracle Database Cloud Service Saurabh K. Gupta
3:15 to 4:00 PM Q & A / Wrap-Up
 
Session Title: Manage the Modern Cloud using Oracle Management Cloud (OMC)
Session Abstract:  Oracle Management Cloud (OMC) is a suite of next-generation integrated monitoring, management and analytics solutions delivered as a service on Oracle Cloud.

• Designed for today’s heterogeneous environments, across your premises, Oracle Cloud and third-party cloud services.

• Built on a horizontally scalable big data platform with high-throughput processing to provide real-time analysis and deep insights across technical and business events.

• Automatic analysis of data using machine learning, and correlation across all Oracle Management Cloud services, thereby eliminating multiple information silos across end-user and infrastructure data.

OMC has following services:

•  Application Performance Monitoring

•  Log Analytics

•  IT Analytics

In this session, we will learn about Oracle Management Cloud and its various features.

Speaker Bio: Neelima has around 18 yrs. of total IT experience. She has been with Oracle for 15 years and has held a variety of positions in product development and has worked with multiple products like Oracle Internet Directory, Oracle Identity Manager, and as a Development Manager for JVM Diagnostics (AD4J). In her latest role, Neelima is working with Oracle Enterprise Manager Strategic customer engagements, helping customers successfully deploy

Oracle Management Cloud and OEM to manage their engineering systems and middleware technologies.

 
Session Title: Hybrid Cloud Management for DevOps using Oracle Enterprise Manager
Session Abstract:  Deploy, move, and manage your data and applications with ease anytime, anywhere, both on premises and in Oracle Cloud—with a single pane of glass. Oracle Enterprise Manager 13c provides the single pane of glass that lets DevOps/IT administrators and DBA’s deploy their assets into the cloud or migrate them across clouds, and most important, monitor and manage them on a continual basis. In this session, learn how Oracle Enterprise Manager simplifies management of the database and middleware assets using capabilities for the database as a service and middleware as a service. We will also see how enterprise manager extends these capabilities to Oracle cloud using a hybrid cloud solution.
Speaker Bio: Akshay is a product manager for Enterprise Manager and focuses on a private and hybrid cloud. With broad experience of more than 15 years in development, consulting and product management, he helps customers move to  cloud quickly and efficiently. He is a regular speaker at Oracle customer webcasts and IOUG and has helped many customers on their cloud journey.
 
Session Title: Oracle Database Cloud Service
Session Abstract:  Oracle Database Cloud service is a part of Oracle’s Platform as a Service solution offering in the public cloud. Upon subscription, it provides you a dedicated Oracle Database instance within a virtual container in Oracle’s public cloud environment. The database on the cloud is the same software piece that we all are aware of and have been working with since years.

 

As a cloud service consumer, you can choose between manual or automated database cloud service, Oracle database editions, standard or high memory compute shapes, and backup strategy at the time of service creation. Oracle Database Cloud Service offers full portability between on-premise and cloud instances that mean, you can lift and shift the data from on-premise to the cloud and vice versa.

You get to perform the wide range of database operations, manage and monitor database instance on the cloud. With the Oracle’s DBaaS offering, you can run your database application without planning and procure database server infrastructures. The key drivers of Oracle Database Cloud Service are to reduce cost and risk while enhancing the agility and manageability. Attend this session, if you are a seasoned Oracle database administrator or architect and want to learn about Oracle Database Cloud service.

Speaker Bio: Saurabh K. Gupta is a Principal Technologist with the Database Product Management Team in Oracle’s Server Technologies organization. At Oracle, his work is focused on driving Oracle database adoption programs with the partner community and customers. His technology focus is centered around database architecture, Oracle Public Cloud, Database In-Memory, Multitenant, Exadata, Big Data solutions, and Hadoop. He has authored the first and second of “Oracle Advanced PL/SQL Developer Professional Guide”.

Regards,

Nikhil


Oracle 12c Poster-Interactive Quick Reference

I was just looking for some data dictionary views of 12c over the Google and I found very good interactive reference of 12c by Oracle,  This is very good handy for beginners, So I thought of sharing with you all.

So here is link to this cool Oracle Poster

This posters cover below  topics:-

  1. DBA Views
  2. Performance Views
  3. Architecture Views
  4. Database Architecture
  5. Multitenant Architecture
  6. Background Architecture

Enjoy Reading!


Oracle Performance Tuning Day – Gurgaon

DBA Friends, North India Chapter has organised full day exclusive Database and Application Tuning session by Tuning Expert Vivek Sharma on 17th October.

This session will cover all the advance topic of tuning components like SQL, Network and Database performance tuning, Architecture, Design and many more.

This is one of golden opportunity for Application developers and DBAs to learn from Tuning Expert Vivek Sharma.

Register now before its too late, Only 4 days to go, Here is direct link to register for the event.

http://www.meraevents.com/event/oracle-performance-tuning-day-gurgaon&ucode=organizer

Here is Agenda of this Event:-

9:00 AM Registration opens
9:30 AM AIOUG NI Chapter Updates
10:00 AM Understanding Oracle Database Concepts for Performance
11:00 AM Networking – Tea Break
11:15 AM Best Practices for Optimization. RAC v/s Single Instance. Why things go Wrong ?
12:45 PM Networking – Lunch
2:00 PM Query Optimizer
3:30 PM Networking – Tea Break
3:45 PM Sangam15 – Updates  & Wrap !

Venue Detail: Sapient Consulting Pvt Ltd
Unitech Infospace SEZ, Sector 21
Ground Floor Unit 3, Tower B, Building No. 8
MPR Conference Room
Gurgaon ,Haryana


SQL PLAN Changed during bulk load

This is one the issue which I faced in my daily DBA routine. So I thought I should share my experience with you guys, So this type of issue can be avoided or resolved at first attempt.

OS Version: RHEL 6.5

Oracle Software Ver: 11.2.0.4, Two node cluster

Issue Detail:- Every after 2-3 days, high load and  I/O wait was being observed on one of nodes of the cluster . Due to high I/O wait and load on the server, locking starts at database level and application stop responding.

Here are couple of troubleshooting steps performed to diagnose and fix this issue:-

1. Whenever issue comes, Below message appeared in the alert log file, which comes due to high load on the server.

“minact-scn: useg scan erroring out with error e:12751 ”

2. AWR Analysis

Top 10 Foreground Events by Total Wait Time
Event Waits Total Wait Time (sec) Wait Avg(ms) % DB time Wait Class
gc buffer busy acquire 2,091 155.7K 74466 76.5 Cluster  <<<<<<<<<<<<<<
gc current block busy 68 3637.4 53491 1.8 Cluster
gc cr block busy 33 1405.6 42594 .7 Cluster
DB CPU 952.3 .5
enq: TX – row lock contention 28 568.5 20304 .3 Application
buffer busy waits 4,792 273.3 57 .1 Concurrency
enq: RO – fast object reuse 6 267 44496 .1 Application
log file sync 2,460 162.9 66 .1 Commit
rdbms ipc reply 18 33.5 1861 .0 Other
gc buffer busy release 46 28.4 618 .0 Cluster

Global Cache and Enqueue Services – Workload Characteristics

Avg global enqueue get time (ms): 19.1
Avg global cache cr block receive time (ms): 1,437.5   <<<<<<<<<<<<<VERY SLOW
Avg global cache current block receive time (ms): 806.5  <<<<<<<<<<<<<VERY SLOW
Avg global cache cr block build time (ms): 0.0
Avg global cache cr block send time (ms): 0.0
Global cache log flushes for cr blocks served %: 0.1
Avg global cache cr block flush time (ms): 47.0
Avg global cache current block pin time (ms): 85.1
Avg global cache current block send time (ms): 0.0
Global cache log flushes for current blocks served %: 9.5
Avg global cache current block flush time (ms): 66.4

Looks like we hit bug 13508198 based on AWR top 10 wait events

MOS: Very high Avg global cache current block pin time in AWR report ( Doc ID 1961394.1 )

To fix this issue patch 13508198 was suggested on the metalink, However to apply this patch our Oracle binary needed to be on 11.2.0.4.7, However my Oracle binary version was 11.1.0.4.0 , So to fix this issue I had applied latest PSU 11.2.0.4.7 on grid and db home and then applied patch 13508198 on top of it.

However even after applying latest PSU and bug fix, Issue was not resolved .

3. I have observed that, this issue is coming almost at same time. So started digging at application and database level jobs and found that one batch load using SQL Loader is being done at the same time, when this issue is observed. This SQL Loader job inserts around 1 million rows in table, This is same table which is being used by the live application. Since both thing runs in parallel, Sometimes when bulk insert does not complete less than in 6 minutes, Then query used by the live application, start doing the Full table Scan, thus creating high load and I/O on the server.

There are several reason for query plan change, But I will discuss only those which matches to our current situation :-

  1. Tables Stats change due to heavy insert or delete.
  1. Index Stats changes
  1. Lack of object level statistics
  1. Invalid or invisible indexes (All indexes were in present and visible)

Above first three points are related to this issue. Let me show you artifacts of this issue.

Good Execution plan of the query :-

This is a good execution plan(Plan hash value  Here is record from AWR report and OLD PLAN repository , Where Full table scan is performed at the time of issue.This is a snippet of AWR report when PLAN (4272749824) of query has been changed and it is doing full table scan.) of the query, where index is being used and query is coming well in time.

Goodplan

Here is record from ASH report and OLD PLAN repository , Where Full table scan is performed at the time of issue.This is a snippet of ASH report, when Plan hash value 4272749824 of query has been changed and it is doing full table scan instead of using PHV 4272749824.

ASHRPT snip

ChangePHV

When I checked execution plan of query for PLAN_HASH_VALUE 4272749824, There I found the change in plan,Where full table scan was performed.

wrongplan.

To fix this issue, I have applied baseline on the query as shown in the below query. This baseline will ensure to use optimal plan.

Baseline_CAP

For more detail on creating baseline on query, please follow the Maria colgan blog

https://blogs.oracle.com/optimizer/entry/sql_plan_management_part_1_of_4_creating_sql_plan_baselines

https://blogs.oracle.com/optimizer/entry/sql_plan_management_part_2_of_4_creating_sql_plan_baselines

https://blogs.oracle.com/optimizer/entry/sql_plan_management_part_3_of_4_creating_sql_plan_baselines

https://blogs.oracle.com/optimizer/entry/sql_plan_management_part_4_of_4_creating_sql_plan_baselines

Now whenever query will be executed, Baseline will be used for this query execution

Baselineuse

Earlier there was no baseline used for this query

NoBaseline

That all my DBA friends, Happy Reading.


[INS-30502] No ASM Disk Group found in 11gR2 while creating a database

I have faced this issue during the creation of RAC database on newly built cluster. This blog will take you through all the possibility of this error and finally the exact solution of this issue.

OS Version : RHEL 6.5

Database Version: 11.2.0.4.7

Snippet of issue I have faced during the creation of RAC database:-

NoDisk

Now here is list of troubleshooting, which I did to fix this issue but didn’t work.

  1. Checked the ASM disk and asm Instance using ASMCMD and ASMCA, you can use the sqlplus to check that. I found all asm instances are up and running and disk groups are mounted.
  1. asminst

2. Metalink Search “[INS-30502] No ASM Disk Group found” in 11gR2 while creating a database (Doc ID 1107138.1), This link gives the solution to unset the ORA_NLS10 parameter on OS level, Which didn’t work in my case. 

3. Checked the central inventory for any possible issues, No issue found.

4. During the troubleshooting, I found that my node were unpinned.

unpin

I pinned the DB nodes of the cluster, but still issue didn’t get resolve.

pin

Till now I have mentioned all my failures to resolve my issue. Now my Last point is how I hit the bulls eye.

Here is issue and solution to this problem:-

5. Then I started looking at OS level configuration and found the culprit

group

Now if you take a closer look then you will notice that asmdba group is not a part of Oracle user, This is reason ASM diskgroup was not detected by the Oracle user, Since creation of database is being done by Oracle user.

Then I simply added the asmdba group to Oracle using command groupmod, Then issue got resolved.

Hope this blog help to resolve your issue.


Creating manual standby database in Standard edition – Part 1

I am sure lot of DBA may have come across the situation, where they are required to create standby database for their critical databases. However few of unlucky DBA are working on Standard edition database and Standard edition database does not have the Dataguard or Standby feature. So most of them create manual standby, where they usually create another clone database using the RMAN backup and keep the database in recovery mode. By using the shell script they apply the production generated archives to cloned standby database. Even I was using the same method 6 years back.

However one year back one of our vendor was using file replication software and claiming that they provide almost equivalent feature of Enterprise dataguard, I couldn’t believe that, So I decided play around a bit with that software, When I checked code inside the software, So I came to know it was all shell scripting , However there were some good point, which  I have never used in my manual standby, So now enough with talking, Let me demonstrate the Manual standby creation :-