Gold Coast OTN Day

Instance and SQL tuning with EM12c Cloud Control is so easy, it is not even much fun anymore. Also, not every customer may have the appropriate license or database edition, or all you have available remotely is a command-line login to a database.
This presentation showcases a few open-source database tuning tools such as Snapper and ASH replacements that DBAs can use to gather and review metrics and wait events from the command line and even in standard edition.
This is done by dissecting the familiar performance pages in EM12c, explaining the underlying statistics and showing how similar observations can be made in other tools.

Oracle Multitenant option allows you consolidate multiple databases into a single one. But most DBAs find the idea of managing a multitenant environment daunting. In this session you will learn what the speaker—a real word DBA user—did to be a DBA in a multitenant environment and used the tools, features and techniques always used--backup/recovery using RMAN, ASM, security, RAC, Data Guard, Cloud Control, EM Express and everything else. As this session will explain, there is little change to your understanding to manage a multitenant database—both as a CDBA and a PDBA.

Value to the Customer

Many customers often find multitenant concepts hard to understand and are concerned about the compatibilities of the tools they are familiar with. This session aims to quash those concerns.

The multitenant architecture was "the" headline feature announced in Oracle Database 12c. On the surface pluggable databases sounds great, but are they really? This presentation will explain the parts of your systems that will break if you move to pluggable databases, but why you should probably use them anyway.

Implementing database security in today's insecure world is not just a challenge for newly started; but for veterans as well. It's a delicate balance between the need to apply CPU patches and the inevitable downtime. In this session attendees will learn some simple but highly effective steps they can implement in just one day that will eliminate a lot of vulnerability and make the database secure against 90% of the common attacks. All the concepts will be explained with the cause of the vulnerability and how it can be sealed with the relatively simple techniques available with the Oracle database, some with live demos. The knowledge comes to aid of those who plan of complaint with PCI, SOX and GLBA requirements.

Introduced with Oracle 8i, services are becoming more and more useful with every new version of the Oracle database. Yet many users are missing out on many great features that a proper implementation of services can provide. Learn how to use services to get a headstart into monitoring and resource management, provide flexibility for maintenance and migrations and unlock the full potential of RAC and Data Guard deployments in terms of manageability and availability.