How to Make Siebel CRM Run Fast – Looking for input for C’08 Presentation - Siebel Technology(Archived)

Hi All,
We are giving a presentation on Siebel performance at Collaborate ’08 in April and wanted to seek some input on topics you think should be covered and/or any performance tips/techniques we don’t know about. Since we earn our living doing upgrades and making Siebel run fast we have a pretty good handle on this but still would appreciate any input or ideas you might have to make this presentation even better for Oracle’s customers.
Thanks in advance to anyone who posts a response. We will be sure to give proper credit to anyone who suggests anything that we end up incorporating into our presentation.
R
Robert Ponder
Lead Architect and Director
Ponder Pro Serve
cell: 770.490.2767
fax: 770.412.8259
email: rponder#ponderproserve.com
web: www.ponderproserve.com 

Robert,
It would be good to dedicate a section on Siebel Order Management and the performance hits most implementations take in this area and proactive ways to address the pain points related to application performance. For example, there are lots of user properties on applets, BCs, etc. that are based on specialised classes in the OM area. If a particular implementation is not using a specific functionality, you can talk of making them inactive in a bid to improve the performance.
Hope the above provide you some pointer.
-Soumen Saha

Related

Can someone share Siebel CRM 8.0 implementation project Plan with me?

We are new to Siebel CRM 8.0, currently using Siebel CRM On Demand in our organization, we also have several implementation experience of Oracle Ebusiness suite modules, We are planning to implement Siebel CRM 8.0 for HP UX in our organization, i just wanted to know how much time will take to complete the project from OS Installation, Siebel crm 8.0 Installation , Patch fixing, Configuration, user training to Go Live, it will be great if some body can share his/her project plan including phases so we can estimate the timeline. 
Hi Khurram,
Project plans and timelines vary too much to be able to give you an answer. So much of this depends on things like how much you plan to customize Siebel, how many interface you have to integrate with, etc.
The fastest I have seen can be measured in weeks. The longest measured in months (even > 12 months in some cases).
Even the exact same Siebel implementation can vary in timeline and team size required from organization to organization.
Please call if you want to discuss,
R
Robert Ponder
Lead Architect and Director
Ponder Pro Serve
cell: 770.490.2767
fax: 770.412.8259
email: rponder#ponderproserve.com
web: www.ponderproserve.com 
The answer to your question is highly dependent on what version of Siebel you are on now, and how much customization has been done to the application. Eagle Creek provides support in this area, and we do lots of upgrade out of our US-Based Siebel Project Center. A good estimate would be from about 1000 hours on the low end (about a $50K project for us) to about 3000 hours (About a $150K project for us).
Please let me know if you need any help with this, and we can arrange a time to connect via conf. call and review your needs.
John Beesley
952-230-2062
jbeesley#eaglecrk.com

SQL Record Wins Over Oracle Real Application Testing at Government Customer

Hi All,
Wanted to post this here in case other customers are experiencing Oracle performance issues as part of an upgrade to 11g or 10g. Every Siebel customer we know who has upgraded their DBMS has experienced some type of performance problem they need to fix and this customer was no expectation.
This customer was looking for a solution to play back production SQL for performance tuning purposes. They considered Oracle Real Application Testing (RAT) but decided to go with PPS SQL Record since there were no licensing fees for using SQL Record.
In addition SQL Record also allowed this customer to identify all distinct SQL issued by the application based on buscomp used and Siebel user. Since ADSI was being used, all users had the same login. Real Application Testing could not overcome either of these challenges.
If you are upgrading your Oracle DBMS used for Siebel please be sure to test performance. Regardless of which product you use please use one of them.
Take Care,
R
Robert Ponder
Lead Architect and Director
Ponder Pro Serve
cell: 770.490.2767
fax: 770.412.8259
email: rponder#ponderproserve.com
web: www.ponderproserve.com

Siebel tuning from DBA point of view...

Yesterday have a Siebel application team ask me on how to tune their production system , as a system dba we really know nut about their appl.
So we ask them to get us their query which slow on the process and we generate explain plan & trace to them to check by themself.
Again they come back to ask to give recommendation on which table to create index!!!! and we again ask them to check on the plan to give to them and seek for full table scan and understood from their business logic whether how is the data / logic on the tables .
I don't believe there are quick fix on performance tunning for Siebel .
May i know how you all handle this kind of request ? 
Hello,
we can help you there....some of us are former Siebel soft. engineers that built some of the siebel out-of-the-box functionalities and were part of the siebel's performance team that optimized/tuned the siebel 7.0,7.5,7.7,7.8,8.x...along w/ oracle 8,9,10,11, sqlsvr2k, sqlsrvr2k5, db2udb, iplanet, apache, iis,....custom c#, java code.....we have done this for siebel customers for ~11years now.
And to leverage this expertise.. we have built a ------Siebel-specific Monitoring and troubleshooting Toolset ---- that can help you secure your production system (for all Tiers...from DB to siebel app and web server layers)
Feel free to register to the online videos or contact us for a live demo...look forward to hearing back from you,
Regards,
Yannick Germain
Principal
GermainCg
San Francisco, CA, USA
Cell: +1-415-606-3420
Fax: +1-415-651-9683
yannick#germaincg.com
http://www.germaincg.com 
Hi,
As long as your DBMS is Oracle you can move forward very easily. You can start with the AWR reports and even just by querying v$sql to find the SQL doing the most buffer gets. We often just monitory v$session for active sessions and note the current SQL id.
Oracle makes tuning Siebel performance very simple.
BTW, we are presenting a session on optimizing Siebel for Oracle CBO at Collaborate ’09 in Orlando in May.
If you are running Siebel with Oracle you should follow the PPS init.ora recommendations and statistics strategy. We have nearly 10 customers we have helped with Oracle 10g/11g CBO optimization. All have very good Oracle performance.
You can also talk w/ me and my team next week at the HotSos Oracle Performance Tuning conference in Dallas. We like to attend each year to learn from the CBO masters.
Robert Ponder
Lead Architect and Director
Ponder Pro Serve
cell: 770.490.2767
fax: 770.412.8259
email: rponder#ponderproserve.com
web: www.ponderproserve.com 
Hi,
As long as your DBMS is Oracle you can move forward very easily. You can start with the AWR reports and even just by querying v$sql to find the SQL doing the most buffer gets. We often just monitor v$session for active sessions and note the current SQL id.
Oracle makes tuning Siebel performance very simple.
BTW, we are presenting a session on optimizing Siebel for Oracle CBO at Collaborate ’09 in Orlando in May.
If you are running Siebel with Oracle you should follow the PPS init.ora recommendations and statistics strategy. We have nearly 10 customers we have helped with Oracle 10g/11g CBO optimization. All have very good Oracle performance.
You can also talk w/ me and my team next week at the HotSos Oracle Performance Tuning conference in Dallas. We like to attend each year to learn from the CBO masters.
Robert Ponder
Lead Architect and Director
Ponder Pro Serve
cell: 770.490.2767
fax: 770.412.8259
email: rponder#ponderproserve.com
web: www.ponderproserve.com 
Thank for both of your advice.
Anyhow , customer now already go back to Siebel Support team with our explain plan n statspacks.

Siebel CRM Licenses

I would like to find out, how is the licensing in Siebel calculated? I am trying to understand how many users in my company will need license and how do you calculate that.
We will be implementing Siebel CRM Public Sector 8.1..
Thanking you in advance
Samkelo 
Hey Samkelo,
Siebel License has no effect on the number of users allowed. If you wish to find out then the only way to do so is from the Application Server itself. Siebel License only activates screens and functionalities in Siebel. 
Please ignore the previous post – it is wrong.
Siebel is licensed by the number of users normally. When I worked at Siebel and sold Siebel that was the norm. You can also get a enterprise license but these are expensive.
Best to talk w/ Oracle about this.
R
Robert Ponder
Lead Architect and Director
Ponder Pro Serve
cell: 770.490.2767
fax: 770.412.8259
email: rponder#ponderproserve.com
web: www.ponderproserve.com

Siebel 8.1. Functionality with Social Media

Hi,
I am pro actively looking for the functionality in Siebel 8.1 On premise before we upgrade from 7.7.2. I have many business requirements to integrate with Facebook etc and was informed in the past that there was OTB functionality.
I have trawled Bookshelf but cannot find anything with regards to this.
Any help much appreciated.
Rob 
Hi Rob,
Two things come to mind.
First it is pretty easy to integrate Siebel with any web site starting with version 7.5 and above. For example for one US Defense Contractor we integrated Siebel with a prominent web site that contains background information on all politically prominent folks in the US. Senators and other legislators, etc. Siebel contained the base record for these contacts and then the information from the other web site supplemented what was in Siebel. Look up "iFrame" in bookshelf and you should be able to find the details you are looking for.
Second, you could check out the Social CRM session from Oracle Open World 2010. If you were not there I can send these to you. My contact information is below.
BTW… We specialize in Siebel upgrades. One of our customers was showcased in the main Siebel upgrade session at OOW. This presentation contains important product direction information and other useful info that may interest you.
HTH,
R
Robert Ponder
Lead Architect and Director
Ponder Pro Serve
cell: 770.490.2767
fax: 770.412.8259
email: rponder#ponderproserve.com
web: www.ponderproserve.com

Categories

Resources