Reflections of a DBA.png

    Reflections of a DBA

    By Michael Abbey

    Editor’s Note: If you ever wonder about why some things are the way they are in the database environment, or if you’re new to Oracle and have the privilege of starting with versions that have GUI friendly tools, this story from Michael Abbey might help with that. It is a view into several versions of Oracle and development along the way. Change actually comes at us faster now, and IOUG has been supporting the Oracle users community all these years. Enjoy this perspective and history lesson from Michael and how a life of a DBA might be changing but still going strong. — Michelle Malcher

    It’s mid-1986, and this kid is out of college with his computer programming diploma and other credentials. I have just spent six months enjoying yet more COBOL/JCL programming on Amdahl mainframes with CICS and TSO … yes, dinosaur acronyms from the 1980s. I get hooked up with a local consulting group called Ourscan. 

    READ MORE

               
    Exadata_SecondaryImage.png

    Exadata Storage Maintenance 
    By Andrew Meade 

    Managing an Exadata Server is a great way to jump from being a normal DBA to great DMA (Database Machine Administrator), and get into the nitty-gritty details of storage administration. This tip will share some Exadata Storage maintenance jobs, how to manage them and at which logs to look.

    I support a very I/O intensive Data Warehouse that builds every night. It is fairly consistent, except when impacted by two Exadata Storage maintenance jobs: Exadata Battery Learn Cycle and the Exadata Hard Disk Scrubbing. Note that Exadata Hard Disk scrubbing is different than ASM disk scrubbing.

    READ MORE

     

    Sharding Database Infrastructure-AuthorImage.jpg

    Sharding Database Infrastructure Horizontally
    By Nassyam Basha, Data Intensity | Simon Pane, Editor 

    This article is the final installment in a three-part series on the topic of sharding. Part one provided background and reviewed in depth the architecture of Oracle Sharding and the various technical components. Part two focused on prerequisites and the initial deployment steps.

    The main purpose of this article is to test and demonstrate that the data is indeed being distributed across the shards. We will first create a sharded table and then see how the “chunks” will be sharded across all the shard databases. And finally, we will review the various logs which are useful for troubleshooting.

    READ MORE


    Features
    In-depth, peer-reviewed articles from recognized authorities in Oracle technology.

     

    Departments
    Notes from the editor, along with regular columns, like DBA-201, Middleware, Data Evolution, and more

     

    IOUGenius
    Unique insights from the IOUG community.

     

    IOUG Press Corner
    The latest from Apress and IOUG designed to provide the very best in detailed, need-to-know information for the Oracle professional.

     

    Contributors
    Get to know the authors of SELECT.


    Copyright © 2018 Communication Center. All Rights Reserved
    All material, files, logos and trademarks within this site are properties of their respective organizations.
    Terms of Service - Privacy Policy - Contact

    Independent Oracle Users Group
    330 N. Wabash Ave., Suite 2000, Chicago, IL 60611
    phone: 312-245-1579 | email: ioug@ioug.org

    IOUG Logo

    Copyright © 1993-2018 by the Independent Oracle Users Group
    Terms of Use | Privacy Policy