An event dedicated to Database enthusiasts, full of sessions, workshops, and hands-on labs in English, Chinese, Japanese and Korean languages.



APACOUC (APAC Oracle Users Groups Community) was formed to unify and support all Oracle Users Groups and Java User Groups in the Asia Pacific region as one, with the main goal of promoting knowledge exchange and helping the growth of all the communities within the Asia Pacific. 

Our main mission is to help all Oracle User Groups and Java User Groups communities in the APAC region to increase their membership numbers, content and potentiate knowledge exchange in the region. For the past 12 years, APACOUC has organized the Oracle Groundbreakers APAC and Webinar Tours that brought Oracle Celebrities to many countries, such as Australia, New Zealand, Japan, South Korea, China Mainland, and Singapore.

An event dedicated to Cloud enthusiasts, full of sessions, workshops, and hands-on labs in English, Chinese, Japanese and Korean languages.



APACOUC (APAC Oracle Users Groups Community) was formed to unify and support all Oracle Users Groups and Java User Groups in the Asia Pacific region as one, with the main goal of promoting knowledge exchange and helping the growth of all the communities within the Asia Pacific. 

Our main mission is to help all Oracle User Groups and Java User Groups communities in the APAC region to increase their membership numbers, content and potentiate knowledge exchange in the region. For the past 12 years, APACOUC has organized the Oracle Groundbreakers APAC and Webinar Tours that brought Oracle Celebrities to many countries, such as Australia, New Zealand, Japan, South Korea, China Mainland, and Singapore.

APAC Database Days 2022

United States of America

Databases have always been a hurdle  in application development. Data refreshes are time consuming and require down time and coordination. Legacy environments balance the risk of working with stale data against the effort and inconvenience of returning the database to a baseline. Even modern agile shops struggle with this task, engineering complex processes or buying hardware and software solutions to manage their test data. The difficulty lies in the way databases, configurations, and data blend together. Traditionally, navigating that complexity is left to the database administrator.

Docker changes that and holds the potential to revolutionize database development. With Docker, it's no longer necessary to master database internals and commands to create, manage, or refresh databases. In this session I'll show you how to use Docker to:
• Create data artifacts
• Start new databases in seconds using saved baselines
• Save, version, and distribute data sets in your organization
• Integrate databases as full members of existing CI/CD pipelines
• Test with confidence and avoid uncertainty introduced by data drift
• Speed application development and reduce time spent provisioning database assets
...and all without a single database command!

Data and Database Portability in Docker

If you've created a technical service request with Oracle Support in the past few years, you've probably encountered a detour in the SR workflow that asks for diagnostic output from Autonomous Health Framework (AHF), AKA Trace File Analyzer (TFA). Perhaps you discovered MOS automation sometimes won't even assign an analyst until you submit—literally and figuratively—to this demand. It may feel like an annoying obstacle but sharing AHF's diagnostic files leads to faster, better support outcomes. And while recounting awful support experiences is fun, getting database problems fixed (and fixed sooner) is funner—making AHF diagnostic dumps a tool you want in your pocket!

If that's all you use it for, you're carrying the Swiss Army knife of database tools for its toothpick. Occasional problems lodge themselves in the database and AHF helps pry them out. Useful, sure, but not its most impressive capability! Do you know what else is folded into AHF?
* Tweezers: Display parameter settings of all databases in a cluster.
* Magnifier: List, view, and search database and cluster logs on a system.
* Scissors: Generate database, ASM, and Grid Infrastructure event summaries.
* Saw: Protect sensitive data and environment information in logs and directories.
* Corkscrew: Report the size of database and Grid Infrastructure files and directories, track space use over time, and purge files.
* Can Opener: Show recent configuration changes in the database, operating system, network, and storage to pinpoint problems and accelerate resolution.
* Bottle Opener: Run and schedule compliance, performance, and monitoring utilities.
* Standard Screwdriver: Manage user and group access to AHF features, log files, and directories.
* Phillips Screwdriver: Create service requests and upload diagnostic files to MOS or other services directly from database hosts.
* Small Blade: Perform central, RAC-aware management across all Automatic Diagnostic Repository (ADR) homes.
* Large Blade: Produce detailed reports for nearly 200 different incidents, events, and technologies covering 60+ ORA- and TNS- errors and dozens of products, options, and features.

I'll help you get more from AHF by teaching three things:
* Safety: Advice for setup and configuration, how and where to get help, and tips for avoiding frustration
* Technique: How to use AHF to manage, monitor, and maintain database infrastructure
* Maintenance and Sharpening: Install, patch, and customize AHF


Autonomous Health Framework: Use Your Database's Swiss Army Knife (Without Poking an Eye Out)

India

I will tell about the architecture of data guard and data guard journey from 11g to 21c

Data Guard Deep Dive

I will  tell about the architecture of golden gate and journey from 11g to 21c 

Golden Gate Deep Dive

This session walks through the deployment of Oracle Enterprise Manager 13.5 on Oracle OCI marketplace with different pre crafted configurations.

It supports Single and multi-node deployments as per the size and number of targets that are going to be managed.

The Marketplace stack contains pre-configured Oracle Enterprise Manager with co-located Oracle database for single node configuration and OCI 2-node RAC DB system for Multi-node configuration as Oracle Management Repository (OMR). The time to complete this setup is approximately 20 minutes for Single node and approximately 3 hours for a Multi-Node deployment. By this approach, it reduces the pain points of hardware setup, pre-requisite planning and installation, DB/EM Parameters tuning

The demo focuses on - EM Provisioning via OCI marketplace along with the Database discovery (OMR)

Quick deploy Enterprise Manager on OCI Marketplace

Australia

Why and how to manage Oracle Database Clones on Exadata using Exadata Sparse Clones and ACFS Snapshots for space-efficient non-production usecases

Database Cloning on Exadata - Exadata Sparse Clones and ACFS Snapshots 

The exponential increase of data volumes puts enterprise IT infrastructures under pressure in cost, performance, scalability, and manageability. The regulatory requirements are changing, like how and why data are retained. Many organizations are now required to maintain and control more information for a more extended period. Information Lifecycle Management (ILM) is applying policies for the effective management of information throughout its useful life. Oracle's Advanced Compression and Data Partitioning help organizations to deploy ILM policy. The benefits include improving enterprise application's performance, reducing infrastructure cost, providing governance, risk, and compliance framework for enterprise data.

In this session I will cover in-depth of advance compression and database performance benefits. I will also discuss Automatic Data Optimization and Heat Map to define policies, move data to different storage tires with Live Demo.

Information Life Cycle Management : Manage Exponential Data Growth (Live Demo)

Germany

Nowadays, companies have a lot of databases to store their data. Besides the application-specific data, master data is required (e.g. customer or employee information) to run the application. If the data is replicated between many databases, it is essential that the data and its tables are fully synchronized - especially when a non-Oracle replication technique is used (e.g. a third-party application).

If you want to check if the data is in sync, you can use the PL/SQL package DBMS_COMPARISON. With the capabilities of this package, you can compare two tables or materialized views between different schemas or different databases using a database link connection.

The presentation will explain the features of DBMS_COMPARISON in detail. After an introduction to the package, a closer look at the internals will be executed. Some of the features are part of a live demo.

At the end of the presentation alternatives to this package will be introduced.



Hey DBMS_COMPARISON! - Are my Tables in sync?

There is more than one way to upgrade your Oracle database to the supported version. The most logical version to upgrade your database is 19c. The latest release is 21c, but we do not want you to upgrade your database to 21c. But, I will share a few cool 21c features that are backported to 19c in various Release Updates (RU). This session will discuss upgrading your 10g/11g/12c/18c databases and the nuances to watch in each upgrade method. 

Destination Oracle Database 19c: Ways to get there

21c is the latest database version that we have now with us. This session will make the attendees know about the important new features introduced with database 21c. We shall be look 

Getting to know Oracle Database 21c

Japan

I will present a few consideration points regarding performance on Oracle 19c/ExadataX7 migration from my experience on a recent large enterprise project. The points include optimizer migration, utilizing pending statistics and smart scan, and efficient test with PDB flashback. Regarding optimizer migration, I will explain the process to design optimizer related parameters and some performance issues we encountered. I will also talk about how we utilize pending statistics and reduce operational burden. I will explain Exadata smart scan with its prerequisites and blocking factors and introduce NSMTIO trace to understand direct path read decision. I will present how we design our test environment with backup/recovery and how flashback technology can help improve test efficiency.

a few consideration points of performance on Oracle 19c migration

Database migrations should be simple, automated, and reliable. Join this session to see how Zero Downtime Migration (ZDM) can make this expectation a reality for Oracle Database Cloud Migrations to Exadata, DBCS, ExaCS, ExaCC, or Autonomous Database.

APAC Database Days 2022

Speakers

Sean Scott

riaz ansari

Jayaprakash Subramanian

Ashwini Raju

Alex Blyth

Chandan Tanwani

Christian Gohmann

Biju Thomas

Aman Sharma

Kazuhiro Takahashi

Ricardo Gonzalez