Tag: Database & Technology

Oracle 12c R2 offers many enhancements in the In-Memory option. Oracle ACE, Anuj Mohan will point out performance-related problems and explain how Oracle 12c R2 In-Memory option can help with these problems. The session will talk about the overall In-Memory option along with the below enhancements Dynamic Sizing of In-Memory area IM support for Active Data Guard Optimize joins performance via Join Groups IM Expressions IM Fast Start.

We look forward to seeing you online at this 2022 Quest Experience Week session!

Learn the latest news and updates directly from the Oracle Database Development Team. In addition to discussing some of the latest developments and product releases, this session will also cover Oracle's database strategy for managing enterprise data in the cloud, on premises, and in multicloud and hybrid cloud configurations.

As you migrate to Oracle DB 19c and the next Long-Term release, learn how many Oracle customers are modernizing their applications and also their IT environment. Consolidating Oracle DB instances on to a modern scale-up/scale-out infrastructure enables better security, higher reliability, better sustainability through more power-efficient processors, all at lower Total Cost of Ownership (TCO). Learn more about how Oracle Database customers can realize all these benefits, update their DB versions, and deploy it on-premises or off-premises, building a hybrid cloud, and complement it with Ansible Automation to reduce error-prone management activities and deploy new instances faster.

The session would be to demonstrate-
1. Oracle Database 23c new feature: JSON Relational Duality
2. Oracle Database 23c new feature: Oracle In-Database Graph

Following on from the Database Roadmap and New Features session, we ran out of time to show demonstrations of the new Database 23c capabilities: JSON Relational Duality and Oracle In-Database Graph. This mini-session is for those people who are interested in seeing the demonstrations, but missed out on Monday’s session.

Oracle Database has so many security features and products but sometimes the very basics are overlooked. Oracle Database 19c, 21c, and the upcoming 23c brings in 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.

In this session learn how easy it is to utilize machine learning to help you optimize IT spend on database, compute, and Exadata resources in on-premises and cloud (hybrid) environments using OCI Operations Insights. Understand how to perform automated detection of current and impending resource utilization issues as well as how to trend and forecast future resource demand globally across large fleets or at an individual database/host level. See how to detect seasonally sensitive demand and identify over- and underutilization.

Join the Oracle ACE team to discuss anything Oracle Database. We will make this session interactive, so come up with a question or topic. A few topics we intend to cover are:
-Changes and new features of Oracle Database 23c for DBAs and developers learned from OCW22. Special focus on performance, security, JSON, PGQ, and SQL benefits.
-Interesting new OCI infrastructure services that impact the Oracle database management
-Oracle in-memory and multi-tenant

New to tuning SQL, or maybe this is your 10th year? In this session we will give a quick intro on SQL and Oracle Optimizer and 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)

In this session, hear how Oracle continues to invest in Enterprise Manager (EM), Oracle’s on-premises hybrid management solution for the Oracle stack, releasing new capabilities and support on a monthly cadence using the agile Release Update (RU) model. EM continues to grow and evolve to address hybrid management needs and the manageability of the environments of tomorrow. Learn how Oracle’s Cloud Infrastructure (OCI) Observability and Management platform provides comprehensive visibility and insights across all layers of the stack—deployed on any technology, anywhere. By unifying all types of operational telemetry (metrics, logs, traces) with curated machine learning–based analysis, enabling you to manage databases and applications easier on-premises, on Oracle Cloud or Multi-cloud environments.
- Understand Oracle's current offerings and plans to provide manageability across hybrid estates leveraging the best of on-premises and cloud technology
- Learn how EM helps you lower the cost and risk of providing high-performance applications and adopting the latest Oracle technology
- Understand how O&M provides a unified view across an entire software stack, provides improved insight for Exadata solutions
- Quickly get up to speed on the O&M services already available and what’s coming
- See how you can start using O&M services to solve business problems in a matter of minutes

Join us for our monthly Cloud Computing SIG meeting!