Plan for Oracle - Portal v6.1

Plan for Oracle

+
Search Tips | Advanced Search

Consider...

DB names
Database space needed
Whether database version is supported

The Java Content Repository (JCR) stores data for Personalization and Web Content Management.
WebSphere Portal can be configured to use a single shared database if different database users are chosen for each database listed below.
A single database configuration can significantly reduce consumption of system resources.
Using separate table spaces for all databases listed below can improve scalability and performance.

Application DB name Space required
WebSphere Portal release
comm
cust
Used for the portal (at a minimum) or to hold all data. Stores information about user customization, such as pages, and user profile and login information. Depends on the number of users and portal objects, such as pages and portlets.
Personalization,WCM
Contains documents, personalization rules, personalization campaigns, and document library configuration information.
jcrdb Depends on the number and size of Personalization rules and campaigns, and the number and size of items and elements created in WCM .
Feedback
Contains the information that is logged by your Web site for analysis of site activity and generating reports.
fdbkdb Depends on the amount of traffic to the site. The amount of data that is logged per login-enabled page can vary.
LikeMinds
Contains the recommendations to be displayed to users when their interactions with your Web site have been analyzed and predictions generated.
lmdb Depends on the amount of traffic to the site.

Database users
All table spaces are approximately 2.8 GB by default. The size increases with the use of Java Content Repository.

Application DB user Function
WebSphere Portal releaseusr
communityusr
customizationusr Core user who owns approximately 230 tables, used for WebSphere Portal core objects, which includes tables that store the user customizations made to pages.
Java Content Repository jcr Java Content Repository user who owns at least 1130 tables. The number could be higher depending on usage.
Feedback feedback Feedback user who owns approximately 50 tables used for logging site and personalization usage.
LikeMinds lmdbusr LikeMinds user who owns approximately 15 tables used to hold the Web site usage analysis routines and recommendation text.

Parent topic
Planning for databases

Related information

Oracle product documentation

Application	DB name	Space required
WebSphere Portal	release comm cust	Used for the portal (at a minimum) or to hold all data. Stores information about user customization, such as pages, and user profile and login information. Depends on the number of users and portal objects, such as pages and portlets.
Personalization,WCM Contains documents, personalization rules, personalization campaigns, and document library configuration information.	jcrdb	Depends on the number and size of Personalization rules and campaigns, and the number and size of items and elements created in WCM .
Feedback Contains the information that is logged by your Web site for analysis of site activity and generating reports.	fdbkdb	Depends on the amount of traffic to the site. The amount of data that is logged per login-enabled page can vary.
LikeMinds Contains the recommendations to be displayed to users when their interactions with your Web site have been analyzed and predictions generated.	lmdb	Depends on the amount of traffic to the site.

Application	DB user	Function
WebSphere Portal	releaseusr communityusr customizationusr	Core user who owns approximately 230 tables, used for WebSphere Portal core objects, which includes tables that store the user customizations made to pages.
Java Content Repository	jcr	Java Content Repository user who owns at least 1130 tables. The number could be higher depending on usage.
Feedback	feedback	Feedback user who owns approximately 50 tables used for logging site and personalization usage.
LikeMinds	lmdbusr	LikeMinds user who owns approximately 15 tables used to hold the Web site usage analysis routines and recommendation text.