Tag: IOUG

MySQL offers enterprise security benefits that you may not be aware of and some that you may be aware of.  In this presentation we will explore MySQL database security at community edition up to enterprise edition.   The security capability is much more then most would think especially with enterprise edition.  Come explore how you can…

Data is the life blood of your company, and Oracle Data Guard and Oracle Active Data Guard have long been the answer for the real-time protection, availability, and usability of your Oracle data. Attend this session to get an in-depth look at several key new features that will make your life easier and protect your…

Learn how to easily run SQL, PL/SQL, and shell scripts on a large number of databases and hosts.  The open source program Method5 provides agentless remote execution, built entirely inside Oracle.  Remote execution lets us find, fix, and prevent problems that could never be solved one-database-at-a-time.  Querying and controlling all our databases starts with this…

Do you need to add complex validations, dynamic actions and/or implement interactive grid customizations? The Oracle Apex interactive grid API is your friend. This session covers the essential elements of the APEX interactive grid API that most interactive grid developers need to know, or *should* know to build effective, customized interactive grids.

We will detail and demonstrate the most commonly used parts of the grid API, with simple examples so attendees can absorb the basics and understand how to adapt to their own requirements. Topics include the grid widget in general, how to access and process data in the model, and how to tie these concepts into dynamic actions, validations and custom processes. The session will emphasize basics and best practices, using the APIs where needed to achieve business requirements. PL/SQL developers looking to become more comfortable with JavaScript grid customizations will feel right at home. Gain the knowledge you need to adapt interactive grids for your end users.

Use the innovative Dynamic Oracle Performance Analytics (DOPA) approach that relies on big data and advanced analytical techniques to analyze and improve Oracle Database performance. The approach discussed in this presentation is accessible and easy to use, but more importantly it represents a step-change paradigm shift away from traditional methods. Instead of relying on a few hand-picked, favorite metrics, or wading through multiple specialized tables of information such as those found in an automatic workload repository (AWR) report, you can draw on all available data, applying big data methods and analytical techniques to help you draw impactful, focused performance improvement conclusions.   The DOPA process targets the most relevant metrics for the problem interval which results in event focused and actionable intelligence on the performance issue, and insight into possible solutions.  This method improves on the typical/traditional approaches which monitor a standard set of hard coded metrics; but the traditional approaches may cause you to miss important system behavior or configuration that is relevant to the root cause of the performance problem.  The speaker will share his DOPA process and code.

One of the most common SQL Tuning problems is when the Oracle cost-based optimizer misestimates the expected number of rows that will be returned from an execution plan row source operation. This presentation delves into uncharted waters to help attendees understand strategies for dealing with cardinality misestimates.

Understanding how applications and clients communicate with databases is key to succeessful deployments. This presentation teaches the basics of the Oracle Server networking by discussing the various components of OracleNet. We will discuss the various ways to connect to the database through the network and some tips to help simplify many of the challenges Oracle networking can pose.

Oracle Databases are a target of cyber-attacks by hackers looking to obtain sensitive data such as credit card numbers and personally identifiable information used in identify theft.  Even though databases are not externally accessible, they are still a target as most cyber-attacks penetrate the network perimeter and look for high value targets within your internal…

Oracle Database 19c is now available, and it builds on Oracle Databases 19c and 12cR2. This session explores how developers and DBAs can work together to start using 10 of the top ( and mostly free)  features that make it easier to get the job done.

Learn about the essentials for becoming comfortable with, even fluent in, the use Oracle JET charts in APEX. Whether you use APEX for standalone applications, to extend on-prem or Cloud applications, the same charting features apply. Start using them! Data visualization is “in” – so attend and become comfortable with adopting JET charts now.