Thursday, December 14, 2017

My Presentation on "10 DB Tuning Parameters" @ AIOUG Sangam17, Hyderabad

My Presentation on 10 DB Tuning Parameters @ AIOUG Sangam17, Hyderabad



This is the first time I have presented in AIOUG Sangam17 event held in Hyderabad on 8th and 9th Dec 2017. 
My presentation was on “10 DB Tuning Parameters”.

It was full house session. I am very glad to have such huge response.
I would like to say thanks to AIOUG team who have selected my paper for Sangam17 and many thanks to all delegates who had attended my session.

Below are some snaps of my event.


 


Also I am very glad to share that I have received AIOUG Volunteer of the Year Award, 2017.


Thank you very much to @AIOUG, @Sai Janakiram Penumuru , @Satyendra Kumar and whole AIOUG Team...






Thanks & Regards,
Chandan Tanwani
Oracle Performance Tuning Certified Expert

Friday, December 1, 2017

AIOUG Sangam17

AIOUG Sangam17

Sangam17 - The Largest Independent Oracle Users Conference in India.

Sangam, the largest independent Oracle user’s group conference will feature over 100+ in depth technical sessions presented by expert speakers from inside and outside of Oracle. Over 1000+ database administrators, developers and architects professionals are expected at the conference This is our moment of glory and time for you to join us!


 
       100+ Technical Deep dive Sessions, 100+ Speakers
       10 Tracks – Database, Applications, Development, Cloud, PSFT, HOL, Round Table
       “Want to Succeed in IT? Follow the PRIYA Principle” session by Jim Czuprynski
       Be part of the largest Oracle Users group conference in India
       Build your network with 800+ delegates
       Learn about 18c the Autonomous Database and it’s impact to DBAs
       Be the first to know -  leverage the new features right away out of the conference
       Share the knowledge - Meet the fellow Oracle folks and share your knowledge
       Transform your career by staying  relevant with the industry
           •       GST sessions from Oracle Development

This year I am also speaking in this event.
Join me @ Sangam









 









Venue
HYDERABAD
INTERNATIONAL CONVENTION
CENTRE (HICC)
Hyderabad


Date and Time
08-Dec-2017:- 08:00am to 07:00pm
09-Dec-2017:- 08:00am to 06:00pm




Thanks & Regards,
Chandan Tanwani
Oracle Performance Tuning Certified Expert

Wednesday, November 1, 2017

AIOUG Gujarat Chapter Inauguration Event on 04-Nov-2017

AIOUG Gujarat Chapter Inauguration Event


We are pleased to announce that, AIOUG is going to inaugurate Gujarat Chapter on 04-Nov-2017.
It has been very long time we are planning for this event and finally we are coming to Gujarat.


Please find following details for Gujarat Chapter Tech Event details,

Event Type: AIOUG Tech Event. and Gujarat Chapter Inauguration.
Date: 04-Nov-2017
Time: 8:30 am to 5:30 pm
Location: AMA Institute, Vastrapur, Ahmedabad

Registration Link: https://www.meraevents.com/event/aioug-gujaratchapter-techday



AIOUG Gujarat Agenda - 04-Nov-2017
Time
Session Details
8:30am to 9:00am
Registrations
9:00am to 9:30am
Inauguration of AIOUG Gujarat Chapter 
9:30am to 10:30am
360 Degree Overview of Oracle Cloud Infrastructure by Satyendra Pasalapudi
10:30am to 10:45am
Tea Break & Networking
10:45am to 11:45am
Cloud , No Cloud by Abhinivesh Jain
11:45am to 12:45pm
Oracle Cloud DBCS & OMC (Demo)
by Kishore Surve
12:45pm to 1:30pm
Lunch
1:30pm to 2:30pm
Analyzing and Interpreting AWR by Satyendra Pasalapudi
2:30pm to 3:30pm
Migrating to Oracle Cloud 
by Abhinivesh Jain
3:30pm to 4:00pm
Tea Break & Networking
4:00pm to 5:00pm
Oracle Internals: Locking Mechanism
by Chandan Tanwani
5:00pm to 5:30pm
Raffle Prizes, Group Photo & Closing


We are looking forward to see you soon.


Thanks & Regards,
Chandan Tanwani
Oracle Performance Tuning Certified Expert


Tuesday, October 17, 2017

AWR in Multitenant Environment : Oracle 12cR2

AWR in Multitenant Environment : Oracle 12cR2 


Starting with Oracle Database 12c Release 1, Multitenancy is the core part of Database, where a container database (CDB) can include multiple pluggable database (PDBs).

Oracle Database 12c Release 1 (12.1.01) is having centralized Automatic Workload Repository (AWR) repository to store performance data related to CDB and PDBs. One can take an AWR snapshot only at a CDB-level, i.e CDB root. This AWR snapshot is for the whole database system, i.e it contains the statistical information about the CDB as well as all the PDBs in a multitenant environment.

Starting with Oracle Database 12c Release 2 (12.2), CDB root as well as individual PDBs store performance related data, view, and manage AWR data. One can take an AWR snapshot at a CDB-level, i.e on the CDB root, as well as at a PDB-level, i.e. on the individual PDBs.

The CDB-level snapshot data is stored in the SYSAUX tablespace of a CDB root.
The PDB-level snapshot data is stored in the SYSAUX tablespace of a PDB.

The AWR_PDB_AUTOFLUSH_ENABLED initialization parameter enables you to specify whether to enable or disable automatic snapshots for all the PDBs or for individual PDBs. The automatic snapshot operations are enabled by default for a CDB, but are disabled by default for a PDB.

To enable automatic snapshots for a PDB, the PDB administrator must connect to that PDB, set the value for the AWR_PDB_AUTOFLUSH_ENABLED parameter to true, and set the snapshot generation interval to a value greater than 0.

NOTE : PDB snapshot ID's can be different from CDB snapshot ID's

Let's see an example of how it looks like when running AWR report in 12c Release 2:

Step 1: Login sqlplus as command line.



Step 2: Run awrrpt.sql file as shown in below screen shot.
SQL> @$ORACLE_HOME/rdbms/admin/awrrpt.sql



 
Step 3: Select AWR Type

Choose AWR_PDB to generate PDB level AWR report.


It will ask few things as below,
Enter value for report_type: html
Enter value for awr_location: AWR_PDB



Step 4: Input snap id and other parameters, example shown in screenshot.



Enter value for num_days: 1


Enter value for begin_snap: 30
Enter value for end_snap: 31





How PDB AWR looks like  ?


Here you can see, container name, Instance name, Unique name, CDB.

Hope this article help you to generate PDB level AWR report.



Thanks & Regards,
Chandan Tanwani
Oracle Performance Tuning Certified Expert