Loading…
This event has ended. View the official site or create your own event → Check it out
This event has ended. Create your own
Sydney Oracle Meetup and APACOUC welcome you to the first Sydney OTN Day (Part of the 5th APAC OTN Tour).
View analytic

Sign up or log in to bookmark your favorites and sync them to your phone or calendar.

Monday, November 30
 

08:00

Registration
Registration and Credential Collection

Monday November 30, 2015 08:00 - 09:00
Main Room

09:00

Oracle Indexes Q&A With Richard Foote
Limited Capacity seats available

Indexes are fundamental to every Oracle database and are crucial for optimal performance. However, there’s often much misconception and misunderstanding regarding how Oracle database indexes function and should be maintained.

Things can become even more confusing when one considers new indexing capabilities introduced with the Oracle 12c Database, Oracle engineered solutions such as Exadata and new database options such as the In-Memory Database option.

This is a wonderful opportunity to both learn and ask index related questions in an open forum directly to Richard Foote, a highly-respected Oracle indexing expert, well known for his Oracle Indexing blog and many public presentations and seminars on this subject.

Speakers
avatar for Richard Foote

Richard Foote

Technical Pre-Sales Consultant, Oracle
Based in Canberra, Australia, Richard has been working in the local IT industry for nearly thirty years, twenty some years with Oracle database technologies. Richard has supported numerous highly secure, mission-critical, large-scale Oracle database systems. In 2002, he became a member of the world-renowned Oracle OakTable Network and an Oracle ACE Director in 2008. Richard is a very popular speaker and regularly presents at conferences... Read More →


Monday November 30, 2015 09:00 - 09:45
Main Room

09:00

Supercharge Your SQL Skillset with Connor McDonnald
Limited Capacity seats available

Cloud and virtualisation services now take care of many of the day to day concerns for organisations - keeping infrastructure up to date, ensuring the integrity of backup/recovery, resource capacity and high availability. Finally IT professionals can focus on the true art of software development - writing quality SQL to provide data to upstream services. This session covers some of the SQL techniques available in the Oracle database, to allow developers to supercharge their SQL skillset.

Speakers
avatar for Connor McDonald

Connor McDonald

Oracle Developer Advocate, Oracle
Connor McDonald is a former Oracle Ace Director who has joined the Oracle Developer Advocates team. Over the past 18 years, he has worked with systems in Australia, the UK, Southeast Asia, Western Europe, and the United States. He has co-authored three books, and has been a popular speaker at Oracle conferences around the world, specializing in topics regarding the database engine and PL/SQL. He has twice won the Inspirational Speaker award... Read More →


Monday November 30, 2015 09:00 - 09:45
Room 2

09:45

Break between Sessions
Monday November 30, 2015 09:45 - 09:50
Room 2

09:45

Break between Sessions
Monday November 30, 2015 09:45 - 09:50
Main Room

09:50

JSON Support in Oracle 12c with John King
Limited Capacity seats available

Oracle 12c adds formal support for JSON data with the 12.1.0.2 update released in the summer of 2014. While Oracle has supported XML data for years it does so with the special XMLType data type. Instead of a new data type, Oracle 12c stores JSON using standard Oracle character data (VARCHAR2, CLOB, BLOB). A JSON-specific “is JSON” test may be applied in CHECK constraints and WHERE clauses. Several JSON-specific functions are also provided including: JSON_EXISTS, JSON_QUERY, JSON_TABLE, and more. Attendees will learn how to create tables using JSON columns, how to INSERT data into JSON columns, how to query JSON data, and how to use JSON_TABLE to represent JSON data as “normal” relational data.

Speakers
avatar for John King

John King

Partner, King Training Resources
John Jay King is partner in King Training Resources tailoring and conducting training since 1988 (www.kingtraining.com). John customizes courses in topics including Oracle, MAF, and ADF. John presents frequently at conferences including Oracle Open World, RMOUG, IOUG, UTOUG, AUSOUG, and UKOUG; he is an Oracle Ace Director, member of the Oak Table Network, and serves on the AZORA board.


Monday November 30, 2015 09:50 - 10:35
Main Room

09:50

Oracle Flashback with Connor McDonnald
Limited Capacity seats available

With Flashback Data Archive now available as part of the core product, it's worth exploring this and all of the other flashback facilities available in the database engine. Flashback options are rarely considered in day to day practice, because of blinkered view that it is only for when an "accident" occurs. However, there are countless other value use cases that will be covered in this session. All of the variations: - flashback table - flashback drop - flashback query - flashback database - flashback transaction - flashback data archive will all be covered.

Speakers
avatar for Connor McDonald

Connor McDonald

Oracle Developer Advocate, Oracle
Connor McDonald is a former Oracle Ace Director who has joined the Oracle Developer Advocates team. Over the past 18 years, he has worked with systems in Australia, the UK, Southeast Asia, Western Europe, and the United States. He has co-authored three books, and has been a popular speaker at Oracle conferences around the world, specializing in topics regarding the database engine and PL/SQL. He has twice won the Inspirational Speaker award... Read More →


Monday November 30, 2015 09:50 - 10:35
Room 2

10:35

Coffee Break
Monday November 30, 2015 10:35 - 11:05
Main Room

10:35

Coffee Break
Monday November 30, 2015 10:35 - 11:05
Room 2

11:05

Database Performance Diagnostics: How to correctly use AWR Reports with Richard Foote
Limited Capacity seats available

I often get called in by customers to determine and address the root cause of database performance issues. Depending on the issue, a request for a simple Automatic Workload Repository (AWR) report is often sufficient to accurately diagnose the root problem.

In this session, I discuss how to best read an AWR report to quickly go to the most relevant sections that detail any specific issues. I also discuss a general tuning and diagnostic methodology that ensures you can quickly determine whether an AWR report will be sufficient and how to accurately and consistently use the AWR report to pinpoint and determine root causes for global database performance issues.

Speakers
avatar for Richard Foote

Richard Foote

Technical Pre-Sales Consultant, Oracle
Based in Canberra, Australia, Richard has been working in the local IT industry for nearly thirty years, twenty some years with Oracle database technologies. Richard has supported numerous highly secure, mission-critical, large-scale Oracle database systems. In 2002, he became a member of the world-renowned Oracle OakTable Network and an Oracle ACE Director in 2008. Richard is a very popular speaker and regularly presents at conferences... Read More →


Monday November 30, 2015 11:05 - 11:50
Main Room

11:05

12c for Developers with Connor McDonald
Limited Capacity seats available

With the banner headline multitenancy features in Oracle Database 12c, lost in the mix has been the incredible list of new features for developers. Hundreds of improvements and new facilities have arrived in Oracle Database 12c. This session redresses the balance and excites developers with all the new Oracle Database 12c goodies

Speakers
avatar for Connor McDonald

Connor McDonald

Oracle Developer Advocate, Oracle
Connor McDonald is a former Oracle Ace Director who has joined the Oracle Developer Advocates team. Over the past 18 years, he has worked with systems in Australia, the UK, Southeast Asia, Western Europe, and the United States. He has co-authored three books, and has been a popular speaker at Oracle conferences around the world, specializing in topics regarding the database engine and PL/SQL. He has twice won the Inspirational Speaker award... Read More →


Monday November 30, 2015 11:05 - 11:50
Room 2

11:50

Break between Sessions
Monday November 30, 2015 11:50 - 11:55
Room 2

11:50

Break between Sessions
Monday November 30, 2015 11:50 - 11:55
Main Room

11:55

Oracle Database 12c New Features for Developers and DBAs with John King
Limited Capacity seats available

Attendees are introduced to new and improved features of Oracle 12c directly impacting application development. Special emphasis is given to features that reduce development time, make development simpler, improve performance, or speed deployment. Specific topics include: IDENTITY columns, improved SEQUENCEs, INVISIBLE columns, improved defaults, JSON enablement, APPROX_COUNT_DISTINCT function, security enhancements, PL/SQL interoperability improvements, outer-join improvements, other SQL improvements, and Edition Based Redefinition (EBR) improvements. An overview of Oracle 12c Multitenant Features (“Pluggable” databases; CDB &PDB) and In-memory Database are included too.

Speakers
avatar for John King

John King

Partner, King Training Resources
John Jay King is partner in King Training Resources tailoring and conducting training since 1988 (www.kingtraining.com). John customizes courses in topics including Oracle, MAF, and ADF. John presents frequently at conferences including Oracle Open World, RMOUG, IOUG, UTOUG, AUSOUG, and UKOUG; he is an Oracle Ace Director, member of the Oak Table Network, and serves on the AZORA board.


Monday November 30, 2015 11:55 - 12:40
Main Room

11:55

Implementing Oracle database12c’s Heat Map and Automatic Data Optimization to optimize the database storage cost and performance with Kai Yu
Limited Capacity seats available

While SSD (Solid-state drive)  based storage significantly improves the database performance by removing the storage IO bottlenecks, the cost of SSDs is still much higher than one of regular spinning disks.  As a cost effective way to leverage SSDs performance, the storage tiering method stores those active data in high performance SSD storage and store those less or inactive data in low speed conventional spinning storage.  While the store tiering methods is usually implemented on the storage level  and setup by the storage admin,  Oracle 12c  Heat Map and Automatic Data Optimization (ADO) together called Information lifecycle Management (ILM) provide a great way for DBAs to automate the storage tiering for database segments on database level .  This session will show the steps and method by which DBAs can use to implement these Oracle 12c features to automate the compression of database segments as well as movement of them to another tier storage based on the usage of the data.

Speakers
avatar for Kai Yu

Kai Yu

Senior Principal Engineer and Technologist, Dell
Kai Yu is a senior principal engineer and technologist in Dell Enterprise Solutions Engineering lab. He focuses on design and architecting of various IT solutions and is the technical leader and architect of the Dell high performance integrated database systems: Dell Accelerate Appliance for Database (DAAD ) and Dell integrated System for Oracle Database(DISOD). He has given more than 100 technical presentations around the world including... Read More →


Monday November 30, 2015 11:55 - 12:40
Room 2

12:40

Break between Sessions
Monday November 30, 2015 12:40 - 12:45
Room 2

12:40

Break between Sessions
Monday November 30, 2015 12:40 - 12:45
Main Room

12:45

Database as a Service (DBaaS) Cloud: HA Architecture and Consolidation Methods with Kai Yu
Limited Capacity seats available

As IT organizations look ways to deliver the consolidated and shared infrastructure for their databases, Oracle Database as Service (DBaaS) cloud solution can be the answer to their demand. This session will discuss the design consideration and implementation best practices to ensure the high availability of DBaaS cloud through Oracle RAC and the latest Oracle 12c new HA features such as Application Continuity and Transaction Guard and Flex ASM. Through the implementation case studies in our own IT, this presentation will also examine and compare various database consolidation methods for achieving the multitenant database architecture such as virtualization, platform consolidation, pluggable database and schema consolidation.

Speakers
avatar for Kai Yu

Kai Yu

Senior Principal Engineer and Technologist, Dell
Kai Yu is a senior principal engineer and technologist in Dell Enterprise Solutions Engineering lab. He focuses on design and architecting of various IT solutions and is the technical leader and architect of the Dell high performance integrated database systems: Dell Accelerate Appliance for Database (DAAD ) and Dell integrated System for Oracle Database(DISOD). He has given more than 100 technical presentations around the world including... Read More →


Monday November 30, 2015 12:45 - 13:30
Main Room

12:45

Key Ingredients for a Successful Mobile Implementation with Chris Muir
Limited Capacity seats available

Getting data and processes accessible from Mobile devices is a key initiative for most organizations today. But what do you actually need in order to successfully implement a mobile strategy? In this session we'll review the components of Oracle's mobile platform and understand their role in establishing a successful mobile strategy. We'll discuss exposing data and processes in a mobile friendly way, providing mobile optimized services and engaging UI experience and securing the end-to-end solution.

Speakers
avatar for Chris Muir

Chris Muir

Oracle Senior Principal Product Manager,, Oracle
Chris Muir is an Oracle Senior Principal Product Manager, of the Oracle Mobile and Cloud Development Tools group. Chris covers Oracle's mobility and cloud development tools including Oracle Mobile Cloud Service (MCS), Oracle's Mobile Application Framework (MAF) & Application Development Framework (ADF). Getting data and processes accessible from Mobile devices is a key initiative for most organizations today. But what do you... Read More →


Monday November 30, 2015 12:45 - 13:30
Room 2

13:30

Lunch
Monday November 30, 2015 13:30 - 14:30
Main Room

13:30

Lunch
Monday November 30, 2015 13:30 - 14:30
Room 2

14:30

Optimize OLAP & Business Analytics Performance with Oracle 12c In-Memory Database Option with Kai Yu
Limited Capacity seats available

By introducing the In-Memory column store, Oracle 12c In-Memory Database option is designed to significantly improve query performance for OLAP applications such as Business analytics applications. Recently released Oracle In-Memory advisor provides advises on In-Memory store configuration and which tables or segments should be loaded into the In-Memory store and the estimated performance improvements. This presentation shows the steps to leverage theses In-Memory features with the business analytics applications. Through a case study of a financial analytics project, this presentation will discuss the configuration , best practices, lessons learned about how this In-Memory option helps improve the real time performance of financial analytic applications.

Speakers
avatar for Kai Yu

Kai Yu

Senior Principal Engineer and Technologist, Dell
Kai Yu is a senior principal engineer and technologist in Dell Enterprise Solutions Engineering lab. He focuses on design and architecting of various IT solutions and is the technical leader and architect of the Dell high performance integrated database systems: Dell Accelerate Appliance for Database (DAAD ) and Dell integrated System for Oracle Database(DISOD). He has given more than 100 technical presentations around the world including... Read More →


Monday November 30, 2015 14:30 - 15:15
Main Room

14:30

Team Development in the Cloud for Oracle Developers with Chris Muir
Limited Capacity seats available

The Oracle Developer Cloud service provides a platform for development teams to manage their full development lifecycle including tracking requirements and bugs, code versioning and review, and automating build, testing and deployment processes. In this demo focused session we'll show you how easy it is to get started with the platform and discuss how it can improve your product quality and team collaboration.

Speakers
avatar for Chris Muir

Chris Muir

Oracle Senior Principal Product Manager,, Oracle
Chris Muir is an Oracle Senior Principal Product Manager, of the Oracle Mobile and Cloud Development Tools group. Chris covers Oracle's mobility and cloud development tools including Oracle Mobile Cloud Service (MCS), Oracle's Mobile Application Framework (MAF) & Application Development Framework (ADF). Getting data and processes accessible from Mobile devices is a key initiative for most organizations today. But what do you... Read More →


Monday November 30, 2015 14:30 - 15:15
Room 2

15:15

Break between Sessions
Monday November 30, 2015 15:15 - 15:20
Room 2

15:15

Break between Sessions
Monday November 30, 2015 15:15 - 15:20
Main Room

15:20

PaaS4SaaS The Options with Debra Lilley
Limited Capacity seats available

Oracle’s Cloud Applications take away the need for a data centre but what happens if you need an extension that cannot be done at SaaS level? The good thing is that Fusion Architecture Principles means extensions are not a customization as we are used to, but something that sits alongside and integrated in the same way as co-existence with traditional apps. This session looks at a Proof of Concept, proving your systems integrator can become an ISV adding value to Cloud Applications and also gives the customer the same UX as with Oracle’s Cloud Apps.

We are also exploring the recently announced Application Builder Cloud Service and what this adds to the options.

Speakers
avatar for Debra Lilley

Debra Lilley

VP Cloud Services, Certus
Debra Lilley VP Certus Cloud Services, is an Oracle ACE Director and Fusion Applications UX Advocate. She is a director and Past President of UKOUG and led the Product Development Committee of the IOUC; the user group team working with Oracle during the development of Fusion Applications. | | Debra has 18 years' experience with Oracle, working with customers in all stages of their investment: pre sales, education, implementation and... Read More →


Monday November 30, 2015 15:20 - 16:05
Room 2

15:20

Logging or Nologging: That is the question! with Francisco Alvarez
Limited Capacity seats available

The main question about NOLOGGING I hear all the time is: does creating a table with the NOLOGGING option means there is “no generation of redo ever”, or just that the initial creation operation has no redo generation, but that DML down the road generates redo? How and when can the NOLOGGING option be employed?

Redo generation is a vital part of the Oracle recovery mechanism. Without it, an instance will not recover when it crashes and will not start in a consistent state. Excessive redo generation is the result of excessive work on the database. This presentation covers the subject of reducing redo generation using LOGGING and NOLOGGING options, the differences between them, how it happens, how to reduce it and when to use. Also, you will find examples and tips regarding each one of them.


Speakers
avatar for Francisco Munoz Alvarez

Francisco Munoz Alvarez

Vice President for Asia Pacific, Pythian
Francisco Munoz Alvarez has over two decades of experience in consulting, analysis, support, implementation, and migration of Oracle products. He is also an expert in most phases of a database life cycle, for example, development, stabilization, security, backup and recovery, tuning, installations, and data warehouse (ETL) with excellent implementation and support methodologies.He is an author and popular speaker at many Oracle conferences around... Read More →



Monday November 30, 2015 15:20 - 16:05
Main Room

16:05

Break between Sessions
Monday November 30, 2015 16:05 - 16:10
Room 2

16:05

Break between Sessions
Monday November 30, 2015 16:05 - 16:10
Main Room

16:10

What does Digital Disruption Mean To The Oracle Ecosystem? with Debra Lilley
Limited Capacity seats available

Disruption is not just for the consumer, it is also for the provider. Look at how the big vendors are clambering for market share of cloud. There is no doubt cloud is here, now, the just talking about it is over; the move to cloud marches quickly on. Cloud is not just about hosting, and I believe there is a lot of deliberate confusion and clever use of words from all the vendors, and each have their own definition of what makes a ‘real’ cloud, but what is true to all, is that cloud matters.

So if we accept that this change is here, what is it mean to you? One question I get asked a lot by technical people is “what does this mean to my job? I’m a DBA / Developer in an organization supporting EBS / PeopleSoft etc. and we are thinking of moving to Cloud. Does it mean I won’t have a job?” The answer is, as Tom would say, “it depends.”

This presentation will explore what Digital Disruption means to the Oracle Eco-system, Their product, the way they work, Partners, Professionals and Customers and of course user groups

Speakers
avatar for Debra Lilley

Debra Lilley

VP Cloud Services, Certus
Debra Lilley VP Certus Cloud Services, is an Oracle ACE Director and Fusion Applications UX Advocate. She is a director and Past President of UKOUG and led the Product Development Committee of the IOUC; the user group team working with Oracle during the development of Fusion Applications. | | Debra has 18 years' experience with Oracle, working with customers in all stages of their investment: pre sales, education, implementation and... Read More →


Monday November 30, 2015 16:10 - 16:55
Main Room

16:10

Oracle VM Tips and Best Practices with Francisco Alvarez
Limited Capacity seats available

A vibrant session with “Real Tips” for real world daily OVM problems a DBA could find. Here you will learn how to improve your productivity, how to solve some real problems and also learn several tips to help you to have a successful OVM Implementation. It also will show you the performance comparative of an Oracle database running in HVM, HM+PV and PVM (Domain Type) , how to improve the performance of your VMs , and learn about how far can you push the over commit of CPU at Oracle VM.

Speakers
avatar for Francisco Munoz Alvarez

Francisco Munoz Alvarez

Vice President for Asia Pacific, Pythian
Francisco Munoz Alvarez has over two decades of experience in consulting, analysis, support, implementation, and migration of Oracle products. He is also an expert in most phases of a database life cycle, for example, development, stabilization, security, backup and recovery, tuning, installations, and data warehouse (ETL) with excellent implementation and support methodologies.He is an author and popular speaker at many Oracle conferences around... Read More →



Monday November 30, 2015 16:10 - 16:55
Room 2

17:00

Closing and Drinks
Monday November 30, 2015 17:00 - 18:30
Main Room