11.10.2019

Exadata X8M - World's Fastest Database Machine

Exadata X8M has launched during OOW 2019, and termed as world's fastest Database Machine. Let's walkthrough about new additions that has made X8M as world's fastest Database Machine.

An Exadata X8M is the industry's first DB machine integrated with Intel Optane DC persistent memory (read more about this) and 100 gigabit RDMA over converged ethernet. This will be dramatically improves the performance for all sort of workloads, such as OLTP, analytics, IoT, high frequency trading etc by eliminating the storage access bottlenecks. Persistent memory with RoCE networking can reduces IO latency significantly and boosts the performance by 2.5X.

It uses RDMA directly from the DB to access persistent memory in smart storage servers, eliminating the entire OS, IO and network software stacks. Which will deliver the higher throughput with lower latency. Also, frees CPU resources on storage server to execute more smart scan queries for analytic workloads.

Its in-memory performance with all advantages of shared storage benefits the Analytics and OLTP  workloads. Direct database access to shared persistent memory accelerates is the real game changer for application that demands large amounts of data.

For more details, read the link below:

https://www.oracle.com/corporate/pressrelease/oow19-oracle-unleashes-worlds-fastest-database-machine-091619.html




    7.16.2019

    Intermittent cellsrv crashes with ORA-07445 after upgrading to 12.2.1.1.7

    Exadata X6-2 full and half racks were patched recently with 12.2.1.1.7 Aug/2018 quarterly patch set. An ORA-07445 started to observe and the cellsrv intermittently crashing with ORA-07445 error. 

    Following error is noticed in the cellsrv alert.log:

    ORA-07445: exception encountered: core dump [0000000000000000+0] [11] [0x000000000] [] [] [] 

    The above is registered as a bug whenever cell storage is patched with 12.2.1.1.7 or 12.2.1.1.8. Therefore, if you are planning to patch your cell storage software with one of the above versions, ensure you also apply patch 28181789 to avoid cellsrv intermittently crashing with ORA-07445 error. Otherwise, you need to upgrade the storage software with 18.1.5.

    Symptom

    Customer may experience intermittent cellsrv crashes with ORA-07445: [0000000000000000+0] [11] [0x000000000] after upgrading storage cell software version to 12.2.1.1.7 or 12.2.1.1.8

    Change

    Upgrade the Storage cell software to 12.2.1.1.7 or 12.2.1.1.8

    Cause

    Bug 28181789 - ORA-07445: [0000000000000000+0] AFTER UPGRADING CELL TO 12.2.1.1.7

    Fix

    Patch 28181789 is available for 12.2.1.1.7 and 12.2.1.1.8 Storage software releases. Follow the README to instructions to apply the patch.
    ~OR~
    apply 18.1.5 and later which includes the fix of 28181789

    References;
    xadata: Intermittent cellsrv crashes with ORA-07445: [0000000000000000+0] [11] [0x000000000] after upgrading to 12.2.1.1.7 or 12.2.1.1.8 (Doc ID 2421083.1)

    6.27.2019

    Oracle Exadata X8 key capabilities summary

    Below is the summary of some of the key benefits of Exadata X8 database machine, software and hardware:

    Extreme (unmatched) performance
    According to Oracle, the new X8 database machine is capable of delivering unto 60% faster throughput performance in contrast to the earlier Exadata database machines. Having said that, you can pull a 50GB database under one second.

    Cost effective extended storage 
    Petabytes of cost effective storage with option software license. This can significantly reduce the storage cost.

    High Memory
    Can accommodate upto 28.5 of system memory. Good for heavy workload systems, such as , in-memory databases.

    Increased storage capacity
    In contrast to earlier models, X8 comes with 40% increase in disk capacity. Each X8 EF system comes with 50TB raw flash capacity. While, the X8 HC with XT storage option, it comes 160TB of raw capacity.

    High-performance connectivity
    X8 also comes with significant improvement in connectivity. It supports upto 400Gb of client connectivity over multiple 25 GB Ethernet links.

    OLTP Read/Write performance
    A full X8 rack, typically can do 6.5 million random reads and 5.7 random writes per second for a 8k DB.

    Automated features
    In addition to the above hardware improvements, it also X8 incorporates autonomous database capability. With ML and AI capabilities, the databases are auto tuned and auto maintained.

    List of technical specifications:

    • Up to 912 CPU cores and 28.5 TB memory per rack for database processing
    • Up to 576 CPU cores per rack dedicated to SQL processing in storage
    • From 2 to 19 database servers per rack
    • From 3 to 18 storage servers per rack
    • Up to 920 TB of flash capacity (raw) per rack
    • Up to 3.0 PB of disk capacity (raw) per rack
    • Hybrid Columnar Compression often delivers 10X-15X compression ratios
    • 40 Gb/second (QDR) InfiniBand Network
    • Complete redundancy for high availability

    5.31.2019

    Monitoring & Troubleshooting Oracle Cloud at Customer

    The prime advantage of cloud at customer is to deliver all cloud benefits at your data center. Oracle cloud at customer provides the same. When Oracle cloud at customer is chosen, it is Oracle who is responsible to install, configure and manage the software and hardware required to run Oracle cloud at customer. However, customers are responsible for monitoring and troubleshooting resources instantiate on Oracle cloud at customer.

    Customers are required to understand the difference between system and user-space monitoring and the tools required. The Oracle cloud at customer subscription consists of the below components:


    • Hardware and Software
    • Control panel software
    • The Oracle Advanced Support Gateway (OASW)
    • The Oracle Cloud Service

    System monitoring vs User Space Monitoring

    Typically, Oracle cloud at customer is monitored at two level:
    1. System
    2. User space
    Oracle monitors the system and the customer monitors the user space.



























    The systems or machine resources, such as : hardware, control panel and cloud services on Oracle cloud at Customer are managed by Oracle remotely using Oracle Advanced Gateway. The OAGW is only used and accessible to Oracle authorized personnel.

    The user space components consists the below:


    • Oracle Cloud accounts
    • VMs instances on IaaS or PaaS
    • DB that are provisioned within the PaaS subscription
    • Applications (Oracle or any third-party)
    Oracle manages the following hardware and software components:
    • Ethernet switches
    • Power Supplies
    • Exadata Storage Servers
    • Hypervisor running on the physical servers
    Customers can assign administrators to manage cloud accounts. Customers also are free to use any external monitoring agents to monitor user-space components.


    5.30.2019

    Why Oracle Cloud @ Customer is a good option?

    One of the major concerns moving over cloud is the security for most of the organizations. Though cloud concept is around for quite sometime, still, a majority of customers are concerned about putting their data over cloud. To gain the confidence and at the same to take full advantage of Cloud technologies, various Cloud vendors started offering cloud at customer solutions. In this blog spot, am going to discuss about Oracle cloud at customer solutions, its advantages , subscription model etc.

    Oracle Cloud at Customer delivers full advantages of cloud technologies at your data center. You subscribe hardware and software together when you go for cloud at customer option. Though Oracle does the initial setup, configuration and day-to-day system management, you still have all the advantages of security, network of your data center.

    Typically, the cloud at customer option consist of the following:


    • The hardware required to run Cloud at customer
    • Control panel software
    • The Oracle Advanced Support Gateway
    • Oracle Cloud services
     As a customer, your responsibility involves managing cloud account and subscribed services. At any time, you can check your account balance and your current Oracle Cloud at Customer service usage. It is also possible that you can view your usage by region, by service, or by a specific time period.
    To check your account balance and usage, Oracle recommends that you sign in to your Oracle Cloud Account in an Oracle data region. From there, you can view your overall account usage and Universal Credits balance. 

    In nutshell, cloud at customer brings the cloud solutions to your data center, where you can apply all the rules of your data centre while taking the full advantages of cloud solutions.