Tag: Database

Database In-Memory is an unprecedented breakthrough in-memory columnar technology providing massive performance gains for analytical and mixed workloads, with the ability to process data in real-time at the rate of billions of rows per second. In this session we will look at the Oracle in-memory technology portfolio, the motivation and underpinnings behind in-memory database technology…

Multitenancy at Wells Fargo Bank Wells Fargo Bank shares its experience with implementing Oracle Multitenant as part of a large-scale Oracle Exadata deployment. The Oracle Multitenant option is a vital component that will enable Wells Fargo to reach desired consolidation densities. The session covers data-gathering and planning for consolidation, consolidation selection criteria, impacts to existing…

Multitenancy at Wells Fargo Bank Wells Fargo Bank shares its experience with implementing Oracle Multitenant as part of a large-scale Oracle Exadata deployment. The Oracle Multitenant option is a vital component that will enable Wells Fargo to reach desired consolidation densities. The session covers data-gathering and planning for consolidation, consolidation selection criteria, impacts to existing…

Multitenancy at Wells Fargo Bank Wells Fargo Bank shares its experience with implementing Oracle Multitenant as part of a large-scale Oracle Exadata deployment. The Oracle Multitenant option is a vital component that will enable Wells Fargo to reach desired consolidation densities. The session covers data-gathering and planning for consolidation, consolidation selection criteria, impacts to existing…

Multitenancy at Wells Fargo Bank Wells Fargo Bank shares its experience with implementing Oracle Multitenant as part of a large-scale Oracle Exadata deployment. The Oracle Multitenant option is a vital component that will enable Wells Fargo to reach desired consolidation densities. The session covers data-gathering and planning for consolidation, consolidation selection criteria, impacts to existing…

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…

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…