Data Loss Prevention

 View Only

  • 1.  About DLP table space

    Posted Jan 02, 2012 02:34 AM

     

    Hi all,
    I’ve installed DLP for the first time and have question about Oracle table space.
    I used template file which is Symantec provide for Oracle installation and found out ‘LOB_TABLESPACE’ are being increased very fast.
    So, I wonder that the ‘LOB01.DBF’ file is set of ‘auto extend’ option?
    And there are also ‘LOB02.DBF’ and ‘LOB03.DBF’ (It takes only 1GB space though)
    Is that right if ‘LOG01.DBF’ space gets full then it goes ‘LOB02.DBF’ space automatically and auto extend up to around 33GB?
     
    Thank you in advance and happy new year.


  • 2.  RE: About DLP table space

    Posted Jan 03, 2012 03:13 AM

    Hi,

    The LOB_TABLESPACE stores binary files, eg. attachments, uploaded files, etc for the incidents. So the more and bigger files you have, the faster it will increase. It's worth to think in advance about what files to keep with incident data, as it's not easy to shrink the LOB_TABLESPACE later. Oracle will not shrink the DBF files even if you delete the incidents, it will keep their sizes and reuse the files later.

    You can manage / add tablespace files and settings  from Oracle Enterprise Manager, see a howto here:

    http://www.dbtalks.com/UploadFile/anjudidi/771/

    Be careful with it!



  • 3.  RE: About DLP table space

    Posted Jan 03, 2012 09:54 PM

    Hi Barnabas,

    Thank you for comment.

    Do you know what will happen if 'LOB01.DBF' is full?

    I wonder if 'LOB01.DBF' is full then DLP will stores datas in 'LOB02.DBF' and 'LOB03.DBF' files.