Exadata Storage Server Internals

Exadata Storage Server Internals

 

Session Abstract:
Storage is one of the most critical tiers in any database technology, The Exadata Storage Server runs the Exadata Storage Server Software and it provides several features like Smart Scan, Smart Flash Cache, Smart Flash Logging, IO Resource Manager, Storage Indexes and Hybrid Columnar Compression. Managing them becomes very important, take a deep dive into Exadata Storage Server Internals to know more on it.
Karan Dodwal (OCM) ♠
Karan Dodwal
Oracle Exadata Consultant, Fidelity International

Karan Dodwal is an Oracle ACE and Oracle Certified Master (OCM) with specialization in Oracle Cloud, Oracle Exadata and Performance Tuning, he works with Fidelity International as a Exadata DMA. He is an OTN Author where he frequently publishes articles on OTN, OTN Portuguese, OTN Spanish. He is a speaker and technical evangelist for All India Oracle Users Group where he presents sessions on Oracle Technology in various events like Sangam and OGYatra. In his free time he helps Oracle Users in Oracle Community through different forums. He has set up several Oracle High Availability Environments on all platforms for mission-critical Oracle Databases.

Getting started with automation in Oracle Cloud Infrastructure

This session will help get you started in Oracle Cloud Infrastructure automation. Maybe you're just starting out in cloud infrastructure management or you just need an overview of the related technology I'll discuss the aims of automation and consider how to get the most value out of automation.  Using working code example in common tools including the OCI API, OCI CLI, Python and Terraform I aim to provide the audience with a platform for further learning of essential skills the world of OCI operational management.

This session was orginally included in the UKOUG Conference 2020 agenda but did not run as planned.
Register
This event is free for members of the UKOUG. If you are a guest that registered for the UKOUG Conference 2020, please contact us with your booking details to book for this session for free.
27-JAN-2021
MEMBER RATE
This event is already included with your membership
Included in your membership

Register

GUEST ATTENDEE
You can attend this event at the non-member rate but membership may be a more cost effective option, find out more here.
£25

Register

STUDENT
Students can attend for free
FREE

Register
Speaker

Graham Smith

Graham Smith, Cedar Consulting

Graham Smith leads the PeopleSoft Technology Practice at Cedar Consulting (Version 1). He is an experienced software engineer and cloud infrastructure analyst and is an Oracle Cloud Infrastructure Certified Architect.  He’s also an Oracle ACE Director and is a regular presenter at Oracle OpenWorld and User Group events around the world and enjoys the friendly and helpful community of Oracle users.

Oracle Developer Live: AI and ML for Your Enterprise

Oracle Developer Live: AI and ML for Your Enterprise
Put AI to work for your business and IT operations. AI can accelerate automation, reduce human errors, and enhance business insights. Join Oracle executives and product experts as they discuss how to eliminate the development roadblocks to building an AI-powered enterprise. Because data is the foundation for AI, you'll also learn how to access, prepare, and process it with speed and agility.

Attend Oracle Developer Live to discover how you can optimize the data and machine learning lifecycle and spur AI adoption—all while delivering innovation, automation, and smarter decision making to your business.

Oracle Analytics Cloud – Is It Worth Embracing?

Abstract:
Oracle Analytics Cloud is a robust Analytics solution that provides real-time data in Analytics Dashboards/Reports. It also provides integrations with Enterprise Business applications (such as ERP, HCM, and CRM) and robust reporting and analytics with user-friendly self-service. This session will give you a great understanding of OAC and discuss why creating an Analytics Workplace culture is important.

Learning Objectives:
* Where to start the Analytics Transformation
* How to define & identify analytics success measures
* The key consideration for narrowing your focus area for a successful Data Analytics Implementation
* How to effectively visualize Data using OAC for deriving Business Value
* Understand flexibility in integrating with varied Data Sources
* Learn about the robust Analytical Reporting that OAC provides
* Day in Life Use Case using OAC for an Enterprise Customer

 

Oracle 19c Hands-On Experience: New Features



Join ODTUG and Viscosity for a hands-on virtual class that introduces new features and enhancements in the Oracle 19c Database.

In this two hour class, students will get hands-on experience with Automatic Indexing, Performance Tuning and SQL Quarantine. Participants will also discover ways the Oracle 19c improves database security and protects data.

Only 30 user logins are available for hands-on, so be sure to register quickly as a "Hands-On Participant" if you want to secure a login for yourself. Registration is unlimited for those only interested in watching/listening. 

Outline:

Automatic Indexing 
SQL Performance Tuning Enhancements 
  Automatic SQL Plan Management 
  Real-Time Statistics and High-Frequency Statistics Collection 
  SQL Repair Advisor 
SQL Quarantine 
Security Enhancements 
  Schema-only accounts 
  Passwords removed from Oracle-supplied accounts 
  Privilege Analysis

Preparation: Students will need to have internet access, a web browser and a PDF reader if they are participating as a hands-on student.

Five (5) Oracle Machine Learning Notebooks You Should Know!

Oracle Machine Learning Notebooks provide a collaborative user interface for data scientists and business and data analysts who perform machine learning in Oracle Autonomous Database--both Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP). Oracle Machine Learning Notebooks enables data scientists, citizen data scientists, and data analysts to work together to explore their data visually and develop analytical methodologies. The Notebooks interface provides access to Oracle's high performance, parallel and scalable in-database implementations of machine learning algorithms via SQL and PL/SQL, with support for Python and R coming soon. Easy to understand and easy to repurpose, OML notebooks enable novice, intermediate and expert Oracle data professionals to leverage OML’s 30+ algorithms for classification, regression, anomaly detection, attribute importance, clustering, associations, text mining and other machine learning problems. This HOL session steps users through five (5) “must see” OML notebooks that serve as the core of many data science projects: classification, attribute importance, time-series forecasting, text mining and anomaly detection. Come learn how to get started using Oracle Machine Learning to tackle a wide variety of data-driven problems.

This session was orginally included in the UKOUG Conference 2020 however, due to a technical issue it did not run as planned.
Register
This event is free for members of the UKOUG. If you are a guest that registered for the UKOUG Conference 2020, please contact us with your booking details to book for this session for free.
20-JAN-2021
MEMBER RATE
This event is already included with your membership
Included in your membership

Register


GUEST ATTENDEE
You can attend this event at the non-member rate but membership may be a more cost effective option, find out more here.
£25

Register
STUDENT
Students can attend for free
FREE

Register
Speaker

avatar for Charlie Berger

Charlie Berger, Oracle

Charlie Berger is the Senior Director of Product Management, Machine Learning, AI and Cognitive Analytics for Oracle Server Technology. Since 1999, he has been responsible for Oracle Machine Learning—starting when Oracle acquired Thinking Machines Corporation where he was VP of Product Management & Marketing. He works closely with Development, Customers and Applications that embed OML’s algorithms. He is the co-founder of BIWA Inc. that runs the Analytics and Data Oracle User Community (AnDOUC) TechCasts and events. Previously, he worked in product management and engineering in several startups in expert systems, statistical and exploratory data analysis, robotics and machine vision. Prior to that, he graduated from Honeywell Computer’s 3-year Manufacturing Management Program. He holds an MS in Manufacturing Engineering and an MBA, both from Boston University, and a BS in Operations Research/Industrial Engineering from the University of Massachusetts at Amherst.

Why Independent Software Vendors Run Their Applications on OCI

What’s it about?
A move to the cloud is imminent for almost every business. Independent Software Vendors (ISVs) are in a position to both make that transition and to guide their customers in this critical shift. To be successful and to grow, businesses need a cloud platform that is open, scalable, secure, flexible, and highly performant, not to mention competitively priced.

Oracle Cloud Infrastructure (OCI) offers unrivaled performance, flexible consumption models and deployment options at unmatched prices. ISVs deploying and scaling mission critical business applications in the cloud benefit from Oracle’s globally-consistent pricing model and comprehensive SLAs that cover performance, manageability and availability.

Event highlights:

    * Learn more about Oracle Cloud Infrastructure, the next-generation cloud.

    * Hear from key ISV partners on how they were able to successfully scale and seamlessly migrate their applications to Oracle Cloud Infrastructure.

    * Discover how you can join the Oracle ecosystem of ISV partners on a mission to modernize your applications in the cloud.

January 19, 2021
9:00am - 9:02am
Introduction
  • Dave Profozich
    
    Senior Vice President, North America ISV Ecosystem, Oracle
    9:02am - 9:04am
Partner Spotlight
Hear from one of our ISV Partners as they share how their business scaled during unprecedented times, lowering overall costs and surpassed performance expectations due to moving their key workloads to the Oracle Cloud.
Keynote: Why ISVs are Choosing Oracle Cloud Infrastructure
  • Dave Profozich
    
    Senior Vice President, North America ISV Ecosystem, Oracle
    
    Oracle Executive Dave Profozich discusses why Independent Software Vendors (ISV) are leveraging Oracle Cloud Infrastructure for unmatched price-performance, unified data management, comprehensive SLAs and other innovative services to deliver superior value to their customers.
    
    9:16am - 9:31am
Partner Success: The Benefits of Choosing Oracle Cloud Infrastructure
  • David Hicks
    
    Vice President Worldwide ISV Business Development, Oracle.
    
    Learn why three Oracle ISVs chose to move their applications to Oracle Cloud Infrastructure.
    
    9:31am - 9:46am
How ISVs Build Applications on OCI
  • Karan Batta
    
    Global Vice President, Engineering, Oracle
    
    Hear Karan Batta explore the capabilities an ISV needs to build their SaaS products on OCI to scale to millions of users globally. Additionally, he digs into the capabilities that differentiate Oracle from other public cloud providers and how Oracle can help make that migration seamless.
    
    9:46am - 9:51am
    
Getting Started and Next Steps
  • Dave Profozich Senior Vice President, North America ISV Ecosystem, Oracle
    
    Learn about Oracle Programs & Resources for ISVs.
Event Speakers
Dave Profozich
Dave Profozich
Senior Vice President, North America ISV Ecosystem, Oracle
David Hicks
David Hicks
Vice President Worldwide ISV Business Development, Oracle
Karan Batta
Karan Batta
Global Vice President, Engineering, Oracle

ORACLE LIVE – Oracle Database Breakthrough Innovations

Enable a data-driven future
Join Oracle Live on January 13 to learn about the latest version of the world’s most popular database, Oracle Database 21c. Andrew Mendelsohn, executive vice president of database server technologies, will detail how Oracle’s converged database strategy benefits users and developers alike. More than 200 new database innovations—including a low-code application development service—make it easier for customers to develop and run data-driven, mission-critical applications, in the cloud and on-premises.
Following the announcement, join a live Q&A with Oracle product experts.
Featured speaker
Andrew Mendelsohn
Andrew Mendelsohn
Executive Vice President, Oracle Database Server Technologies

Andrew Mendelsohn is executive vice president for database server technologies at Oracle. He’s responsible for products and services centered around Oracle Database, including development, test, and product management of much of the core Oracle Database product. In addition, Mendelsohn’s responsibilities encompass cloud services, including Autonomous Data Warehouse and Autonomous Transaction Processing on shared infrastructure, Cloud SQL, Data Safe, and Big Data; developer tools such as Application Express (APEX) and SQL Developer; and database security products including Key Vault and Audit Vault/Database Firewall. Finally, Mendelsohn also runs customer support for Oracle Database Cloud Services and Oracle Database on Exadata.

Mendelsohn began his career at Oracle as a developer on Oracle Database 5.1 in 1984. Prior to joining Oracle, he worked at HP and ESVEL.

Mendelsohn holds a BSE in electrical engineering and computer science from Princeton University and did graduate work in computer science at the Massachusetts Institute of Technology.

Datenbank Online-Event: Durch die Dornen zu den Sternen: Migration von Oracle nach Postgres

From: https://register.gotowebinar.com/register/6779806810633354254

Migration wie auch jede Veränderung ist die große Herausforderung. Wenn Unternehmen sich für die Migration von Oracle nach Postgres entscheiden, müssen diese gut vorbereitet sein. Organisatorisch müssen einige Aufgaben erledigt werden: – Neue Betriebskonzepte müssen erstellt werden – Personal soll sich mit der neuen Datenbank vertraut machen. Die Migration soll gut geplant und bestens vorbereitet werden. Als erstes sollen die möglichen Kandidaten für eine Migration nominiert werden. Die Migration der gesamten Oracle Datenbank macht wenig Sinn, da die interne Datenbank-Verwaltungsobjekte nicht migriert werden müssen. Relevant für eine Migration sind Kunden-spezifischen Daten, Anwendungen und User-Objekte. Am besten gruppiert man diese in logischen Einheiten, wie etwa ein Schema oder eine Anwendung und migriert diese nach Postgres. Danach sollen zu migrierenden Datenbank Objekte wie etwa Tabellen, Indexes, Funktionen, Packages und stored Procedures analysiert und angepasst werden. Folgende Herausforderungen sollen dabei bewältigt werden: – Erkennung und Beseitigung von Syntax Unterschieden – Konvertierung von Datentypen von Oracle nach Postgres – Lösung von Kompatibilitätsproblemen Wenn all diese Hürden genommen sind und Datenbank Objekte in der Postgres erstellt sind, kommt eine neue Aufgabe auf uns zu: Daten Migration. In diesem Webinar werden notwendige Schritte erläutert, die notwendig sind, eine Migration von Oracle nach Postgres, einfach und problemlos zu gestalten. Ich gebe einen Überblick über die Werkzeuge, die die Konvertierung von Objekten vereinfachen. Ich erkläre, wie Daten von Oracle nach Postgres unter der Voraussetzung des Minimal-Downtime-Ansatzes migriert werden können. In einer Demo spiele ich eine Migration vor. Dabei löse ich einige Probleme und anschließend migriere Daten.

DOAG DATENBANK ONLINE-EVENT: ORACLE 12C R2 RAC UPDATE NACH 19C – Ein Erfahrungsbericht

From:https://register.gotowebinar.com/register/5336635123429675275

Ein 8-Knoten Extended Distance RAC mit Oracle 12c Rel.2 auf SUSE Linux Enterprise Server 12 war als Nachfolger eines 11g RACs gerade fertig gestellt. Einige Datenbanken waren auch schon auf diesen neuen Cluster migriert. Da gab es auf Grund von Performance Problemen und der Zertifizierung einer Software die Anforderung, den RAC auf Oracle 19c zu aktualisieren. Unmittelbar nachdem das On-Premises Release der Oracle Datenbank Version 19c verfügbar war, wurde dieses Projekt angegangen. Das Patchen und auch Updaten von Oracle Datenbank Software ist in den letzten Jahren doch erheblich unkomplizierter geworden. Insbesondere da die Version 19c innerhalb der 12c Rel.2 Familie ja eigendlich das Sub-Release 12.2.0.3 darstellt sollten dabei doch keine größeren Probleme auftreten. In meinem Vortrag berichte ich vom Ablauf des Updates sowohl der Grid Infrastruktur als auch der Datenbanken von 12c Rel.2 auf 19c. Dabei zeige ich die diversen Hürden auf, die sich bei Schaffen der Installations- und Updatevoraussetzungen aber auch schon bei der Informationsbeschaffung in den Weg gestellt haben. So haben sich die Dokumente und damit die Informationen in My Oracle Support erst langsam entwickelt. Das Betriebssystem SLES 12 musste von SP2 auf SP3 aktualisiert werden. Auch die Oracle 12c Umgebung hat zuvor nach weiteren Patches verlangt. Welche Hürden noch zu nehmen waren und wie das Ziel erreicht wurde, wird im Rahmen des Vortrags erläutert werden.