Data Loss Prevention

 View Only

  • 1.  DLP Oracle Database Re-Index

    Posted Jan 30, 2017 12:23 PM

    Hi,

    I need to re-index the database for DLP  due to some slowness in the Enforce GUI. We had upgraded to 14.6, and after that we executed the reclaim LOB_Tablespace maintenance script. The script was fine but since then the Enforce GUI is very slow. When I turn off the dashboard it gets better so I'm sure that this slowness is related to Oracle. 
     
    I appreciate any information about how to re-index DLP database.
     
    Thanks,
    Laszlo


  • 2.  RE: DLP Oracle Database Re-Index

    Posted Jan 30, 2017 04:57 PM
    Hi, I dont believe incidents are indexed, if the screens with dashboards/incident reports are what is slow, then you are likely going to need to clean up your incidents to improve performance. If you have millions of incidents, the database is queried each time you load a page with these dashboards/reports which is causing the slowness. Also ensure the database datafiles arent set to extend at too small of an increment when the its current capacity is reached, this may also affect database performance.


  • 3.  RE: DLP Oracle Database Re-Index

    Posted Feb 02, 2017 03:35 AM

    Hi,

    There are ~200.000 incidents so that's not the problem. Before I ran the the Reclaim_LOB_Tablespace script it had worked fine. I'm not sure that the script change anything in the datafiles properties.

    We have 8 LOB datafiles, each of them added with the following command:

    ALTER TABLESPACE "LOB"
    ADD
    DATAFILE "FILE PLACE AND NAME" SIZE 138240K
    REUSE AUTOEXTEND
    ON NEXT 10240K MAXSIZE 32767M;

    regards,

    Laszlo