The Australian Oracle User Group, AUSOUG, have a focus on bringing together our Oracle community and servicing their core technical, development and applications needs. A balanced program is aimed at all levels of skill and experience within a forum of User led independent knowledge sharing.
AUSOUG will be hosting a series of webinars to be held every Wednesday commencing on 9th March 2022 whereby each week will focus on a particular area.
We invite Oracle professionals to submit abstracts for the Webinar Series.
Area of Interest
We are constantly seeking presenters for the Webinar Series.
If you are interested in presenting a webinar, please submit your paper/abstract via this link.
For more information on our Webinar Series 2022 partnerships, please contact firstname.lastname@example.org
|Graphing Grifters: Identify & Display Patterns of Corruption With Oracle Graph Studio by Jim Czuprynski
Ever wonder how your bank knows when to text you when a potentially fraudulent transaction appears on its radar? |
It’s simple if you know how to apply the right algorithms to financial transactions so that outliers become readily apparent.
These techniques can be applied to just about any anomalous behavior, and property graph technology helps make outliers stand out dramatically.
Through presentations and online demonstrations, this session will:
• Show how to use appropriate ML algorithms already built into Oracle Database to uncover anomalous patterns
• Demonstrate Oracle Graph Studio’s capabilities to identify and display outliers more clearly
• Introduce the basic concepts of PGQL (Property Graph Query Language) to look at tabular data in completely new way
|13/7/2022||12:00pm AEST||1 hour||Register|
|Introducing Oracle Zero Downtime Migration 21.3 by Gavin Soorma
Oracle Zero Downtime Migration (ZDM) is Oracle’s premier solution for a simplified and automated migration experience to the Cloud providing zero to negligible downtime for migration of on-premise production workloads to the Oracle Cloud Infrastructure.|
ZDM follows Oracle Maximum Availability Architecture (MAA) principles completely and incorporates products such as GoldenGate and Data Guard to ensure High Availability and an online migration workflow which supports both a logical as well as physical model.
|20/7/2022||7:00pm AEST||1 hour||Register|
|On the way to the “Least Privilege Principle” – Privilege Analysis with the Oracle Database by Markus Flechtner
As a DBA you probably know the situation: one of the first SQL commands when installing third-party software is “GRANT DBA TO ..”. Or: the developers in your own development department don’t know which privileges they need in the database – and first demand DBA rights in the development environment. |
And then the security officer appears on stage and says “everyone may only get the rights he really needs” – the well-known least privilege principle is required.
But how can this be found out?
Since database version 12c Oracle offers the feature “Privilege Analysis” for this purpose.
Unfortunately, the use of this feature was originally linked to the Database-Vault-License – and therefore not (legally) applicable for most DBAs.
This restriction was lifted in November 2018: all customers with Enterprise Edition are allowed to use the feature.
Reason enough to take a closer look at this functionality in the presentation: how can the DBA determine which rights the applications and users really need and set up a suitable rights concept for them?
|3/8/2022||7:00pm AEST||1 hour||Register|
This year we’ve been able to secure some of the worlds best speakers to present the Webinar Series 2022.
To find out more about each speaker, read the their bio and see what papers they will be presenting, simply click on the desired speaker.
Cloud Expert | DevOps | Oracle Expert
Principal Product Manager
Zero Defect Computing, Inc.
President, Douglas Volz Consulting
Douglas Volz Consulting, Inc
VP, Delivery Growth and Excellence
Viscosity North America
Lead Database Consultant
Senior Principal Advanced Support Engineer
Solution Engineer - Database, North America Technology Solution Engineering Team
Senior Member of Technical Staff in Observability and Management area
Oracle Cloud Specialist
Principal Product Manager
Oracle Certified Professional (OCP)
Principal Product Manager
Oracle Database MAA PM team
Past webinar recordings is accessible only AUSOUG members only.
Membership starts from as low as $49.00.
Recordings of past webinars and conferences is available clicking on the link Here
|Securing Communication with Oracle Databases by Aishwarya Kala|
This session will aim to help DBA's get answers to all the above questions, take advantage of the various oracle features, understand their usage, and leverage these tools to harden the security of the databases? We will introduce wallets, certificates and secure connections, bust the mystery around their configuration & maintenance Look at various tips & tricks around managing them based on real-life use cases, including requirements form organizations to move to the more secure TLS v1.2?
|Crisis Survival Guide of Oracle DBA by Emre Baransel|
When a critical production database can't service to majority of its users we can call this a "crisis". These problems can show up in different forms like data corruptions, data loss arising from user fault, after change issues (upgrade, patch, migration etc.), hardware problems, load issues and more. It's crucial to follow right direction for the solution when "downtime" starts ticking. While supporting big customer systems for almost 10 years in Oracle ACS, i experienced these "crisis" at first hand and i prepared this presentation for Oracle DBAs to get ready for these unwanted but possible cases. I will start with general Crisis Management rules and cover a range of scenarios like RMAN restore/recovery, Data Guard failovers, Flashback features, database upgrades/migrations with spot-on hints and real-life lessons learned.
|Oracle Database Sharding- hyperscale, globally distributed, converged databases by Chetan Vithlani and Priya Dhuriya.|
Join Chetan Vithlani and Priya Dhuriya for the latest updates and best practices regarding Oracle Database Sharding. See how it enables linear scalability, fault isolation, and geo-distribution for your critical applications. In this session, you will learn: 1. How a single global Oracle Database can help customers meet stringent data sovereignty requirements 2. How Oracle Database can support hyper-scale applications with a shared-nothing architecture supporting up to 1000 nodes 3. Get an Oracle Database Sharding live demonstrationJoin Chetan Vithlani for the latest updates and best practices regarding Oracle Database Sharding. See how it enables linear scalability, fault isolation, and geo-distribution for your critical applications.
|Analyze Logs using Machine Learning techniques by Ashwini Raju|
IT environments have evolved rapidly, but existing monitoring and management offerings have not kept up with the increasing complexity found with multicloud and on-premises . Our integrated platform aggregates all observability data for holistic analysis and optimized ML algorithms that can identify anomalous system behavior, rapidly isolate and remediate performance problems, and prevent outages by providing accurate forecasting of impending issues.
|Oracle Cloud Infrastructure latest updates in 2022 by Barbara Rabinowicz|
This presentation will cover the new services across OCI's cloud services. It will provide an overview on topics such as network, compute, storage, security and databases offerings which have been released in 2022 on Oracle Cloud.
|Efficient Data Handling Techniques in Python for Oracle Database by Sharad R Chandran |
This technical, demo-rich session highlights the popular and full-featured Python interface for Oracle Database, showing how to create database-backed applications. Learn techniques for efficient data loading and access. Learn best practices in connection management. See how features like Application Continuity improve the availability of applications.
|Automate and Bulletproof Your Data Guard by Charles Kim|
Learn how you can setup Data Guard with all the best practices. Attendees will get a brief history of Data Guard and how it became Data Guard. Then we will dive directly into new features in Oracle Data Guard 12c Release 2/18c/19c new features. In addition to demonstrating how simple it is to setup Data Guard, this session will disseminate fundamental Data Guard best practices and reference architectures that DBAs need to know to protect their Oracle ecosystem. The author of the Oracle Data Guard Handbook will demonstrate how DBAs should setup, configure, and monitor mission critical Data Guard environments (including Active Data Guard). Come see Data Guard best practices in action. The session concentrates on: o Building the Physical Standby o Monitoring and Maintaining the Physical Standby o Configuring Data Guard Broker o Performing Backup and Recovery with RMAN o Setting Archive Retention o Switchover with Refreshable PDBs o Subset Standbys with PDBs Attendees will get access to all the scripts to automate the Data Guard configuration.
|Design your Employee Experience with Oracle Journeys by Debra Lilley|
Journeys is the evolving functionality which gives your HR teams the power to create great experiences for employees. How does this HR teams the ability to innovate and deliver a more human-centered experience for users. - how Journeys enables Inoapps (an Oracle-only partner using Oracle Cloud for their internal systems) to provide a tailored learning programme with content varying across the UK and APAC regions as they execute on their aggressive growth strategy.
|Creating Applications for Mobile Devices by Karkuvelraja Thangamariappan|
This session will describe how you can create apps for mobile devices that are mobile-specific and provide an optimal user experience on small screens and discover the features and requirements for Progressive Web Apps (PWA).
|Kubernetes in Depth But in simple way by Osama Mustafa|
Kubernetes has been trending for the last four years, but it's never too late to learn more about it; Kubernetes provides an easy way to scale your application compared to virtual machines.
It keeps code operational and speeds up the delivery process. Kubernetes API allows automating many resource management and provisioning tasks; in this session, you will learn and understand Kubernetes and why I need to use it?
|Oracle Database Online Data Reorganization and Redefinition benefits, use cases by Suraj Ramesh|
As businesses become more web and e-commerce-enabled, high availability computing solutions are becoming increasingly important because of the extremely high cost of application downtime. According to a Gartner Group study, the cost of outages for corporations involved in e-commerce can easily reach millions of dollars per hour. Therefore, database availability and manageability have become increasingly important in many of today's mission-critical environments. One way to enhance availability and manageability is to allow users full access to the database during a data reorganization operation. Oracle's DB DBMS_REDEFINITION is a compelling package used to 'online redefine' tables. Online redefinition of a table means that changes (inserts/updates/deletes/merges) can be made to the table while modifications to the data are being made. Join this session to understand the key benefits of Online Data Reorganization and Redefinition.
|EBS Discrete WIP Variances, How to Overcome the Confusion! by Doug Volz|
Having difficulty understanding Oracle EBS Discrete WIP variances? Can’t make heads or tails of the WIP job close variances? How are these variances calculated? How to read the Discrete Job Value Report for Standard and Average Costing? What are resource efficiency variances? Material usage variances? And what about configuration and methods variances? Is it possible to have lot size variances as well? Go beyond what the standard Oracle reports have to offer and learn how you can quickly analyze your WIP jobs. For Discrete Costing learn about the available standard reports and inquiries, plus, additional reports available from Enginatics and Blitz Report (yes, even the underlying report SQL is available upon request). Applicable to both Release 11i and 12.
|The new norm: Optimising Oracle workloads to do more with less by Chris Bannayan
Evolving business pressures and economic uncertainties are creating new challenges for IT departments to do more with less. To support businesses in this new norm a simple, resilient and agile infrastructure is needed now more than ever.
You’re invited to join Pure Storage’s webinar on database and data centre consolidation where Chris Bannayan, Database Solutions Architect, Asia Japan & Pacific at Pure Storage, will unveil how you can get the most out of your Oracle database workloads and support evolving business demands of this new norm.
During the session we’ll cover:
· Cost reduction strategies: Identifying cost savings through removing unnecessary software licenses, data reduction capabilities and data centre consolidation.
· Streamlining systems: Consolidating your Oracle database workloads effectively to simplify management and free up time for strategic initiatives to support globalization.
· Agile performance optimisation: Removing roadblocks such as downtime and lengthy clone cycles to ensure you’re getting the most out of your system, without compromise.
|10 February 2021|
|How to work smarter with Payables by Nigel Grange Processing invoices can feel like a formidable task, the share amount of data that must be collected, verified, and processed is massive. What if there was a better way to streamline invoice processing? See how to get the most out of the industry-leading More4apps AP Invoice wizard and transform your workday in this 35-minute session. Filled with practical hints, tips, and tricks from product expert Carlos Urtubia, attendees will develop an understanding of best practice methods designed to ensure they get the best out of this popular software solution. Webinar attendees will have the opportunity to see how AP Wizard has transformed business practices for leading from customers and take away key learnings from their success. What you will learn: - Demonstration of practical real world scenarios - How to save time when matching invoices - Tips and tricks so your organization and team get the most out of their Oracle EBS Investment||17 February 2021|
|ZDLRA, What you need to know to understand it by Fernando Simon Zero Data Loss Recovery Appliance (ZDLRA) is an Oracle Engineered System and part of MAA family that was built to protect your databases for several kinds of outages and provide reliable recovery options. But what is ZDLRA? And how the features work to allows you to reach the zero data loss? This session addresses what it is and how ZDLRA works, helping you hat will help you to understand it covering features like: Incremental Forever strategy and the Virtual Full Backup, Real-Time Redo, Multi ZDLRA Replication, ZDLRA Catalog management, MAA Integration, and some internal details about architecture. But besides the tech part, this presentation shows how you can use all these features to protect your databases.||03 March 2021|
|DevOps and Agile in the Oracle Cloud - A day in the life of a dev team by Shay Shmeltzer Get an overview of the DevOps and Agile platform included in Oracle's Cloud - Visual Builder Studio - and how a typical development team can leverage it. Learn about the integrated platform offering issue tracking, development sprint management, code artifact versioning, and continuous delivery automation. We'll focus on a demo showing the full development cycle from planning to deployment in an integrated way.||10 March 2021|
|OAF Personalizations 2021 - New Advanced Examples by Susan Behn Have you ever wanted to add an LOV to an OAF page without using jDeveloper? This and many other examples in this presentation can be easily replicated to streamline the user experience. The primary purpose of this presentation is to promote personalization over customization or extension. Oracle has continued to improve the personalization functionality especially for OA Framework. However, while Oracle provides some documentation on these new features, this presentation provides some real world examples with detail step by step instructions specifically for the E-Business Suite using the Vision database.||17 March 2021|
|Oracle Linux DevSecOps: Staying Ahead of Cyberthreats by Nirav Kamdar Oracle Linux (OL) Premier Support includes KVM and server virtualization manager, Oracle Linux Cloud Native Environment which includes Kubernetes, Kata Containers, and more. IT systems require regular patching for security, performance, and compliance reasons. OL Premier support also includes zero-downtime kernel and user-space updates with Oracle Ksplice. 1. Secure Linux: Oracle Linux is certified under Common Criteria and FIPS 140-2, as well as Listed on NIAP product compliant list. 2. Securing Linux Kernel: Non-Disruptive kernel patching, Ksplice supports critical user space packages such as Glibc and OpenSSL, KVM and Xen hypervisors. Ksplice also delivers Known exploit detection for privilege escalation vulnerabilities. 3. Secure Containers: Kata containers are lightweight VMs, which behaves like containers with the isolation of VMS. With Kata containers, get security for workload while running them on Kubernetes. 4. Secure Code: Istio can help secure application/code, while delivers automatic encryption of communication between services. There is no silver bullet to Cyber Security, hence leveraging defence-in-depth approach will at least improve security posture.||24 March 2021|
|Converged Database by Arvind Bhope Modern data driven applications are bringing in a lot more complexity with different data types like Relational,Document,Spatial,Graph, etc and workloads Transactions ,analytics, ML,IOT to name a few. This data and workload require different database algorithms to solve with unique development paradigms and the two possible data strategies are Single Purpose purpose built databases which are best of breed for individual data types and workload OR use a Converged database for all data types and workloads. Problems ? Once we have a single purpose individual db for Spatial,ML, Blockchain, JSON, Graph etc.. we are actually introducing a lot many variables to the ever changing components in existing infrastructure which inherently is increasing the complexity. Single purpose Database would eventually end up doing a lot of custom work, writing more code independently using individual Proprietary API's and transaction models. Propagating and transforming all these changes with fragmented data all over the place creates lot more complexity and there is definitely a need to integrate it with a lot of customization. This Integration is a job that never ends. The necessary features like security, availability,scalability are just very complex to achieve,as each of them has its own models to be built. Later, to propagate any of the smallest change and integrate its a huge activity. Availability,scalability,consistency,End to End security etc are very limited in their areas by weakest of their databases that are implemented. Combining all of them gives worst of weakness. These systems are JUST NO economies of scale. Solution: What if we say all the above challenges are addressed in Converged database. Oracle Converged Database is a data innovation platform ,an ecosystem which increases the strategic business value of data. Click here for more information on solution - https://www.ausoug.org.au/paper/converged-database/||31 March 2021|
|Unleash the Top 19 New Features of Oracle Database 19c by Charles Kim Oracle Database 12 Release 2 is packed with enhancements for DBAs and Developers. Come listen to all the pertinent new features in Oracle 12.2/18c/19c that will change how you perform maintenance and tune the database. This session is not the traditional Oracle 12.2/18c/19c database features. Be prepared to have mind overloaded with the following focused areas: 1. Oracle 20c New Features 2. Oracle 19c New Features 1. Why do you need to go directly to Oracle Database 19c and skip Oracle Database 12.2/18c 3. Oracle 18c New Features 4. Upgrade to Oracle 12.2/18c/19c/20c a. Upgrade considerations b. Zero downtime upgrade options 5. Multi-Tenancy (PDB) Option 1. Elimination of support for non-container databases in Oracle 20c 2. Changes in Oracle licensing policy with Oracle19c 6. Online Improvements 7. Partitioning Option 8. Data Guard 9. RMAN 10. General Database 11. RAC 12. ASM/ACFS 13. In-Memory Oracle DBAs/Developers can take immediate advantage of these new features. We will rapid fire all the new features to the audience. We will share all of the code from our presentation so that you can add them to your arsenal.||07 April 2021|
|Automating Invoice Processing in Oracle Cloud ERP Leveraging Bots by Dr. Nikhil Jain and Vishal Saxena Organizations embracing automation into their finance function have experienced reduction in process cycle time and costs up to 70% - 80%. When your team spends less time processing invoices, they can focus on more value-generating tasks. Join our subject-matter experts – Dr. Nikhil Jain, Solution Architect in conversation with Vishal Saxena, Finance and Supply Chain Specialist, as we bring to you an exciting session on how you can achieve Invoice Process Automation within Oracle Applications. 1. Minimize invoice processing effort and time 2. Eliminate manual data entry and errors 3. Improve vendor association 4. Improve visibility across the Accounts Payable process 5. Improve reconciliation Learn how our Bot based solution can transform Finance and Accounting to ensure faster, error-free tasks and process optimization in your Enterprise. We will also walk you through a short demo automating invoice processing using our Bot based solution.||14 April 2021|
|What’s new with the World's fastest EBS reporting solution? by Beth Skerrett / Andy Haack World’s fastest EBS reporting solution – Increase your team efficiency by getting end-user operational reports faster than ever before with modern, easy to use reporting. This presentation shows how a new approach can provide easier, faster, more efficient access to data in an instantly usable format that end users love. See how to migrate reports from existing ageing and inefficient EBS reporting tools like Discoverer, Polaris, Report Wands, and BI Publisher. With the ability to export over one million transactions in less than 10 seconds, and with our unlimited data output, it is an option that users of large volumes of data need to see to believe! This presentation will demonstrate how job satisfaction and productivity can be increased for all EBS business users and developers. We demonstrate Blitz Report™, a reporting option available to EBS operational users looking to manage large volumes of transactional data quickly and efficiently, and how using this solution with Oracle's Enterprise Command Centers is a game-changer for EBS teams. Objective: The objective is to help EBS business users and developers increase their job satisfaction and productivity by adding a new transactional reporting solution to their current reporting and analytics tools.||21 April 2021|
|Running Oracle Databases on Containers and Kubernetes with Pure Storage by Chris Bannayan Gartner predicts that by 2022, more than 75% of global organisations will be running containerised applications in production, up from less that 30% today. Businesses now, more than ever should be putting together a strategy of how they will embrace this world of containers and Kubernetes to optimise their workloads in the transforming world. See how Pure integration with Containers and Kubernetes, coupled with its simplicity, efficiency and performance will modernise your data centre, reduce your complexity and increase your agility, so that your business can focus more on innovating and less on managing. During the session we’ll cover: ● How to create Docker containers using the Pure Storage plugin ● How to create persistent volumes using the Pure plugin ● How to create Oracle containers with persistent storage ● How to clone Oracle containers to create Dev/Test environments ● How to refresh Dev/test containers from a prod container||19 May 2021|
|Ensure a Successful Oracle Cloud Migration by Peter Earnshaw The move to enterprise applications such as Oracle Cloud can offer many benefits along with a myriad of challenges, many of which may be unknown until you are knee-deep into the project. Up to 80 percent of problems with enterprise systems are related to human error and unidentified technical issues. Before you get started, it is imperative to carefully plan and make sure you have the capability and visibility to measure user behaviour, workflows, interaction, adoption, and most importantly, how they can impact productivity and profitability. In this webinar we are going to answer 5 critical questions you should ask before embarking on your Oracle Cloud project: Where should we start? How do we mitigate risk? How do we know what processes and transactions need to be prioritized? How can we maximize adoption? How can we measure ROI? This webinar will give you some answers to these questions along with showing you the benchmark data needed to get you started on your journey.||02 June 2021|
|Securing your mission critical systems running Oracle from cyber attacks by Trichy Premkumar Until recently, organizations have focused on trying to prevent cyberattacks, which come primarily from hacking and malware. However, the likelihood that all malware will be discovered before harm is done is slim, particularly for slow-moving and sophisticated attacks. This difficulty of detecting malware early gives hackers time to orchestrate attacks ranging from extortion to outright destruction of mission-critical systems. Such cyberattacks can cripple an organization, leading to revenue loss, negative publicity, and lasting customer distrust. In this session we will review how Oracle data protection can be simplified, secured and enhanced to include comprehensive cyber recovery protection.||09 June 2021|
|Containerization 101 by Osama Mustafa Containerization is the process of packaging software code, its required dependencies, configurations, and other detail to be easily deployed in the same or another computing environment. In simpler terms, containerization is the encapsulation of an application and its required environment, Learn about the docker , and what is Containerization such as Docker swarm and kubernetes.||16 June 2021|
|How Does Oracle Cloud Costing Stack Up Against Oracle EBS Costing? by Doug Volz Oracle keeps on "banging on" about the Cloud Applications. Are you curious what it looks like or how it compares to Oracle EBS? This webinar session moves beyond the fluffy sales presentations and dives into the details, directly comparing Oracle EBS to Oracle Cloud Costing. Including many of the Cloud Costing setup steps, so you can see what is actually involved. Objectives: 1) Find out if Cloud Costing is really different from EBS Costing 2) Compare Oracle EBS to Oracle Cloud Costing 3) Learn about the Cloud Costing setup steps 4) Get an overall impression for how Cloud Costing helps and doesn’t help you||23 June 2021|
|Automate Database Provisioning for DevOps using Database-as-a-Service - Chetan Vithlani/Venkata Bandaru/Maniselvan Kannimuthuraj Often DBAs want to allow self-service access to certain database operations. By doing so, the DBAs can free-up their own time while enabling others to do their jobs faster. Self-service access (SSA) is enabled right from the Oracle Enterprise Manager. The Self-Service Portal allows users to create new service instances (Databases or Pluggable Databases) based on Service Template configured by SSA administrators. Additionally, Oracle Enterprise Manager Database as a Service Snap Clone is a ‘self-service’ solution for enabling rapid creation of space efficient clones for large, multi-terabyte databases. Snap Clone can improve the efficiency and agility of administrators and QA engineers while reducing storage-related CAPEX. Database as a Service Snap Clone allows administrators to create fully functional copies of databases using the copy-on-write (CoW) capabilities of the underlying storage layer. Users can request databases from the self-service console and have them provisioned within minutes instead of hours while keeping storage needs to a minimum. This Session will cover database automation for devops: 1) self-service users such as developers and QA can leverage DBaaS (Database-as-a-Service) to quickly provision databases 2) create storage efficient thin clones for development purposes, and 3) chargeback/show back of resources used at the OS and DB level to ensure that proper accounting is kept for resource usage in your private cloud.||07 July 2021|
|Information Life Cycle Management : Manage Exponential Data Growth (Live Demo) by Chandan Tanwani 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.||21 July 2021|
|Magic of Oracle Cloud Infrastructure with Ansible by Arpit Agrawal This session would cover the aspects of Infrastructure provisioning in OCI using Terraform on the fundamentals of Infrastructure as a code. Why automate OCI Provisioning? Real world Terraform OCI Examples Terraform Installation and Best practices Tip and Tricks on Infrastructure as a code.||04 August 2021|