FINANCIAL SERVICES COMPANY SAVES MORE THAN $2M IN ORACLE RELATED COSTS WITH VXFLEX INTEGRATED RACK

For four years, this financial services company had been running Oracle Exadata on their Oracle databases. During that time, database administrators managed the Exadata infrastructure themselves but as the environment grew to six Exadata systems they struggled to keep up with the day-to-day care and maintenance of those systems. Having experienced multiple performance inconsistencies, the lean IT team of eight people required the infrastructure team to become involved. It was then that the company realized the value and efficiency of utilizing HCI to improve current operations. With the Dell EMC solution that is described in this case study, the benefits included $1.8M reduction in hardware support expenses over three years, 13% decrease in core Oracle licensing and $455K savings in Oracle licensing support costs annually along with 12% performance improvement on workloads. Read the full report here: hashtag
https://www.dellemc.com/en-us/collaterals/unauth/customer-profiles-case-studies/products/converged-infrastructure/dellemc-financial-case-study-final.pdf  #iwork4dell

Dell EMC "Ready Bundle for Oracle"

The Dell EMC "Ready Bundle for Oracle" supports both production OLAP and OLTP along with test/dev environments in a single VMware virtualized environment. The high availability (HA) architecture and design built at every component level of the solution eliminates single point of failure and provides flexibility for planned maintenance downtime. 

Lower entry point with a purchase price up to 55% lower than the most advanced engineered solution for Oracle in the market, according to an internal cost analysis.

The Dell EMC Ready Bundle for Oracle has optimized Dell EMC VMAX All Flash storage, combined with VMware® virtualization, enabling consolidation onto fewer servers and storage arrays for lower capital expense (CapEx) and operational expense (OpEx).

Read more about the Bundle here: https://lnkd.in/fc3EY78

Free Trial access to Oracle Licensing training portal

Dear Friends.

Here's a golden chance for Oracle professionals to get access to the Free, Trial training module on ORACLE LICENSING. My friend Sibaji Dey Choudhury has created this unique, comprehensive training portal on Oracle License Management, with an objective towards understanding Oracle's complex licensing rules, optimizing costs and avoiding non-compliance.

So, how do you get the Free, Trial access?

Step 1: Sign up on www.LicensingCircle.com (takes 1 minute)
Step 2: Request Free, trial access on the Contact Us page

I sincerely hope this will benefit all our readers and their contacts.

Best regards,

Porus Homi Havewala,
Oracle Certified Master.

From Gavin Soorma: Implementation Online Workshop Oracle GoldenGate 12c Release 3 (with Oracle 12c Release 2 RAC/ASM)

Based on popular demand, my friend Gavin Soorma and fellow Oracle Certified Master, is offering this brand new online training course combining Oracle GoldenGate with Oracle Clusterware and RAC/ASM. This course is the first of its kind and spaces are limited!

Learn how to install and configure your own two node Oracle 12c Release 2 RAC cluster environment and deploy a cluster-based highly available Oracle GoldenGate 12c Release 3 environment. Book your seat for the course by sending an email with your particulars to Gavin at his email address prosolutions@gavinsoorma.com , and registration details will follow shortly.

Course Duration: 24 hours (6 weeks)
Commencing: Sunday 11th March 10.00 AM US EST
Course Fee: 699.00 USD

Hands-on Lab Exercises with recordings provided of every session

Course Topics and Objectives:
Install and Configure Oracle 12c Release 2 Grid Infrastructure, ASM and Clusterware
Create an Oracle 12c Release 2 RAC database
Configure High Availability for Oracle GoldenGate using Grid Infrastructure Agent (XAG)
Simulate GoldenGate processing recovery from cluster node failure
Learn about the new Oracle GoldenGate 12c Release 3 microservices architecture, topologies and components
Installation of Oracle GoldenGate 12.3 Classic as well as Microservices Architecture
Configuring the Manager process
Prepare the Oracle database for GoldenGate replication
Create Classic/Integrated extracts and replicat process groups
Create Co-Ordinated /Parallel replicats
Configure and manage DDL replication
Configuring security and encryption of trail files and credentials in GoldenGate
Column mapping, Data filtering and transformation
Using the Logdump utility to examine trail files
Using OBEY files, macros and tokens
Handling errors and exceptions in GoldenGate
Configuring Automatic Heartbeat Tables
Monitoring Lag
Configuring Bi-Directional replication, Conflict Detection and Resolution, and new 12c Release 3 automatic conflict resolution

Oracle Licensing bootcamp training in your city

Dear Friends, 

In the year 2018, our friend Sibaji Dey Choudhury is conducting 2-day "comprehensive" bootcamp trainings on Oracle Licensing in several major cities across the world. At the end of the intensive bootcamp training, you have the option of an assessment at no extra cost to get an "Oracle Licensing Maestro" certificate. 

Sibaji has 13 years of experience on "Oracle Licensing" training and consulting services, across 300+ customers worldwide.

If you are are interested in an "Oracle Licensing" bootcamp training in your city, please register your interest through the Contact page of www.LicensingCircle.com . Kindly mention your full name, email id and your city. 

Best regards, 
Porus Homi Havewala
Oracle Certified Master.

NEW ORACLE 12C RELEASE 2 PERFORMANCE TUNING WORKSHOP BY GAVIN SOORMA

Dear Friends,

In 2018, we are very pleased to announce the upcoming new Oracle 12c Release 2 Performance Tuning Workshop.  This will be conducted by my friend Gavin Soorma who is an Oracle ACE Director, Oracle Certified Master,  and a highly experienced Oracle technology instructor.

Oracle 12c Release 2 Performance Tuning Workshop:
Course Duration: 20+ hours. This webinar meets 5 times.

Mon, Jan 22, 2018 12:00 AM - 4:00 AM AEST
Mon, Jan 29, 2018 12:00 AM - 4:00 AM AEST
Mon, Feb 5, 2018 12:00 AM - 4:00 AM AEST
Mon, Feb 12, 2018 12:00 AM - 4:00 AM AEST
Mon, Feb 19, 2018 12:00 AM - 4:00 AM AEST

Course Fee: 599.00 USD including a lifetime subscription to Oracle DBA Tips & Techniques website

Hands-on Lab Exercises with recordings provided of every session

Course Topics and Objectives:

Tuning Methodology
Using Automatic Workload Repository and AWR Baselines
Using Active Session History (ASH) Analytics
Using and interpreting ADDM including Compare Periods ADDM
Real-time ADDM and Emergency Monitoring
Tuning the Buffer Cache
Tuning the Shared Pool
Tuning sort operations and PGA
Managing optimizer plan stability
Adaptive Plans, Re-optimization and SQL Directives
SQL Outlines and SQL Plan Baselines
SQL Profiles
 Gathering and managing optimizer statistics
Gathering and managing histograms
Bind Variables, Cursor Sharing, and Optimizer Hints
Using SQL Performance Analyzer
Tuning using wait events
Optimizing performance by partitioning data
Indexes, Access Paths, and Join Operations
Tracing SQL statements
Automatic SQL Tuning
Generating and Displaying Execution Plans
SQL Monitoring
Creating and managing the Result Cache
….. and more!

Registration URL:

https://attendee.gotowebinar.com/register/2592113343928404226

 Hope you enjoy the workshop.

Regards,

Porus Homi Havewala
Oracle Certified Master,
Oracle ACE Director Alumnus.

FREE, Trial access to Oracle Licensing training portal​

Here's your final chance for 2017 to get access to the FREE, TRIAL training module on ORACLE LICENSING. My friend Sibaji Dey Choudhury has created this unique, comprehensive training portal on Oracle License Management, with an objective towards understanding Oracle's complex licensing rules, optimizing costs and avoiding non-compliance.

So, how do you get the Free, Trial access?

Step 1: Sign up on www.LicensingCircle.com (takes 1 minute)
Step 2: Request Free, trial access on the Contact Us page

I sincerely hope this will benefit all our readers and their contacts.

Best regards,

Porus Homi Havewala,
Oracle Certified Master.

FREE customised workshops on "Oracle License Management"

Friends,

My friend Sibaji Dey Choudhury is offering customised workshops on "Oracle License Management" for members of this group. The workshops are FREE, and are designed to highlight potential Oracle licensing issues that your organisation may be facing. Each workshop will be on a 1-on-1 basis, and will last around 3 to 4 hours depending on the size of the Oracle license estate.


A bit of introduction: Sibaji Dey Choudhury is an experienced Oracle Licensing Specialist with 13 years of dedicated experience on "Oracle License Management" across 330 customers worldwide. His services are fully independent, as he does not have any partnership with Oracle, does not re-sell Oracle licenses and also does not recommend any Oracle re-sellers.

You can reach Sibaji by email: sibaji@konnagar.com or by phone: +44 776 017 1216 (UK) and his company website is https://www.konnagar.com/

This is your opportunity to get all your Oracle licensing issues sorted and queries answered!

Best regards,

Porus Homi Havewala,
Oracle Certified Master.

Part VI of my article series "Database as a Service using Enterprise Manager"

Part VI of my article series "Database as a Service using Enterprise Manager" 

https://goo.gl/7mDqLe

Author Signed Copy of my Oracle Private Database Cloud cookbook

Friends,

My Oracle Press book "Oracle Private Database Cloud cookbook" looks at all the private database/ schema/ PDB services in detail, and shows you how to set up Chargeback, and also explains how to use the RESTful API for performing DBaaS, SCHaaS and PDBaaS, and gives step by step instructions to set up the Oracle Database Hybrid Cloud using the Enterprise Manager Hybrid Gateway to connect to the Oracle Public Database Cloud.

A few Author signed printed copies are now available.  If interested in one of these special copies, contact me directly on phhbooks@gmail.com and I will inform you of the postage charges to anywhere in the world. The book cost is 60 USD and postage will differ as per the country.

Table of Contents:
Ch. 1: Consolidation Planning for the Cloud Ch. 2: Database as a Service Ch. 3: Schema as a Service Ch. 4: Pluggable Database as a Service Ch. 5: Hybrid Database Cloud Ch. 6: Using the RESTful API Ch. 7: Managing Database Backups Ch. 8: Managing Standby Databases


The book has been reviewed by popular Oracle ACE Director Gokhan Atil, he said "I can say that I really liked the book. It’s really easy to read and all topics are explained by detailed samples. Porus Havewala has a deep knowledge and experience about the subject so his instructions are very clear. It’s like following a workshop about building Database as a Services architecture on Cloud."

The book has also been reviewed by Rob Zoeteweij who is an Oracle ACE, Enterprise Manager expert, specialist and trainer. He also has his own Linkedin group on Enterprise Manager. His review says "When you are looking for a book on a thorough guidance through the setup of DB as a Service and Schema as a Service and working with the Self Service portal of Oracle Enterprise Manager release 13c Cloud Control, stop looking you found it. "

Regards,

Porus Homi Havewala
Oracle Certified Master.

Gavin Soorma to conduct new Oracle 12c Data Guard/Backup and Recovery Workshop

Dear Friends,

We are very pleased to announce the  upcoming new Oracle 12c Data Guard/Backup and Recovery Workshop. This will be conducted by my friend Gavin Soorma who is an Oracle ACE Director, Oracle Certified Master, and a highly experienced Oracle technology instructor.

DBAs, protect your company data and also more importantly protect your job!

Learn how to configure an Oracle 12c Data Guard environment and perform switchovers and failovers in an Active Data Guard environment with confidence.

Learn advanced RMAN Backup and Recovery techniques and best practices and also practice recovery from a number of real-life simulated failure scenarios.

The cost of the 20+ hour online course is only $549.00 and also includes a lifetime membership to Oracle DBA Tips and Techniques website repository.

The course will include main  topics which would require attending two Oracle University courses which would cost over $7000!

The course is being offered both on weekends (Saturday US AM) as well on weekdays (Mon -Fri US PM).

Kindly use the registration links provided below to register for the required batch.

Weekdays:

Registration URL: https://attendee.gotowebinar.com/register/3390364281892005121

(The weekday sessions start Mon, Nov 13, 2017 US PM (or Tues in other time zones) and meet 10 times)

Weekends:

Registration URL: https://attendee.gotowebinar.com/register/5499024174315484929

(The weekend sessions start Sat, Nov 11, 2017 US AM (or Sun in other time zones) and meet 5 times, with longer duration sessions)

Regards,

Porus Homi Havewala
Oracle Certified Master.

Free trial access of the Oracle Licensing training course

Friends,

This is a message from my friend and Oracle licensing expert Sibaji Dey Choudhury.

Oracle Licensing has been a global challenge for a number of years now, and a lack of deep understanding on Oracle Licensing has derived $$ Millions during audits from unaware Oracle customers. To help tackle this issue 'Licensing Circle' was built to train and certify Oracle professionals on a comprehensive, portal-based knowledge on Oracle License Management.

The Oracle Senior DBA group on Linkedin has negotiated with 'Licensing Circle' to provide for the members of the Oracle Senior DBA Group a Free, trial access of the Oracle Licensing training course. This offer is also open to your own Linkedin contacts who may not be a member of the group.

So, how do you get the Free, trial access of 'Licensing Circle'?

Step 1: Sign up on www.LicensingCircle.com (takes 1 minute)
Step 2: Request Free, trial access on the Contact Us page. Mention the Oracle Senior DBA group.

We sincerely hope this will benefit all our group members and their contacts.

Best regards,

Porus Homi Havewala,
Oracle Certified Master.

Part V of my article series "Database as a Service using Enterprise Manager"

This is Part V of my article series "Database as a Service using Enterprise Manager" 

https://goo.gl/q92vYE

Gavin Soorma Implementation Workshop: GoldenGate 12c

From fellow Oracle Certified Master Gavin Soorma:

Register for the new Oracle GoldenGate 12c Release 3 online training course from Gavin and learn all about the exciting new features in Oracle 12.3 OGG like the Microservices Architecture, Parallel Replicats, Automatic Conflict Resolution and more as well as fast track yourself towards acquiring the skills to implement and maintain an Oracle 12c GoldenGate replication environment. Great for cloud database migrations as well.

Course Duration: 20+ hours
Course Fee: 549.00 USD including a lifetime subscription to Gavin's "Oracle DBA Tips & Techniques" website
Hands-on Lab Exercises with recordings provided of every session

Course Topics and Objectives:

• Learn about the new Oracle GoldenGate 12c Release 3 microservices architecture, topologies and components
• Installation of Oracle GoldenGate 12.3 Classic as well as Microservices Architecture
• Configuring the Manager process
• Prepare the Oracle database for GoldenGate replication
• Create Classic/Integrated extracts and replicat process groups
• Create Co-Ordinated /Parallel replicats
• Configure and manage DDL replication
• Configuring security and encryption of trail files and credentials in GoldenGate
• Column mapping, Data filtering and transformation
• Using the Logdump utility to examine trail files
• Using OBEY files, macros and tokens
• Handling errors and exceptions in GoldenGate
• Configuring Automatic Heartbeat Tables
• Monitoring Lag
• Configuring Bi-Directional replication, Conflict Detection and Resolution, and new 12c Release 3 automatic conflict resolution

Both weekdays as well as weekend batches are available for this training course.

Use the links below to register for the training.

Weekdays:
https://register.gotowebinar.com/register/3835502663575201281
From Mon, Oct 23, 2017 and meets 10 times

Weekends:
https://register.gotowebinar.com/register/858048265303651073
From Sun, Oct 29, 2017 and meets 5 times

New Oracle Training from OCM Gavin Soorma

Dear Friends,

Fellow Oracle Certified Master Gavin Soorma has now created some exciting new Oracle training courses.  On his behalf, we are pleased to announce the following forthcoming online training courses:

<> Oracle Database 12c Release 1 and Release 2 New Features
<> Oracle 12c Data Guard and Backup and Recovery
<> Oracle Performance Tuning Workshop
<> Exadata essentials for Oracle DBA’s
<> Oracle GoldenGate 12c Release 3 Implementation Workshop
<> Oracle GoldenGate 12c Release 3 Advanced Workshop
<> Oracle 12c Clusterware, RAC and ASM
<> SQL Server 2016 for Oracle DBA’s

All the above courses are between 16 to 20 hours in duration (4 hours a week) and are each priced at only 499.00 USD including a free lifetime membership to his Oracle DBA Tips and Techniques website.

Recordings will be made available for each session and every course will carry several hands-on lab exercise modules for which remote support will be provided as well.

Kindly register your interest for any of the training courses listed via the link below:

https://gavinsoorma.com/new_training_courses/

Regards,

Porus Homi Havewala
Oracle Certified Master.

Aussie Database Performance Tuning software "Ellarose" from Riyosu

My friend and fellow Oracle OCP Nathan McAteer is providing all readers with an opportunity to purchase the latest version of Riyosu’s Aussie database performance tuning software "Ellarose" at a discounted rate. Ellarose, named after his daughter by the proud father, is used by some of Australia’s largest financial institutions on a daily basis. In fact the majority of articles posted by Nathan on the Riyosu website are real world scenarios from one of the top 4 Australian banks.

The product is extremely versatile and covers a range of Oracle version and editions. Both Standard and Enterprise edition are supported from 10g. Backward compatibility from 9i downwards is cleverly done by allowing the user to tailor the underlying scripts which query the database performance metrics. Access to the underlying scripts is a huge bonus and rarely do vendors share the intelligence of their product like this. It means you also get access to hundreds of great performance scripts. Not licensed to use AWR? Not a problem because it also works on STATSPACK. There are a whole series of articles from Nathan on the Riyosu web site https://www.riyosu.com about the database performance tuning that can be achieved by Ellarose.

The Ellarose product itself can be downloaded through the Riyosu online store at https://www.riyosu.com/online-store for an annual subscription of $349 USD (further discount code provided below). Once you have your subscription you can use it on *any* number of databases within your organisation. Note that similar products on the market would cost ten times as much.

For a further 10% discount, enter the special coupon code of "SDBA1".

Note: You can apply your discount code after clicking on the “BUY NOW” button.

Regards,

Porus Homi Havewala,

Oracle Certified Master.

Optimize Oracle response times with Cary Millsap using Method R

Came across this interesting logical method of Oracle Database Tuning called as Method R, created by Cary Millsap (pictured), a performance tuning expert and an Oracle veteran. If you want to learn more about Method R, you can attend the webinar below. The following information is from Cintra where Cary is currently a Vice President.

------------------------------------------------------------------------

• Date:            Thursday 26th October 2017
• Time:            11:00 (EDT) and 16:00 (BST)
• Duration:     30 minutes + 15 minutes Q&A
• Location:     Online webinar

Your customers’ experience with the speed of your applications is an important differentiator. As you move to the cloud, delivering excellent performance experiences becomes even more challenging.

Traditional Oracle performance management isn’t enough; our revolutionary approach enables you to understand exactly how your users experience your systems.

In this webinar, Cintra practice leader Kyle Smith will discuss Method R with Cary Millsap. Join us to learn more about this extraordinary advance in Oracle performance optimization:

• What does “faster systems” really mean?
• Why is it so hard to get there?
• What is Method R? How is it different? Why did we create it?
• How does the process work?
• How does moving to the cloud affect performance management?

If you’re unable to make the time below, please register and we’ll send you the recording afterwards.

Please register on http://www.cintra.com/event/webinar-optimize-oracle-response-times-with-cary-millsap-26th-october-2017/ 

Recordings of Previous Webinars:

17^th August Method R webinar:

http://www.cintra.com/knowledge-article/optimize-oracle-response-times-with-cary-millsap/

27^th September Method R webinar:

http://www.cintra.com/knowledge-article/webinar-optimize-oracle-response-times-with-cary-millsap/

Product demonstration recording:

http://www.cintra.com/knowledge-article/method-r-product-demonstration/

-------------------------------------------------------------------

EXADATA Essentials For Oracle DBAs: Hands-on 4-Week Saturday Workshop by Gavin Soorma (OCM)

My friend and fellow Oracle Certified Master Gavin Soorma, after his recent popular Oracle RAC workshop (over 100 registrants) is now offering a new hands-on 4-week Saturday workshop on "Exadata Essentials For Oracle DBA’s", so you can fast track your path towards becoming an Oracle Database Machine (DMA) administrator.

In this new workshop, instructions will be provided by Gavin on how to install and configure an Exadata Storage Server on your own individual VirtualBox platform.

You will learn about the architecture, key features and capabilities of Exadata Database Machine as well as how to administer, monitor and manage the Exadata Storage Server using the CELLCLI command line interface. Attendees will learn how to use CELLCLI to create and manage celldisks, grid disks and flash disks as well as how to configure alerts and monitoring of storage cells on their own individual Exadata Storage Server environments.

The 4-week online workshop commencing on Saturday, 30th September will include hands-on lab exercises for each module (for which remote support will be provided) and cover a wide variety of topics (the full list can be seen in the registration URL given below). Recordings of sessions  will be made available for future reference.

The course curriculum is based on topics in the Exadata Database Machine: 12c Administration Workshop course offered by Oracle University, the latter  costs over US$5000 whereas Gavin's workshop is only $499.00 USD which is about 1/10th of the cost.

Kindly use the link below to register and pay for the Exadata Essentials for Oracle DBA’s training course.

Registration URL: https://attendee.gotowebinar.com/register/9089152838780579075

For any related queries or clarifications kindly drop an email to prosolutions@gavinsoorma.com

Regards,

Porus Homi Havewala.

Oracle preps autonomous database at OpenWorld

Oracle preps autonomous database at OpenWorld 

https://goo.gl/snEi7c

IMHO The new database version will probably use the Oracle Management Cloud (OMC) to monitor and tune, the OMC has machine learning using big data analytics to aid performance tuning. Since version 10g, the Oracle DB has had self-tuning capabilities, i.e. auto application of SQL profiles using the Tuning pack license. Everything else was done by the DBA, perhaps with advice gained from the Tuning Advisor, but the DBA had to make the final call. Probably the self-tuning has been carried further in the coming version with expertise from machine learning. Regarding AWS databases, I would agree that the AWS capability of performance insights is only at its starting stage so databases on AWS Aurora cant really be compared to what Oracle will offer in this regard.

No-Win, No-Fee Oracle Licensing Review Offer for your Oracle usage

Dear Friends,

As we all know, Oracle Licensing is a complex subject and a lack of its complete understanding can attract millions of dollars in contractual non-compliance during an official audit. Non-compliance on Oracle Licensing can be due to several reasons, including vague rules and inaccurate analysis. If your Oracle licensing is not fully managed or optimised, then you also risk over-paying for support costs that could have been avoided. Over-Licensing or Under-Licensing can both bring large financial exposure for an Oracle end-user organisation. 

Exclusively for the members/friends of our 'Oracle Senior DBA' group on Linkedin, we have negotiated with 'Konnagar Limited' >> www.konnagar.com << to help you reach a safe harbor with compliance on Oracle licensing. Konnagar Limited won the Gold Award from UK-OUG for 'Independent Services', and is run by Sibaji Dey Choudhury - an ex-Oracle License Auditor with 12+ years of Oracle licensing experience across 300+ customers. 

How is this a good proposition for you? Sibaji will run a complimentary Oracle License Review, exclusively for the members/friends of the group (you need not be a member, just mention the group). If any contractual non-compliance (and therefore, commercial exposure) is identified, only then you pay the fee for the engagement. If no non-compliance is identified, then you DO NOT pay anything. Simple! 

Please note that Konnagar Limited is independent of any Oracle partnership and also does not resell Oracle licenses (or recommend resellers), and therefore has no conflict of interest. The only objective is to help you uncover non-compliance arising out of mismanagement of Oracle Licensing. 

Please reach out to info@konnagar.com to register your interest. This offer is on a 'No-Win, No-Fee' basis exclusively for the members and/or friends of the 'Oracle Senior DBA' group, so please mention the group name in your email to them even if you are not a member.

Best regards, 

Porus Homi Havewala, 
Oracle Certified Master.