Delphix Masking: Optimizing my current configuration

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • Answered
Hi all,

Is there a faster configuration to improve my current setup below?





Regards,
Mark
Photo of Mark Aaron Corrales

Mark Aaron Corrales

  • 120 Points 100 badge 2x thumb

Posted 9 months ago

  • 0
  • 1
Photo of Hims

Hims, Employee

  • 1,936 Points 1k badge 2x thumb
Hi Mark,
You can do the following:
1. Increase memory ( default 1024) to 16382 or higher
2. Check disable constraints/triggers and drop indexes ( make sure to have permissions)

also ensure
1. Logging is turned off on the tables.
2. Enough undo space in DB ( ~5Gb)

--Hims
(Edited)
Photo of Mark Aaron Corrales

Mark Aaron Corrales

  • 120 Points 100 badge 2x thumb
Thanks Hims! Also, as a good to know. Delphix doesn't support unmasking databases right?
Photo of Hims

Hims, Employee

  • 1,936 Points 1k badge 2x thumb
Hi Mark,
You are welcome.
Data masking in principle is a one-way activity which is the bedrock of its security. However if you need to look at original production data ( assuming you have the entitlements), using Delphix you can provision a copy of production data in minutes irrespective of its size.

For some use cases Delphix does provides a 'Tokenziation' feature where the token can be 'Re-identified'.

--Hims
Photo of Hims

Hims, Employee

  • 1,936 Points 1k badge 2x thumb
Yes, All algorithms are irreversible with exception of tokenization which can be re-identified.
(Edited)