Enable Full Text Search on Oracle UCM 11g

• Enable Full Text Search on UCM a. Login to the UCM console as weblogic
  b. Access the Admin Server
  c. General Configuration
  d. Add the following entry
  i. SearchIndexerEngineName=OracleTextSearch e. Bounce the content server

• Disabling Full-Text Indexing

  if You might want to disable full-text indexing , for example, you want to conserve file space or if you do not require full-text searching for specific content types. 
  To disable full-text indexing on specific files:
  1. Define a file format in the Configuration Manager screen named application/noindex.
  2. Enable the Allow Override Format on Check In setting from General Configuration page.
  3. When a user checks in a file that they do not want to be indexed, they should select the application/noindex format. This applies to standard files, batch loads, and archived revisions.

              ** Even if you disable full-text indexing, metadata is still indexed.

Shrink temp tablespace size

Shrink temp tablespace size into Oracle DB 10g/11g:

1- Create anther temporary  tablespace 'temp2'

SQL> CREATE TEMPORARY TABLESPACE temp2 TEMPFILE 'D:\app\oradata\temp2_01.dbf' SIZE 5M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE unlimited EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

2. Move default Database temporary  tablespace to 'temp2'

SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp2;

3. Make sure No sessions are using your Old 'temp' tablespace

 SQL> SELECT USERNAME, SESSION_NUM  FROM V$SORT_USAGE; 

       If the result contains any rows then your need to find the SID from the V$SESSION view, using SESSION_NUM from previous result set.

SQL> SELECT SID, SERIAL#, STATUS FROM V$SESSION WHERE SERIAL#=SESSION_NUM;
       
     Kill these sessions:

SQL> ALTER SYSTEM KILL 'SID,SERIAL#' IMMEDIATE; 

4. Drop 'temp' tablespace

DROP TABLESPACE temp INCLUDING CONTENTS AND DATAFILES;

5. Recreate Tablespace 'temp'

SQL> CREATE TEMPORARY TABLESPACE temp TEMPFILE 'D:\app\oradata\temp01.dbf' SIZE 256M REUSE AUTOEXTEND ON NEXT 128M MAXSIZE unlimited EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;


6 Move Database temporary tablesapce, back to new 'temp' tablespace

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp;

7. Drop tablespace 'temp2'

DROP TABLESPACE temp2 INCLUDING CONTENTS AND DATAFILES;