This session will show how to use the data within AWR to identify periods of high resource utilization and generate AWR reports for those periods of high utilization. Using this approach, DBAs can identify potential performance problems before they have been reported by the end users. All scripts used will be provided. Whitepaper PowerPoint

Oracle Database Release 12cR1 introduced several new features for automatically tuning SQL statements with much less involvement from the Oracle DBA and applications developers. Oracle DBA and Oracle University instructor Jim Czuprynski will demonstrate how the combined feature sets of Adaptive Execution Plans (AEP), Automatic Re-Optimization (ARO), and SQL Plan Directives (SPDs) are at the…

Oracle Database Release 12cR1 introduced dramatically new capabilities for Information Lifecycle Management (ILM). Oracle DBA and Oracle University instructor Jim Czuprynski will delve into how best to leverage these transformative features to improve query and DML performance in an Oracle 12cR1 environment. PowerPoint

Oracle DBA, consultant, and Oracle University instructor Jim Czuprynski will demonstrate how to leverage several new features of Oracle Database Release 12cR1 that dramatically decrease the time it takes to back up Oracle 12c databases, as well as perform recovery at much more granular levels. Jim will also explore the incredible speed at which Oracle…

McKesson needed to maintain access to our 65 million documents during our JDE Edwards and WebCenter upgrade project. We needed to maintain access from existing integration with JD Edwards XE and other in-house applications while upgrading/migrating to WebCenter Content: Imaging 11g. At the same time we were upgrading JD Edwards to 9.1 and needed to…

Edition-Based Redefinition (EBR) was often described as the “killer feature” of Oracle 11gR2 it has been enhanced in Oracle 12c. This session will explore the concepts of EBR and planning for EBR implementation. Specific topics include: Changes in 12c, Edition objects, Editioning Views, and Cross-Edition triggers. A brief demonstration will highlight the basics of EBR.…

SQL Injection, Cross Site Scripting, and Broken Session Management are some of the biggest web application vulnerabilities known. But you don't have to be a security guru to understand and avoid them! Come to this session to learn about the OWASP Top 10 security vulnerabilities on the web, and ADF best practices to protect your…

SQL Injection, Cross Site Scripting, and Broken Session Management are some of the biggest web application vulnerabilities known. But you don't have to be a security guru to understand and avoid them! Come to this session to learn about the OWASP Top 10 security vulnerabilities on the web, and ADF best practices to protect your…

TED-style lightning talks with or without slides. Each talk is 10-15 minutes when author will share an innovative perspective relevant to the database industry. The talks is the mix of technical and non-technical topics.

DBaaS, (Database as a Service) is a newer EM12c cloud feature that has many DBAs scratching their heads and wondering what it's all about and how it fits in their changing world as we head to the cloud. DBaaS, especially with Database 12c will have DBAs focus less on building databases, but more on managing…