Implementing RAC with Data Guard?  Maybe on an Exadata or ODA?  Ever wonder: how do I quickly and easily check the status of all of my databases?  How do I easily report on space usage by database in ASM?  Should I configure Data Guard to use the SCAN listener?  Where and how should I run…

With great consolidation comes great responsibility. Oracle 12.2 Multitenant allow administrators the power for high consolidation density, improved isolation, ease of management, and faster deployment. This session will explore several different use case scenarios and configurations where Viscosity has implemented Oracle 12.2 Multitenant along with virtualization technologies to achieve high consolidation density while still maintaining strong…

With great consolidation comes great responsibility. Oracle 12.2 Multitenant allow administrators the power for high consolidation density, improved isolation, ease of management, and faster deployment. This session will explore several different use case scenarios and configurations where Viscosity has implemented Oracle 12.2 Multitenant along with virtualization technologies to achieve high consolidation density while still maintaining strong…

Many DBAs are faced with the task of migrating and updating older Oracle databases to newer platforms and to Oracle12c, sometimes on-premises and sometimes to the cloud.  Frequently an endian change adds additional complexity.  Outage time constraints add to the challenge. While Data Pump may seem like an obvious choice, it does introduce many issues…

Analytic functions usually improve performance and reduce complexity of SQL-queries with multi-row dependencies. But for many developers/DBA's/end-users they are still a complex and mysterious operation. This presentation will explain analytics for developers, users and DBA's. In a live demonstration, I show the audience how to build queries with analytic functions with increasing complexity. First we…

Let’s revisit the ways to programmatically load data into an on-premise or Cloud Oracle database.  Many applications need to load data from external sources as some part of the workflow. What is the best data load option for your environment and your requirements?  Is your spreadsheet data CSV or true XLSX? Are you loading CLOBs…

Let’s revisit the ways to programmatically load data into an on-premise or Cloud Oracle database.  Many applications need to load data from external sources as some part of the workflow. What is the best data load option for your environment and your requirements?  Is your spreadsheet data CSV or true XLSX? Are you loading CLOBs…

The only group of Oracle specialists that continues to stay outside of the cloud hype are server-side developers. Everybody else (from CFOs to DBAs) are frantically trying to figure out what is happening and how to survive in the rapidly changing environment. Nevertheless, developers still hope that either their DBAs are good enough or their…

Not that long ago it was so simple: if you were a developer who wanted to work with an Oracle development tool, you used Oracle Forms. Period. End of story. Now, and this is particularly true in the past couple of years, the number of Oracle development tools has grown to the point where it…

The only group of Oracle specialists that continues to stay outside of the cloud hype are server-side developers. Everybody else (from CFOs to DBAs) are frantically trying to figure out what is happening and how to survive in the rapidly changing environment. Nevertheless, developers still hope that either their DBAs are good enough or their…