Siebel Version: 8.0.0.8, Statement Of Issue: Facing performance when navigating in eService Application.

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:
Siebel Version: 8.0.0.8, Statement Of Issue: Facing performance when navigating in eService Application.

Symptoms:
Performance is causing when accessing following BCs:

DC ECR Request: 7 sec
Person: 2 sec
DC ECR Facility: 6 sec

All the threee BCs have in common:
1. Large number of columns queried in the sql
2. Sort order specified.

Log files:
Start time: 2011-01-18 11:20:21

Task Id: 22020428
Process Id and Thread Id: 16882 231
Process Id and Thread Id (Hex): 41f2 e7

Version: 8.0.0.8 [20430] ENU

First two lines of log:

2021 2011-01-18 11:20:21 0000-00-00 00:00:00 +0400 00000000 001 003f 0001 09 PSeServiceObjMgr_enu 22020428 16882 231 /u01/app/siebel/product/8.0.0/siebsrvr/enterprises/uatsiebelent/pcrfap01/log/PSeServiceObjMgr_enu_0021_22020428.log 8.0.0.8 [20430] ENU
TaskConfig TaskCfgParamInit 3 000000d24d3141f2:0 2011-01-18 11:20:21 The Parameters for the current task (22020428) are :

Last two lines of log:

ObjMgrBusServiceLog InvokeMethod 4 000037a74d3362d0:0 2011-01-18 11:21:25 Begin: Business Service 'Web Engine State Properties' invoke method: 'IsFrameless' at b5f0e30
ObjMgrBusServiceLog InvokeMethod 4 000037a74d3362d0:0 2011-01-18 11:21:25 Business Service 'Web Engine State Properties' invoke method 'IsFra


Longest running SQLs :

***** SQL Statement Execute Time for SQL Cursor with ID B6AD110: 3.829 seconds *****
***** SQL Statement Execute Time for SQL Cursor with ID B718470: 3.762 seconds *****
***** SQL Statement Execute Time for SQL Cursor with ID B718470: 3.037 seconds *****
***** SQL Statement Execute Time for SQL Cursor with ID B718470: 3.002 seconds *****

=================================


Log File name >>> New_Fac_PSeServiceObjMgr_ecr_enu_0029_30408760.log

Start time: 2011-01-18 11:53:59
End time: 0000-00-00 00:00:00

Task Id: 30408760
Process Id and Thread Id: 16952 47
Process Id and Thread Id (Hex): 4238 2f

Version: 8.0.0.8 [20430] ENU

First two lines of log:

2021 2011-01-18 11:53:59 0000-00-00 00:00:00 +0400 00000000 001 003f 0001 09 PSeServiceObjMgr_ecr_enu 30408760 16952 47 /u01/app/siebel/product/8.0.0/siebsrvr/enterprises/uatsiebelent/pcrfap01/log/PSeServiceObjMgr_ecr_enu_0029_30408760.log 8.0.0.8 [20430] ENU
TaskConfig TaskCfgParamInit 3 000000244d314238:0 2011-01-18 11:53:59 The Parameters for the current task (30408760) are :

Last two lines of log:

ProcessRequest ProcessRequestDetail 4 00007daa4d313276:0 2011-01-18 11:58:13 SWE Command Processor - Handle user request: SWECmd=GetCachedFrame;SWEACn=28194;SWEC=21;SWEFrame=top._sweclient._sweviewbar;
ProcessR

Longest running SQLs:
***** SQL Statement Execute Time for SQL Cursor with ID F5D8210: 6.753 seconds *****
***** SQL Statement Execute Time for SQL Cursor with ID F557EF0: 6.584 seconds *****
***** SQL Statement Execute Time for SQL Cursor with ID F557EF0: 6.580 seconds *****
***** SQL Statement Execute Time for SQL Cursor with ID F55B070: 6.576 seconds *****

EventContext >>

EventContext EvtCtxView 3 00007d9d4d313276:0 2011-01-18 11:57:02 DC ECR Amend Terms View
EventContext EvtCtxApplet 4 00007d9f4d313276:0 2011-01-18 11:57:17 DC ECR Amend Terms Conditions Applet (eService) (DCWriteRecord)
EventContext EvtCtxView 3 00007d9f4d313276:0 2011-01-18 11:57:17 DC ECR Amend Create Facilities View (eService)
EventContext EvtCtxApplet 4 00007e724d31327a:0 2011-01-18 11:57:45 DC ECR Amend Request Form Applet (eService) (WriteRecord)
EventContext EvtCtxApplet 4 00007da84d313276:0 2011-01-18 11:58:00 DC ECR Amend Request Form Applet (eService) (Submit)
EventContext EvtCtxView 3 000000524d314238:0 2011-01-18 11:58:13 DC ECR Amend Confirmation View (eService)


================


Log File name >>> Track_Req_PSeServiceObjMgr_enu_0021_22020443.log

Start time: 2011-01-18 11:27:20

Task Id: 22020443
Process Id and Thread Id: 16882 241
Process Id and Thread Id (Hex): 41f2 f1

Version: 8.0.0.8 [20430] ENU

First two lines of log:

2021 2011-01-18 11:27:20 0000-00-00 00:00:00 +0400 00000000 001 003f 0001 09 PSeServiceObjMgr_enu 22020443 16882 241 /u01/app/siebel/product/8.0.0/siebsrvr/enterprises/uatsiebelent/pcrfap01/log/PSeServiceObjMgr_enu_0021_22020443.log 8.0.0.8 [20430] ENU
TaskConfig TaskCfgParamInit 3 000001494d3141f2:0 2011-01-18 11:27:20 The Parameters for the current task (22020443) are :

Last two lines of log:

ObjMgrBusServiceLog InvokeMethod 4 000038474d3362d0:0 2011-01-18 11:28:11 Business Service 'Web Engine State Properties' invoke method 'IsFrameless' Execute Time: 0.000 seconds.
ObjMgrBusServiceLog InvokeMethod 4 000038474d3362d0:0 2011-01-18 11:28:11 End: Bus


EventContext trace >>>

EventContext EvtCtxView 3 000038154d3362d0:0 2011-01-18 11:27:20 PUB GOV Home Page View (eService)
EventContext EvtCtxScreen 3 000038154d3362d0:0 2011-01-18 11:27:20 no accessible views found for screen PUB GOV Home Screen (eService)
EventContext EvtCtxView 3 000038324d3362d0:0 2011-01-18 11:27:43 DC ECR Amend Track Registration View (eService)
EventContext EvtCtxApplet 4 000038344d3362d0:0 2011-01-18 11:27:51 DC ECR Amend Track Registration Applet (eService) (NewQuery)
EventContext EvtCtxApplet 4 000038354d3362d0:0 2011-01-18 11:27:51 DC ECR Amend Track Registration Applet (eService) (ExecuteQuery)
EventContext EvtCtxApplet 4 000038364d3362d0:0 2011-01-18 11:27:51 DC ECR Amend Track Registration Applet (eService) (DCContinue)
EventContext EvtCtxView 3 000038364d3362d0:0 2011-01-18 11:27:51 DC ECR Amend User Creation Vew (eService)
EventContext EvtCtxApplet 4 0000383b4d3362d0:0 2011-01-18 11:27:54 DC ECR Amend New User Creation Applet (eService) (Drilldown)
EventContext EvtCtxView 3 0000383b4d3362d0:0 2011-01-18 11:27:54 DC ECR Amend User Creation Detail View (eService)
EventContext EvtCtxApplet 4 0000383f4d3362d0:0 2011-01-18 11:27:55 DC ECR Amend User Roles Creation List Applet (eService) (NewRecord)
EventContext EvtCtxApplet 4 000038404d3362d0:0 2011-01-18 11:27:55 DC ECR Amend User Roles Creation List Applet (eService) (WriteRecord)
EventContext EvtCtxApplet 4 000038414d3362d0:0 2011-01-18 11:27:55 DC ECR Amend New User Creation Form Applet (eService) (WriteRecord)
EventContext EvtCtxView 3 000038414d3362d0:0 2011-01-18 11:27:56 DC ECR Amend User Creation Vew (eService)
EventContext EvtCtxApplet 4 000038444d3362d0:0 2011-01-18 11:27:59 DC ECR Amend Request Form Applet (eService) (WriteRecord)
EventContext EvtCtxApplet 4 000038454d3362d0:0 2011-01-18 11:27:59 DC ECR Amend Request Form Applet (eService) (Submit)
EventContext EvtCtxView 3 000001654d3141f2:0 2011-01-18 11:28:11 DC ECR Amend Confirmation View (eService)

Longest Running SQLs >>

Solution:



Facing performance when navigating in eService Application.
Issue is resolved now after creating indexes on the extension tables.

Get Oracle Certifications for all Exams
Free Online Exams.com