|
BLUEPRINT 4D Program
New sessions, details and speakers are being added daily, so be sure to check back often to start building your BLUEPRINT 4D experience! |
|
|
Oracle Database Sessions
10 new Oracle Database Tricks for 19c
Presented by: Erik Benner, Mythics LLC
... help both DBAs and Application owners. Tricks like having two passwords on an account at the same time to facilitate password rotations will be covered. Or, if you are a developer how about SQL Macros to encapsulate complex processing logic directly within SQL. Or how about dynamic init parameters based on system resources!See More
Oracle Database,App to All
A MySQL HeatWave Overview for Every Developer
Presented by: Benjamin Wood, Oracle America, Inc
... chine learning, and data lake applications. It eliminates the complexity of ETL operations and existing MySQL applications run without any changes. MySQL HeatWave provides the best price-performance among competing offerings and is offered on multiple clouds.See More
Oracle Database
A Simple Check Helps Reduce Chances of an Old Tool Putting Business at Risk
Presented by: Steve Lemme, Oracle America, Inc
... evaluating them to ensure they would meet business needs. I know, I used to be one of those DBAs requesting budget, then became a tools vendor responding to such inquiries, and today a Product Manager for Observability and Management solutions. But as applications and their infrastructure stack changed, has anyone in the organization validated that the tools procured in the past, meet the latest business, compliance, or regulatory needs?See More
Oracle Database,App to All
Accelerate secure database migrations at scale with minimal downtime using Migration Workbench
Presented by: Harish Niddagatta, Oracle America, Inc
... CS, BM, or VM). Use Enterprise Manager Migration Workbench to evaluate the readiness of database assets to securely migrate, efficient, and agile while reducing the risks of human error. Find out how the performance of SQL statements in migrated databases are validated automatically
Use Oracle Enterprise Manager Migration Workbench to:
- Prepare: Evaluate database migration readiness, dependencies, shapes and pre-requisites
- Migrate: Prepare databases for migration, use appropriate migration methods
- Analyze: Validate results, compare performance and configuration to the source database
If you are migrating databases within a data center or to the cloud, join this session for insight from Oracle experts. This session will include demonstrations and dedicated time to answer your questionsSee More
Oracle Database
APEX Eye for the Forms Guy
Presented by: Monty Latiolais, Insum Solutions
... eds if not thousands of individual forms. Now with expectations higher than ever before, customers are demanding modern web interfaces with increased functionality. Many companies are choosing to modernize the Forms applications with Oracle Application Express (APEX).
In this session we will examine the two popular development platforms. We'll compare the various components of each and explain just how easy it is for a Forms developer to excel with Oracle APEX.See More
Oracle Database
Architecting Oracle on Azure for Success
Presented by: Kellyn Gorman, Microsoft Corporation
... requires significant knowledge of both Oracle and Azure to marry both supported vendor's products. This session builds on attendee's vital database skill to architect solutions to ensure performant multi-tier systems running for long term satisfaction in Azure, no matter if Oracle applications, like EBS, JDE, Hyperion or Peoplesoft, and taking advantage of the right services and infrastructure in Azure for workloads that may have even run previously on Exadata. Learn how to properly right-size for license savings, architect for performance and automate for ease of management in the cloud.See More
Oracle Database
Architecting Oracle Workloads from on-premises to VMware Multi Clouds
Presented by: Sudhir Balasubramanian, VMware
... res simplifying, standardizing and automating the deployment and configuration along with providing HA and DR to these critical applications to meet the above business objectives.
VMware Multi Cloud solutions which also includes VMware Cloud on AWS, Oracle Cloud VMware Solutions, AVS, GVE etc provides consistent and interoperable infrastructure and services between VMware-based datacenters and the Public cloud, which minimizes the complexity and associated risks of managing diverse environments.
Join this session to learn more on the methodology of migrating Oracle workloads to VMware Multi Clouds with all best practices.See More
Oracle Database
ASH Incident Analysis With Interactive Network Graph
Presented by: Craig Shallahamer, OraPub, Inc.
... o resolve. In such cases, an AWR report may not be helpful. Instead, using raw Active Session History (ASH) data can be an effective approach. ASH provides detailed information about database session activity, including SQL statements, resource consumption, and wait events. In this presentation, I will explain why ASH is so useful, how it works, and how we can use ASH to solve complex performance issues. With the help of four free scripts, I will guide you through a step-by-step process for analyzing performance incidents using ASH and demonstrate how to visualize the incident using an interactive network graph.See More
Oracle Database
Automate upgrade to Database 19c, manage patch operations at Scale for efficiency, and security
Presented by: Harish Niddagatta, Oracle America, Inc
... to be revisited to complete this journey, proactively patch to secure, and for day-to-day operations
In this session, learn about powerful solutions in Enterprise Manager to easily upgrade to 19c non-container to non-container or to multitenant databases via automation and intelligent user interface, at scale. Post upgrade, leverage security patch recommendations, automate recurring patching with minimal downtime to secure, and be compliant with security standards
You will gain practical knowledge of managing databases in on-premises and hybrid cloud environment
- Consolidate database assets for ease of management
- Manage database configuration drifts to improve security and performance
- Automate database lifecycle management at scale to reduce administrator efforts
- Secure databases, hosts and infrastructure, and be compliant with your policies
Are you a Security Administrator, System Administrator or Database Administrator? This session is for you, learn best practices to enable standardized deployment of 19c databases on-demandSee More
Oracle Database
Automate vulnerability detection, patch and compliance management of your application infrastructure
Presented by: Harish Niddagatta, Oracle America, Inc
... ure your applications infrastructure is secure, have all vulnerabilities patched, and compliant with security policies?
Proactively detecting vulnerabilities, and patch the affected assets to ensure compliance with security policies are operational challenges that consumes lot of time across cross-functional teams from Application to database and infrastructure administrators
In this session, learn best practices to secure database and infrastructure assets while eliminating manual effort for patching, and compliance using pre-built automation to address critical security vulnerabilities, minimize operational expenditure, and reduce maintenance window
During this session, you will learn how to:
- Use automation to stay current with software updates for your database fleet
- Proactively patch and upgrade database environments to address critical security vulnerabilities
- Identify vulnerable assets, prioritize vulnerability regression, and remediation management
- Achieve CIS, STIG industry or regulatory compliance and security business objectives for your assets
Are you a Security Administrator or Database Administrator or Exadata System Administrator? This session is for you, learn best practices to protect data and be compliant with enterprise policies.See More
Oracle Database
Automating your environment with OEM
Presented by: Erik Benner, Mythics LLC
... Dynamic runbooks to deal with the simple tasks, and then moving into using OEM as a DevSecOps tool to automate about everything, from Database provisioning, patching and operational automation. This session is full of live demos and Q&A, so bring your best questions!See More
Oracle Database,App to All
Build And Deploy An OML4SQL AI To Predict Rain
Presented by: Craig Shallahamer, OraPub, Inc.
... ine learning model that can accurately predict rain six hours into the future! Our process will involve collecting and processing time series data, including various weather variables, and using neural network algorithms to model the relationship between these variables and the likelihood of precipitation. To ensure the accuracy of our model and provide a fascinating demonstration, we will use a time-series stepping evaluation process combined with a confusion matrix. With the help of Oracle's Autonomous Database and OML4SQL, we will be able to efficiently manage and process our datasets and deploy our model in a production environment. Come join us as we harness the power of data and machine learning to bring a new level of convenience and accuracy to weather forecasting!See More
Oracle Database,App to All
CLOBs and BLOBs in the Semi-structured World of JSON and XML
Presented by: Michael Rosenblum, Dulcian Inc
... he database is no longer only a place to store dollars and cents for the purposes of accounting. Efficient manipulation of XML and JSON has become one of the most critical elements of contemporary database infrastructure – and in the majority of cases XML or JSON internally are implemented as LOBs. However, few people in the development community really understand the underlying mechanics of Oracle LOB datatypes and consider it yet another DBA issue. This presentation attempts to fill that knowledge gap.See More
Oracle Database
Cloud Computing SIG Meeting
Presented by: Erik Benner, Mythics LLC
... ds move to the cloud? In this Cloud SIG Session, Erik Benner and the Cloud SIG will discuss what are your career options as you move workloads to the cloud. This session is for all admins, Database Admins, Operating System Admins, Application Admins etc. We will discuss what the cloud means to your career, things you can do to keep current with the needs of the cloud and the tools and technologies that you need to be thinking about. If you want a new career as a peanut farmer...this session is NOT for you.See More
Oracle Database,App to All
Cloud Migration -- Oracle on AWS/OCI/Azure
Presented by: Valli Ramanathan, Freddie Mac
... ow for successfully migrating oracle from on-prem to the cloud ( OCI/AWS/AZURE) Presentation will illustrate the tasks to follow while planning a migration of an Oracle database to the cloud. Based on each provider there are differences in what can and can not be done. What are the Do's and Don’t based on the cloud provider to ensure the migration is successful? How do we ensure we have a cloud-based database that is performing at its optimal irrespective of the provider? Once migrated how do we ensure efficient performance
Presentation will illustrate all the above and give pointers on important tasks to help DBAs plan and implement cloud migration successfully.
With the current trend being "Cloud migrations"-- understanding the steps and details of planning and designing a successful is very highly sought after . Oracle cloud migration to OCI, AWS & Azure will be a feather in any DBAs cap. My presentation details all the know how and will be beneficial to all technical folks.
Learning Objectives:
1. Details on requirements to be gathered, technical steps to be planned and analyzed – all of these are useful and beneficial to the audience
2. Differences between the cloud providers –nuances to pay attention to help implement Oracle database migration successfully on OCI/AWS & AZURE
3. Common issues, shortcomings that need attention so as to avoid pitfalls.
See More
Oracle Database
Complete and Simple Data Management
Presented by: Sean Stacey, Oracle America, Inc
... ng the most of the information your business generates? Could you make better business decisions if you had the time and the correct tools? Sound familiar?
Come and find out how you can start solving these problems today with Oracle.See More
Oracle Database
Data as Code: Exploring Data and Database Portability
Presented by: Sean Scott, Viscosity North America
... d coordination across teams. Legacy environments must balance the risk of stale data against the time, effort, and inconvenience of reverting databases to baselines. Even modern agile shops struggle with this task, engineering complex processes or investing in complex solutions for data management. The primary obstacle? The way traditional databases merge software, configuration, and data, creating a bottleneck around niche skills unique to database administrators.
Organizations eliminate that dependency by shifting to a container model and delivering Data as Code. Containers separate database software from its data. Decoupling data eliminates the need for specialized skills, making it another artifact in the development lifecycle. Individuals and teams can create and refresh data on-demand, version it alongside application code, and distribute it as code or objects. Data as Code reduces uncertainty introduced by data drift and allows organizations to experience greater development velocity, consistent and reliable testing, and improved application quality!See More
Oracle Database,App to All
Data Integration with Oracle GoldenGate
Presented by: Alexandre Lima, Oracle America, Inc
... l look at the free migration utility, discuss so advantages of the Microservices Architecture and advanced features, as well as give an in-depth explanation of different ways to run Oracle GoldenGate in high availability mode, including a hub or as a mesh architecture. We’ll also briefly discuss what we are working on for 23c and features in the roadmap.See More
Oracle Database
Database 12c to 21c, Journey of key feature sets
Presented by: Anuj Mohan, Big River Steel
... ry and Oracle 19c Automatic Indexing and many more. I will discuss the 12c to 21c Journey for these new features with examples and sample code. Attendees can expect brief introduction of all the new features with deep dive into Multitenant, IN-Memory and Automatic IndexingSee More
Oracle Database
Designing your high availability and disaster recovery architectures on OCI
Presented by: Biju Thomas, Data Intensity
... ed on the database service - Oracle on IaaS, DBCS or Database System, Oracle Exa Cloud Service, Autonomous Database, and Cloud at Customer. RAC and Data Guard are the most common HA/DR solutions. You can also use Golden Gate and other data replication tools. For application services, you can use native cloud replication options or rsync. Orchestrate your DR configuration, validation, testing, failover, and switchover using Full Stack Disaster Recovery.See More
Cloud Summit: Move to Cloud,Oracle Database
Eliminating database I/O latency with Oracle New Persistent Memory Features
Presented by: Kai Yu, Dell Technologies
... nd the Oracle Memory Speed File system(OMS) introduced Oracle Database 21c and 19c respectively provide the support for Persistent Memory (PMEM) as database storage and significantly reduce database I/O Latency. By mapping database buffer cache directly onto Persistent Memory storage, Persistent Memory Database directly uses data residing in the Persistent Memory storage and eliminates the latency of copying data into the database buffer cache. This session discusses these two features in detail and how we leverage them to achieve the extremely low latency and high throughputs in a high performance database system. This session provides the step by step how-to details of implementing these two Persistent Memory database features, also provides the use cases & performance benefit studies of leveraging these Two features in a high performance database system. We will have some discussions on the Intel latest announcement on Persistent Memory technology and the related future development direction.See More
Oracle Database
Everything you need to know when you are moving your Oracle Databases
Presented by: Alex Zaballa, Accenture Enkitec Group
... out migration from Oracle Databases, including examples, free tools, and techniques for easy migration.See More
Oracle Database
Find Data Connections with Oracle Graph
Presented by: Melliyal Annamalai, Oracle America, Inc
... and more. With Oracle Graph you can model your relational tables as a set of connected entities to view your data as a graph, to uncover new insights based on the connections in data. Graph Studio in Autonomous Database makes it easy to create, query, analyze, and visualize graphs. We will show examples of using these powerful features to detect anomalous patterns in a financial transactions dataset in the database. We will demonstrate the use of an automated graph modeling tool to create a graph from data in relational tables, use a SQL-like graph query language to query the graph, and use pre-built graph algorithms to explore and analyze the data in new ways.See More
Oracle Database
Happy Hour with the Oracle Database product teams and Oracle ACEs
Presented by: Quest Oracle Community, Quest Oracle Community
... See More
Oracle Database
Hardening your Oracle Database Security: Getting some Quick Fixes Covered
Presented by: Simon Pane, The Pythian Group
... and the upcoming 23c brings even more security features and options.
In almost all deployments there are opportunities for immediate security improvements, or hardening, without requiring additional products or options. This presentation covers some key quick wins (and security tricks) that DBAs can implement immediately to increase their overall Oracle Database security posture and reduce exposures. Applicable to almost all versions and editions.See More
Oracle Database
Histograms (In Oracle Database 11g to Oracle Database 21c) Could Be Your Friend
Presented by: Anuj Mohan, Big River Steel
... s include frequency histograms and height-balanced histograms. Topics covered for Oracle Database 12c Histograms include challenges with Oracle Database 11g histograms, top frequency histograms, and hybrid histograms. The session also covers Oracle Database 18c/19c/21c histogramsSee More
Oracle Database
How Ansible Can Save Your Time When Upgrading Databases
Presented by: Marcus Vinicius Miguel Pedro, Accenture Enkitec Group
... tra costs with Oracle Support.
Upgrading a database sometimes is a nightmare for DBAs. In order to upgrade more than one database in the same maintenance window, you may need more than one DBA.
How about running some Ansible Playbooks to upgrade dozens of databases at same time? How about enabling TDE tablespace encryption during this maintenance window too?
In this Ignite session, I'll summarize what he achieved using Ansible Playbooks when Upgrading Databases.See More
Oracle Database
How Oracle Advanced Security features helping us to mitigate risk and be compliant
Presented by: Omar Faruq, Therap Services, LLC
... nd safeguard databases by implementing various Oracle Security products and features. We implemented Transparent data encryption (TDE), Backup Encryption, Database Vault, Audit Vault, GoldenGate Encryption, Data Masking and several other security best practices. In this session, the attendees will have a revision of all available Oracle Advanced Security features and will get a brief idea what it takes to implement those.See More
Oracle Database
How to be a Superhero (Using the Oracle Cloud Free Tier)
Presented by: Alfredo Abate, BBB Industries
... available with these free cloud services including virtual machines, storage, autonomous databases, APEX, and the ability to use machine learning. We'll explore how these free services work and what can be done with them, how you can learn some modern tech skills, and use them to create proof of concept systems.
Objective 1: Review the Oracle Always Free Tier of cloud services.
Objective 2: Overview of Oracle APEX and Machine Learning in the Free Tier.
Objective 3: Demonstrate how you can combine these tools, to create fast proof of concept systems.See More
Oracle Database
Hybrid cloud network, how do you get there?
Presented by: Gary Gordhamer, Viscosity North America
... he items you need to design, migrate, connect, and finally securing your cloud network. We will start with some networking basics and map them to the cloud terminology in OCI. To secure your network requires multiple levels of configuration around subnet layout, routing, and security lists. Connecting between two systems can seem as hard as connecting across countries, so troubleshooting tools are critical. Finishing up with a few examples of configurations that can be used.See More
Cloud Summit: Move to Cloud,Oracle Database
Increase Oracle Database security by removing passwords - is it possible?
Presented by: Simon Pane, The Pythian Group
... swords from the Oracle database? Are there more secure alternatives?
Well, there are a number of extremely low-risk easy changes and various other things we can do to remove passwords. Let’s discuss password weaknesses and some alternatives for authentication. And categorize, group and rank each suggestion based on implementation risk and complexity.See More
Oracle Database
Inferring SQL Run Times And Analysis Using Raw ASH Data
Presented by: Craig Shallahamer, OraPub, Inc.
... ntation is for you. By analyzing raw ASH data, you can learn how to infer the runtime of your SQL queries and gain valuable insights into their performance.
For example, let's say you receive a support ticket stating that a particular query takes 45 seconds to run. How can you confirm this? Is 45 seconds an unusual runtime for this query? Has this happened before? Is there a bad execution plan being used? What would be a good execution plan for this query? And where in your application does this SQL reside? All of these questions can be answered by creatively analyzing ASH data.
In this presentation, I will demonstrate how to manually infer SQL run times using ASH data, as well as how to use a simple yet flexible SQL script to analyze ASH data and report the results at the execution plan level. I will also show you how to use Python to analyze runtime samples.
Join me as we explore the untapped potential of ASH data analysis and learn how to get the most out of our SQL queries.See More
Oracle Database,App to All
Leveraging Machine Learning in Oracle
Presented by: Rich Niemiec, Viscosity North America
... ay be the first to truly learn Machine Learning (ML) and expand into Artificial Intelligence (AI). Python is one of the keys to Machine Learning as we program the invention of Man's Mind to further replace man's most basic tasks. This session will focus on ML 101 and building the future ahead. Some business issues are seasonal, some relate to customers with certain attributes, some relate to customers we don't know exist, but all can be solved by using the correct algorithm to quickly prescribe a better corporate future.See More
Oracle Database,App to All
Maximize your Oracle Database Performance and Availability on Hyperscale Cloud IaaS (OCI, Azure, AWS)
Presented by: Biju Thomas, Data Intensity
... premises or a private cloud. AWS, OCI, and Azure have differences in how the IaaS components work. This session will help you to configure the Oracle database for the best performance by choosing the correct virtual machine shape, disk configurations, database parameters, backups, and high availability disaster recovery options. Learn how to estimate each Cloud's computing, memory, and disk requirements. Understand the tools to compare on-premises database performance with Cloud.See More
Oracle Database
Modern application infrastructure risk assessment, compliance, and audit for CIS, STIG, HIPAA, PCI-DSS
Presented by: Harish Niddagatta, Oracle America, Inc
... nges, ensure principles of least privilege and compliance with security policies?
In this session, learn how to continuously monitor for undesired configuration changes, assess, manage, auto-remediate and maintain compliance of your underlying databases and linux infrastructure at scale for industry and regulatory standards such as CIS, STIG, HIPAA, PCI-DSS and numerous other host standards including custom security policies. Review compliance reports for auditing various access controls to ensure increased security posture
We will review best practices that companies have adopted to stay in compliance with their security policies while reducing their costs and virtually eliminating audit risks. Find out how to manage automated platform infrastructure compliance successfully so that you can focus on your business strategies and developing new applicationsSee More
Oracle Database
Monitor JD Edwards or Peoplesoft using Oracle Cloud Infrastructure Application Performance Monitoring
Presented by: Avi Huber, Oracle America, Inc
... need to be monitored and it’s best to do it using a single solution. Oracle Cloud Infrastructure (OCI) Application Performance Monitoring (APM) provides the ability to monitor the application stack, perform synthetic and End User Monitoring and enable tracing to help diagnose performance issues faster and deliver a consistent level of service. APM enables monitoring of multiple components and application logic spread across clients, third-party services, and back-end computing tiers, on-premises or on the cloud.See More
Oracle Database,App to All
Multitenant 12.1 to Multitenant 21c: Technical Deep Dive
Presented by: Anuj Mohan, Big River Steel
... premises databases. Topics covered include container database (CDB)/pluggable database (PDB) concepts, PDB value, shared/exclusive components, and accessing CDBs/PDBs. The session briefly covers migration options to 12c/21c from previous versions and then delves into Oracle Database 12c R2/21c features including PDB relocate, lockdown profiles, system global area/program global area for PDB, memory I/O resource prioritization, snapshot carousel, dynamic lockdown profiles, CDB fleet management, and new features in Oracle Database 21c if time permits.See More
Oracle Database
OCI Database Management Service or Enterprise Manager: Which is better?
Presented by: Steve Lemme, Oracle America, Inc
... oice. Enterprise Manager is our flagship on-premises management product for databases and Engineered Systems that 10s of 1000s of customers rely on every day. OCI Database Management is a cloud-native on-demand managed cloud service that provides single a management view for Oracle Databases on-premises, in the cloud, and in multicloud environments enabling users with real-time performance diagnostics and administration capabilities. Presented by the subject matter experts, get your questions answered and learn which is the better solution for your needs.See More
Oracle Database
Oracle Autonomous Database and the Data Lake
Presented by: Maqsood Alam, Oracle America, Inc
... ics, including: machine learning, graph, spatial, JSON, and more. This open access allows any SQL based business intelligence tool or application to benefit by using data stored in multiple places without needing to understand the complexities of the data lake. In this session you will learn how to easily combine insights from the Data Lake and the Data Warehouse using the Oracle Cloud.See More
Oracle Database
Oracle Based Applications Moving to Cloud Server’s Expert Panel
Presented by: Biju Thomas, Data Intensity
... pany is looking at moving on-premises PeopleSoft or JD Edwards to cloud based infrastructure. This panel will include multiple experts that have moved many Oracle based workloads to multiple cloud based infrastructure providers (OCI, AZURE, AWS, GCI). Bring your questions and let’s have an interactive discussion. Ask about such topics as security, technical steps, costs, gotchas, performance, patching, or availability.See More
Cloud Summit: Move to Cloud,Oracle Database
Oracle Database 19c SIG
Presented by: Anuj Mohan, Big River Steel
... ick-off the call with an introduction of the Database 19c SIG. I will give a high-level introduction of 19c new features and take any questions you have. I will discuss plans for 2023. At the end, I will open the call to get your inputs and understand key topics you want to know more.See More
Oracle Database
Oracle Database as a JSON Document Store
Presented by: Sean Stacey, Oracle America, Inc
... everything you need to meet all your JSON requirements, including a highly optimized native datatype. Tasks like mapping JSON Collections and Documents to Relational tables and objects is handled automatically for you. Best of all, it's completely free!
The session will cover how Oracle simplifies loading, storing, retrieving, and managing JSON data when using the Oracle Database. You will even hear about what's coming in Oracle Database 23c for JSON. See More
Oracle Database
Oracle Database Innovations Expert Panel
Presented by: Gary Gordhamer, Viscosity North America
... the corner, maybe you are curious about something that came out in 12c or even 11g. This panel will be full of experts that can provide real world experiences and results on your questions around all the database features. Topics including security, performance, reliability, scalability, data replication, and even new SQL language features. Come with your questions, get real world resultsSee More
Oracle Database
Oracle Database: What’s New, What’s Next
Presented by: Sean Stacey, Oracle America, Inc
... elease. The session will be covering the latest features in the Oracle Database and will also provide an update on what to expect from the next release of the database.See More
Oracle Database
Oracle In-database Machine Learning with OML4SQL and OML4Py
Presented by: Kai Yu, Dell Technologies
... bring great business value. Oracle In-Database machine learning moves the algorithms to database where the data is stored. In this session, we will discuss how Oracle In-database machine learning is provided in Oracle Database including Oracle Autonomous Database with scalability, simplicity and high performance. We will discuss how to build, evaluate and deploys machine learning models natively with large enterprise data using Oracle Machine Learning for SQL(OML4SQL) and Oracle Machine Learning for Python (OML4Py). This session will take some use cases as examples to show the process of machine learning: analyze and prepare data set; build and evaluate and apply machine learning model with Oracle Autonomous Databases environment. We will discuss one of important features introduced in Oracle 21c/23c: Automated Machine Learning (AutoML) including the AutoML UI as well as the AutoML in OML4PYSee More
Oracle Database
Oracle Maximum Availability Architecture (MAA) SIG
Presented by: Alfredo Abate, BBB Industries
... 2023! Formerly the RAC SIG, and now included as part of the MAA SIG, we will provide an overview of the MAA SIG's goals and objectives including meeting of the new board, upcoming webinars. Finally, we will have a Q&A, so come and share with us your questions that you might have around Oracle MAA.
Learning Objective 1: Review the Oracle MAA SIG goals and objectives.
Learning Objective 2: Learn about the new generation Oracle MAA.
Learning Objective 3: Q&A related to all things Oracle MAA.See More
Oracle Database
Oracle SQL Plan Management (SPM) your imperative performance tool
Presented by: Gary Gordhamer, Viscosity North America
... d with each new release. As of 19c this should be your goto method to help maintain well performing SQL statements.
In this session we will cover what SPM is, how to use SPM from end to end, and how to monitor it. Once you start using SPM Baselines you will find them to an invaluable tool in your continuous goal to maintain database performance.
See More
Oracle Database
Oracle Tuning Tips, My best developer tuning tips
Presented by: Gary Gordhamer, Viscosity North America
... nd then provide some specific examples and tips for multiple SQL tuning options and methods. The goal is for this session to be approachable by all levels of skill and provide some quick take aways without going too deep into any one area. Example code will be provided, with some demonstrations.
Learning goals include: What is SQL tuning; What tools should I use; Explain Plan Lies; Statistics + Histograms = +1; Tuning Advisor + AWR top N SQL = +1; Why do SQL Profiles fail; Create a SQL Baseline from cursor cache; How to make a SQL Patch; Playing with Optimizer; Why is my index not being used? (Index clustering)
See More
Oracle Database
Overview and Introduction of Oracle Cloud – Why would I go there?
Presented by: Janis Griffin, Quest Software
... Metal Cloud Services. It was rebranded Oracle Cloud Infrastructure (OCI) in 2018 and is now touted as a “Generation 2 Cloud”. This presentation will explore all the various offerings of Oracle Cloud, their advantages, and disadvantages. I’ll discuss considerations that you should think about when moving to the cloud. Then, I’ll show how you can use Oracle Cloud Free Tier to access several, “Always Free” services for development, small business initiatives or just experimenting with new versions of Oracle DBs.See More
Oracle Database
Performance Tuning Aspects of DML Triggers
Presented by: Michael Rosenblum, Dulcian Inc
... resentation, various kinds of triggers will be examined from a global system optimization point of view that includes not only the aspect of functional correctness, but also the tradeoffs between multiple goals. For example, depending upon the available hardware, developers can select either CPU-intensive or I/O-intensive solutions. This presentation will focus on the most common performance problems related to different kinds of DML triggers and the proper ways of resolving them.See More
Oracle Database
Performance Tuning Using the Advisor Framework
Presented by: Roger Cornejo, Accenture Enkitec Group
... e tuning actions more quickly by aggregating findings and recommendations across multiple Advisor runs. The author details his custom tools (simple SQL statements) that expose many undocumented features of the Advisor framework. In the DBA or developer’s hands, these tools can massively scale-up your ability to action tuning opportunities exposed by the various Advisors. The excellent findings and recommendations that come out of the various Advisors such as the SQL Tuning Advisor, the Automated Database Diagnostics Monitor (ADDM), the Segment Tuning Advisor, and the SQL Access Advisor will be of particular focus in this presentation.See More
Oracle Database
Preparing for Oracle 23c
Presented by: Rich Niemiec, Viscosity North America
... arning Enhancements & more to prepare for in 23c. Many features covered will be related to the DBA, but there are also some that focus on the developer. Also, some 19c new features (automatic indexing, Quarantine, JSON data, Three user-created PDBs, Read-mostly Standby, and Autonomous Databases) that should be investigated for use. This presentation will also have a few 21c new features such as AutoML, Standby Result Cache, and InMemory enhancements including Base Level. There will be simple examples, where possible, to show the basic functionality of the new features. in. We will also look at the autonomous database and Oracle’s focus on the future of security.See More
Oracle Database,App to All
Stump an ACE! Bring your best questions to this interactive panel.
Presented by: Erik Benner, Mythics LLC
... available to answer your questions. The panel will be the top ACE Directors and ACE Pros attending the conference, picked to make sure SaaS, Application, Database and OCI are all covered.See More
Oracle Database,App to All
Take advantage of Oracle’s Automatic Indexing Feature even if you don’t have an Oracle engineered system!
Presented by: Janis Griffin, Quest Software
... e need for indexes, create, test, and drop them automatically – without DBA intervention. This presentation will discuss all the components of automatic indexing and what they do. The attendee will further learn how to enable/disable automatic indexing, control it at the schema-level, and see several examples of automatic indexes in action. Finally, I’ll show how this feature can be used during the development lifecycle through the maturity of a database application - even without having an Oracle engineered system.See More
Oracle Database
Terraform on Oracle Cloud: A Primer for DBAs
Presented by: Sean Scott, Viscosity North America
... availability, and patching. But, navigating a cloud interface to create hosts, assign disks, and configure networking is tedious and time-consuming. And you still have to install software and prepare the environment!
Enter Terraform, an automation tool that streamlines and simplifies infrastructure builds. In this session, database administrators learn the basics of provisioning a database and supporting infrastructure on Oracle Cloud with Terraform. No prior experience with Terraform or Oracle Cloud is required!See More
Oracle Database
Texas A&M University System from Exadata Cloud at Customer, OCI and beyond: An Unexpected Journey
Presented by: Donovan Sherriffs, Texas A&M University
... Cloud Machine), present (Oracle Cloud Infrastructure and Gen 2 Exadata Cloud Service), and future. We will be covering the journey, lessons learned, and tools that helped along the way.See More
Cloud Summit: Move to Cloud,Oracle Database
The ABCs of APEX Administration - For Oracle DBAs
Presented by: Simon Pane, The Pythian Group
... the latter.
This presentation covers all aspects of APEX Administration from an Oracle DBA perspective. Explaining the fundamental concepts, how to install, how to manage, how to backup, and much more.
This presentation is NOT about developing apps. It's about what else DBAs need to know to properly understand and support Oracle databases running APEX and how to handle typical developer support requests.See More
Oracle Database
The DBA's Next Great Job
Presented by: Rich Niemiec, Viscosity North America
... e DBA role (managing more databases with autonomous database) & the integration of AI and Machine Learning. Technology is advancing at an exponential rate. This session will show what this means to your company and your future job. See major advances being driven, but also those that will be driven by the autonomous future Oracle is driving ahead.
See More
Oracle Database
The Tuning Process Using AWR and Custom Tools
Presented by: Roger Cornejo, Accenture Enkitec Group
... kit. Once you learn where to look in the AWR tables and realize how easy it is to query the AWR tables and find the exact bottleneck, you’ll not turn back. This presentation details the author’s custom tools and approach to solving application performance issues. Several case studies are highlighted to illustrate how the approach and tools are used.See More
Oracle Database
To the Release Update and Beyond: Everything You Didn't Know About Patching
Presented by: Sean Scott, Viscosity North America
... ches (MRP). Many DBAs aren't aware that RU and MRP are not comprehensive and that databases remain exposed to critical vulnerabilities and regressions without supplemental patching.
In this session, you'll learn to identify the types of patches that are never included in Oracle's patch bundles, how to search My Oracle Support for additional, critical fixes, and cover Oracle's recommended best practices for patching database and Grid Infrastructure software installations. We'll also describe the patching process, how to revert a patched database, and discuss steps for preparing and protecting systems for patching.See More
Oracle Database
Upgrade Your Database Like a Pro With AutoUpgrade
Presented by: Sean Scott, Viscosity North America
... ely, the technical skills and procedures developed for earlier database versions are no longer supported. New requirements and features introduced in Oracle Database versions 19c and 23c completely change your upgrade workflows! There’s so much to consider that it’s easy to feel intimidated, even overwhelmed!
AutoUpgrade mitigates the risks and fears database administrators face. It offers unparalleled simplicity and control over all phases of the upgrade process, covering every imaginable upgrade and migration scenario. AutoUpgrade’s built-in error detection, correction, and self-healing capabilities protect the database at every step, offering peace of mind in any environment—including those running RAC, Data Guard, GoldenGate, encryption, and legacy and multi-tenant architectures.
In this session, I share practical advice based on my experience upgrading dozens of production databases with AutoUpgrade and working with Oracle’s AutoUpgrade team, including:
* Insights for planning and preparing for upgrades
* Demonstrations of essential features and capabilities
* Recommendations for configuring and running AutoUpgrade
* How to leverage AutoUpgrade for added visibility and trustSee More
Oracle Database
What's new with OEM 13.5
Presented by: Erik Benner, Mythics LLC
... this session , learn what is new in OEM, and how it can be used to monitor your cloud and on premise databases and systems. Learn about key technologies that allows OEM to heal broken system automatically!
Got your Release 5 RUs installed yet? Not sure what's a RU? Learn how OEM has moved to CI/CD for feature delivery, and how new features are available almost every month! Erik Benner will review these updates, highlighting major new features, as well as provide his insight to the future of OEM.See More
Oracle Database,App to All
You Can Bet on APEX!
Presented by: Monty Latiolais, Insum Solutions
... r fun, of course). This session is technical in nature and involves the code needed to construct these REST calls, JSON parsing of the results, and the scheduling of these REST calls. We will end the session by building a compelling application around these APIs that your users will love. Gambling problems? Call 800-522-4700.See More
Oracle Database
|
|
|
|