Delphix Products

 View Only

  • 1.  Query on Masking performence

    Posted 03-10-2020 01:08:00 AM
    ​Hi Team

    I have query on like, we have 100 GB database where we configured masking with 4 algorithms and its taking more than 8 hours to run the masking Job, any suggestions on this issue like how to improve the performance ? Does any one have encountered such scenario ?


    ------------------------------
    Karteek Muthyala
    Information Security Engineer
    Wells Fargo
    ------------------------------


  • 2.  RE: Query on Masking performence

    Posted 03-10-2020 03:53:00 AM
    Hi Karteek,

    Can you please provied more details on the following :

    1/ Database type
    2/ Number with columns type and tables you are masking
    3/ Any index, constraints or triggers on the subject column(s)
    4/ Masking job configuration and used algorithms

    Regards,

    Mouhssine

    ------------------------------
    Mouhssine SAIDI
    Community Member
    Delphix Community Members
    ------------------------------

    Original Message


  • 3.  RE: Query on Masking performence

    Posted 03-10-2020 01:49:00 PM

    100 GB / 480min = 0.2 GB / min
    This number seems to be a bit slow.
    General advise is to drop indexes/triggers/constraints on masked columns and make sure an appropriate logical key is being used (indexed!).

    Please provide details :

    1/ Database type
    2/ Number of columns and tables you are masking
    3/ Any index, constraints or triggers on the subject column(s)
    4/ Masking job configuration and used algorithms

    Oracle specific optimisations:

    https://community.delphix.com/blogs/krishna-kapa1/2019/07/26/delphix-masking-best-practices1?CommunityKey=4e2d7f5c-8842-432b-86ec-1bd8b6f628d7&tab=



    ------------------------------
    Tino Pironti
    Technical Services
    Delphix
    ------------------------------

    Original Message


Related Content