Skip navigation
All Places > Products > RSA Identity Governance & Lifecycle > Blog > 2020 > October
2020

There are 3 things that you can do to help maintain the performance of the database.  There are SQL statements which are influenced by the amount of data in the database.  By removing data that is not actively needed by the system or the business this will help maintain consistent performance with the database.


More info can be found on this webinar, with a video discussion on these topics:

 

Part 1: Data Purging

Introduced in 7.0.1

It removes data that is no longer required for any processing by the system. 

The run will appear in the Monitoring page and will have a log of the information purged. It will also highlight if it was able to complete all the steps of the purge.

 

Action: Confirm this job is scheduled

This can be done by checking:

  • Login as a user with Admin privileges,
  • Go to Admin / System menu
  • Go to the Data Management tab
  • Confirm Purging is enabled, as per the screen shot below

 

Once the job is running confirm that it can complete all steps before hitting the time limit.  It may take multiple runs to complete all steps with older databases.

 

 

 

Part 2: Archive Purge

Introduced in 7.1.0

This is a process that is manually initiated and should be planned by the business to be able restore data in the event of an audit.  It removes objects from the system which has reached an End of Life in the timeframe specified. 

 

An archive run will appear in the Monitoring page and will have a log of the steps required for it to be completed.

 

Once the archive has been successfully completed it will no longer appear in the UI, but it may still be in the database.  The Data Purging process will then start to remove the data during its weekly run.

 

How to apply Archiving:

  • Login as a user with Admin privileges,
  • Go to Admin / System menu
  • Go to the Data Management tab
  • Press the "+Create" button as shown in the image below.

 

 

Part 3: Database Maintenance

Purging of data from the database will result in Oracle tables and indexes to become fragmented.

The Oracle database has a feature called Segment Advisor.  This can be used to schedule a job within the database that will analyze all the Tables/Indexes in the database and identify which ones would benefit most from a rebuild which will coalesce the data.

 

We have provided a simplified access to the tool and is documented in:

  • "Database Setup and Management Guide",
    • Chapter 3. "Maintaining the Database",
      • Section "Database Segment Maintenance".

 

Action: Confirm with the DBA group maintaining the database what activity is needed.

 

For additional information see the blog: Maintaining the database for optimal performance 

More info can be found on this webinar, with a video discussion on these topics:

 

For optimal performance of our database it will require periodic maintenance of database tables and indexes.  RSA not only supports this, but encourages this as it will help maintain acceptable performance levels. 

 

The tables and indexes that need to be maintained is dependent on:

  1. What features of the application are used,
  2. The amount of information maintained,
  3. How often data changes,
  4. How much data changes. 

 

Maintaining of the these tables can be accomplished in three primary ways.


#1: Manual

In this method the Customer, typically DBA staff, will identify tables or indexes that would benefit from maintenance. 

In this scenario the DBA would then specific run commands like, but not limited to:

ALTER TABLE <TABLE NAME> SHRINK SPACE CASCADE;

This will "defragment" the table and potentially free up space used by the table to the tablespace it resides in.

 

ALTER INDEX <INDEX NAME> REBUILD;

This will rebuild the index removing any empty leaf nodes that will occur when data is deleted and updated.

 

#2: Oracle Segment Advisor

The Oracle database has an internal utility called the Segment Advisor which can help reclaim unused space.  

Link here: Managing Space for Schema Objects 

 

Using this utility it will help identify tables and indexes that could benefit from maintenance.  It will also be able to perform the operations as well. 

 

The operations will be the executions of the statements identified in the manual method.

 

RSA Supplied package

The RSA Supplied package is just an interface to the Oracle Segment Advisor as we want to leverage Oracle's expertise as the best way to identify improvements in the database for optimal performance. 

 

Documentation on how to utilize this package can be found in the:

  • "Database Setup and Management Guide",
    • Chapter 3. "Maintaining the Database",
      • Section "Database Segment Maintenance".

 

Regardless of the type of deployment (Appliance, RSA Supplied Database, Remote Database) you have all 3 options are available. 

 

Which one you use should depend on your internal database expertise and comfort level.  Also with any database maintenance it is always best to have scheduled downtime.  This would involve shutting down the RSA Identity Governance and Lifecycle system to avoid any resource contention problems.

DONT FORGET - please register for the upcoming septmber Webinar: 

RSA Identity Governance & Lifecycle Webinar - Wed Oct 28th 2020 

 

Our goal of this newsletter, is to help share more information about what's happening and key things for you to be aware of, specifically for RSA Identity Governance and Lifecycle.

 

This is a monthly release, so you can expect a new Newsletter at the start of each month.

 

Current Edition:

  • Issue #13, October 2020: See attachment below 
    • Note:you should be able to view this in a browser, or download/preview the document too. Any issues/questions, just reply to this!

Previous Newsletter Editions:

 

Previous Webinar Recordings: (Note: you must login to view these)

 

Summary here: RSA Identity Governance and Lifecycle - Monthly Webinar Summary 

Filter Blog

By date: By tag: