Tag: IOUG

Original Broadcast: July 18, 2017 VMware environments are complex—with custom VMs, multiple subnets, and various virtual appliances. Traditionally, it takes months to “migrate” a VMware virtualized enterprise application to the public cloud. Oracle Ravello Cloud Service has changed all that. In this session, you will not only hear an overview of Oracle Ravello Cloud Service,…

Before Oracle introduced dual format memory architecture, it was very challenging to find the best approach to accelerate the performance of OLAP and OLTP in the same database. We witnessed two types of DBMS in the market, columnar oriented and row-major oriented. Columnar oriented DBMS is treated as a proven practice for traditional Data Warehouse, however the pure columnar format is not suited for the real time analytics demanding on high volume transactional data. The traditional row-major DBMS is suited for OLTP workloads, however to retrieve high performance analytics, it requires analytic indexes, such as Oracle bitmap indexes to achieve this goal. Additionally, the overhead of index maintenance is expensive and bitmap indexes are not recommended for high transactional tables. The new Oracle 12c In-Memory option brings the dual format memory structure into one single database. The mixed OLTAP solution combining with the rapid advancement of hardware system can bring the data processing to a dramatic fast speed and a much higher scalability.

Before Oracle introduced dual format memory architecture, it was very challenging to find the best approach to accelerate the performance of OLAP and OLTP in the same database. We witnessed two types of DBMS in the market, columnar oriented and row-major oriented. Columnar oriented DBMS is treated as a proven practice for traditional Data Warehouse, however the pure columnar format is not suited for the real time analytics demanding on high volume transactional data. The traditional row-major DBMS is suited for OLTP workloads, however to retrieve high performance analytics, it requires analytic indexes, such as Oracle bitmap indexes to achieve this goal. Additionally, the overhead of index maintenance is expensive and bitmap indexes are not recommended for high transactional tables. The new Oracle 12c In-Memory option brings the dual format memory structure into one single database. The mixed OLTAP solution combining with the rapid advancement of hardware system can bring the data processing to a dramatic fast speed and a much higher scalability.

Original Broadcast: June 12, 2017 Oracle 12c introduced new Disaster Recovery capabilities such as Active Data Guard Far Sync, a SYNC/ASYNC cascading feature that uses a lightweight intermediary node (Far Sync). The talk will describe our experience tuning Far Sync for maximum performance and minimal resource requirements. We will provide detailed description of how configuration…

Original Broadcast: June 8, 2017 Version management of the PL/SQL source code has always been challenging. Database programmers lack the tools and utilities that make version control easy for developers who code with file based programming languages such as Java and JavaScript. In fact, this is one of the primary reasons why large software teams…

Original Broadcast: June 8, 2017 Version management of the PL/SQL source code has always been challenging. Database programmers lack the tools and utilities that make version control easy for developers who code with file based programming languages such as Java and JavaScript. In fact, this is one of the primary reasons why large software teams…

Original Broadcast: June 8, 2017 Version management of the PL/SQL source code has always been challenging. Database programmers lack the tools and utilities that make version control easy for developers who code with file based programming languages such as Java and JavaScript. In fact, this is one of the primary reasons why large software teams…

By Rich Niemiec, Viscosity North America  ◾ Michelle Malcher, Editor This is part one of an article series focused on new Oracle 12c R1 and R2 new features that I cover in my new book, Oracle 12c Release 2 Performance Tuning Tips & Techniques (Oracle Press). This first part will cover upgrade paths, INMEMORY_SIZE, In-Memory Column…

By Rich Niemiec, Viscosity North America  ◾ Michelle Malcher, Editor This is part one of an article series focused on new Oracle 12c R1 and R2 new features that I cover in my new book, Oracle 12c Release 2 Performance Tuning Tips & Techniques (Oracle Press). This first part will cover upgrade paths, INMEMORY_SIZE, In-Memory Column…

Original Broadcast: May 25, 2017 Hey ZFS Storage Admins! Are you running the latest 8.7 OS with your ZFS Storage Appliance? Are you wondering if your current ZFS Storage drives, enclosures, controllers, cards and other hardware components will work with the newest release? Well, if you are... join us in this exhilarating webcast to learn…