Skip to main content

Software  >  WebSphere  >  WebSphere Portal Family  >  

JCR Database size is not reducing in Oracle DB after deleting large libraries in Web content Management 6.1.0.x
 Flash (Alert)
 
Abstract
JCR Database size is not reducing in Oracle DB after deleting large libraries in Web content Management 6.1.x
 
Content
JCR Database size is not reducing in Oracle DB after deleting large libraries in Web content Management 6.1.x. ORACLE DB may show few large (few MBs or GBs) LOBSEGMENTs in JCR tablespace. In order to resolve this issue. please do as below.
(1) Make sure that libraries in JCR database have been completely deleted. Engage IBM Support in order to get few tools to check if the libraries are deleted successfully from JCR database or not. Once this is confirmed , check the size of the LOBSEGMENTs in JCR tablespace is reduced or not.. If the size of these LOBSEGMENTs is still not reduced , follow steps provided below.

(2) These LOBSEGMENTs could belong to one or more user tables in JCR. So, there could be a situation where the contents are still stored in the JCR database. In order to see which table is has such a large segment , execute following query:

select owner||'.'||table_name "TABLE", column_name, segment_name from all_lobs where segment_name='SYS_LOB.....'

In above SQL statement , specify the complete name of the SYS_LOB having large size. for example , 'SYS_LOB0000129688C00025$$'

(3) Now, the next step is to reclaim the space in LOBSEGMENT used by the table. Run below query to move the lob object to the same tablespace,

alter table <JCRSCHEMA_NAME>.<TABLE_NAME> move lob (<COLUMN_NAME>) store as (tablespace <JCRTABLESPACE_NAME>).

where , replace following values to as mentioned below,

<JCRSCHEMA_NAME> = schema name of JCR DB.
<TABLE_NAME> = table name thats returned by query executed on step 2 , having the large Segment.
<COLUMN_NAME> = segment name thats returned by query executed on step 2
<JCRTABLESPACE_NAME> = tablespace name used by JCR database.

This way Oracle DB will reassign the space to this object.

(4) Check the size of the LOBSEGMENT and confirm if it has reduced or not. If the size of large LOBSEGMENT is reduced , repeat the above steps for all the tables having large LOBSEGMENTs.

Note : Its recommended to take full database back before running above steps. Please take help from Database Administrator in order to complete above steps..
 
 
 

Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.
Rate this page
Please take a moment to complete this form to help us better serve you.
This material provides me with the information I need.




This material is clear and easy to understand.




Did the information help you to achieve your goal?
What updates, improvements, or related information would you like to see in this document?
Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.
Input the verification number to submit feedback:
Document information
 Product categories:
 Software
 Enterprise Content Management
 Content Management
 Lotus Web Content Management
 Database
 Operating system(s):
  AIX, HP-UX, Linux, Solaris, Windows, i5/OS
 Software version:
  6.1, 6.1.0.1, 6.1.0.2
 Software edition:
  Java edition
 Reference #:
  1403128
 IBM Group:
 Software Group
 Modified date:
 2009-09-22

Translate My Page
 
 

Rate this page

Help us improve this page. Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.