Siebel Resources

Oracle:

• Siebel Bookshelf v7.5.x
• Siebel Bookshelf v7.8
• Siebel Bookshelf v8.1
• Siebel Installation Guide for Windows (v8.1) 
• Siebel Deployment Planning Guide
• (all versions)
• Oracle - Siebel licence code
• Siebel on Exadata
• PPT
• Whitepaper
• Siebel Bookshelf: Setting Oracle Database Configuration Parameters for a Siebel Upgrade
• Siebel Bookshelf: Configuring an Oracle Database for Siebel Business Applications
• Siebel Bookshelf: Installation on Windows
• Siebel Maximum Availability Architecture (Oct 2008) 
• Oracle Support Document 781927.1 (Performance Tuning Guidelines for Siebel CRM Application on Oracle Database) 

Non-Oracle:

• HelloSiebelWorld - Siebel support document
• Siebel Unleashed
• Directutor - Siebel Resouce
• Toolbox.com (on Siebel) - discussion forum
• Selectorweb - Website about Siebel, Siebel brief introduction and learning
• Siebel Essentials
• Siebel to Microsoft Dynamics?
• Microsoft official paper
• Information Week's report
• Siebel config best practice 
• Tech note on high performance file system
• Siebel Explored
• 
  

Recommended Database Parameters for Oracle 11g

sqlplus / as sysdba

alter system set OPTIMIZER_INDEX_CACHING=0 scope=both sid='*';

alter system set OPTIMIZER_MODE=ALL_ROWS scope=both sid='*';

alter system set QUERY_REWRITE_INTEGRITY=enforced scope=both sid='*';

alter system set STAR_TRANSFORMATION_ENABLED=false scope=both sid='*';

alter system set OPTIMIZER_INDEX_COST_ADJ=1 scope=both sid='*';

alter system set OPTIMIZER_DYNAMIC_SAMPLING=1 scope=both sid='*';

alter system set QUERY_REWRITE_ENABLED=false scope=both sid='*';

alter system set WORKAREA_SIZE_POLICY=AUTO scope=both sid='*';

alter system set STATISTICS_LEVEL=typical scope=both sid='*';

alter system set "_always_semi_join"=off scope=both sid='*';

alter system set "_b_tree_bitmap_plans"=false scope=both sid='*';

alter system set "_partition_view_enabled"=false scope=both sid='*';

alter system set "_gc_defer_time"=0 scope=both sid='*';

alter system set "_no_or_expansion"=false scope=both sid='*';

alter system set "_optimizer_max_permutations"=100 scope=both sid='*';

Logon trigger at Oracle 11g

CREATE OR REPLACE TRIGGER om_trig

AFTER LOGON ON DATABASE

BEGIN

execute immediate 'alter session set optimizer_mode=FIRST_ROWS_10';

execute immediate 'alter session set "_hash_join_enabled"=FALSE';

execute immediate 'alter session set "_optimizer_sortmerge_join_enabled"=FALSE';

execute immediate 'alter session set "_optimizer_join_sel_sanity_check"=TRUE';

execute immediate 'alter session set "_optim_peek_user_binds"=FALSE';

END;

Check if any profile created:

select name, SQL_TEXT, LAST_MODIFIED, DESCRIPTION, STATUS from dba_sql_profiles order by 1;

NAME                           STATUS

------------------------------ --------

SYS_SQLPROF_02439565c4e30004   ENABLED

SYS_SQLPROF_01439a8134330002   ENABLED

SYS_SQLPROF_01439a8133630001   ENABLED

SYS_SQLPROF_01439a8132a40000   ENABLED

SYS_SQLPROF_014394d974750000   ENABLED

SYS_SQLPROF_024394ea25d70001   ENABLED

SYS_SQLPROF_02436761e6070000   ENABLED

SYS_SQLPROF_024394f2cbfd0003   ENABLED

To disable a SQL profile:

exec dbms_sqltune.alter_sql_profile('SYS_SQLPROF_01439a8132a40000', 'STATUS', 'DISABLED');