Do you want to Search Something?

Loading...

Those who opened the gates

Follow by Email

Wednesday, December 10, 2014

The query which made me a mere spectator of Time


This SQL query takes it too long to bring the data

select * from s_evt_act where QUOTE_ID is not null
and TODO_CD in ('Email - Inbound','Email - Outbound','Communication','BCP Request','PCN Request','PriceResponse')

Generate Explain Plan using F10 in SQL Developer



We can see that the Table Access is happening for S_EVT_ACT for query QUOTE_ID IS NOT NULL
The Cost comes around 11200

Solution:

Create an Index

CREATE INDEX "SIEBEL"."S_EVT_ACT_F85_X" ON "SIEBEL"."S_EVT_ACT"
  (
    "QUOTE_ID" DESC,
    "CREATED" DESC,
    "TODO_CD" DESC
  )
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE
  (
    INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT
  )
  TABLESPACE "SIEBDATA" ;


Modify the above SQL to use the newly created INDEX as a hint(in Blue Font)

select /*+ index(S_EVT_ACT S_EVT_ACT_F85_X) */ * from s_evt_act where QUOTE_ID is not null
and TODO_CD in ('Email - Inbound','Email - Outbound','Communication','BCP Request','PCN Request','PriceResponse')

Check the Explain Plan by clicking F10




You can see that the Cost is reduced by leaps and bounds 552

Performance is improved.But you can further tune...think think think:)

Use the following SQL as per need to compute statistics occasionaly
alter index "SIEBEL"."S_EVT_ACT_F85_X" compute statistics

Have a great day

Wednesday, September 25, 2013

Open UI Benchmarks on Various Browsers and Platforms

Here is a Benchmark Test result shared by Oracle on September 24 2013

Browser
Time
Hardware
Internet Explorer 6 (Does not meet functional or performance W3C Standards)
86 seconds
Intel I5 1.7GHz – Windows 7
Internet Explorer 7
(Does not meet functional or performance W3C Standards)
18 seconds
Intel I5 1.7GHz – Windows 7
Internet Explorer 8
(May not meet performance Standards)
3.6 seconds
Intel I5 1.7GHz – Windows 7
Android Mobile
2.8 seconds
Galaxy S2 ICS
Safari Mobile
2.2 seconds
iPad 2 IOS
Chrome for Android
1.2 seconds
Galaxy S4 JB 4.1
Internet Explorer 9
0.6 seconds
Intel I5 1.7GHz – Windows 7
Internet Explorer 10
0.3 seconds
Intel I5 1.7GHz – Windows 7

Choose wisely live happily:)

Monday, September 23, 2013

Welcome Open UI

Finally Open UI showed up on my Desktop Monitor.Eager to look out for the new features and drawbacks.

Tuesday, February 12, 2013

Full Compile Sequence in Siebel Tools

Today I was waiting impatiently for the full compile to finish...

So I just took a note of the sequence in which compile happens

this is the observation;I just noted major milestone objects and left out others ;)

Compile Sequence
Tables --> Applet --> Link --> Business Component --> Screen ---> Setting Up Application --> Closing SRF

Tuesday, August 28, 2012

Verifying Classpath in Siebel

It has been observerd that lot of time is spent in issues related to troubleshooting classpath issues.

After configuring the classpath values open the Business service Simulator and use the 'EAI JMS

Transport'


There are a couple of handy methods in this Business Service.

eg: method : CheckClasspath


On running this  you get an ouput telling the result.

<?xml version="1.0" encoding="UTF-8" ?>
  <?Siebel-Property-Set EscapeNames="true"?>
  <PropertySet>Input property set: > Value = > Type = > SendPassword = > ConnectionPassword = > CommitTransaction = true > ReceiveUsername = > TopicUsername = > PreserveString = true > ConnectionUsername = > ConnectionFactory = > ReceivePassword = > TopicPassword = > SendUsername = java.class.path = /u01/app/siebel/jms:/u01/app/siebel/jms/Siebel.jar:/u01/app/siebel/jms/SiebelJI_enu.jar:/u01/app/siebel/jms/jndi.jar:/u01/app/siebel/jms/adminclient.jar:/u01/app/siebel/jms/bcel.jar:/u01/app/siebel/jms/dms.jar:/u01/app/siebel/jms/ejb.jar:/u01/app/siebel/jms/jms.jar:/u01/app/siebel/jms/optic.jar:/u01/app/siebel/jms/pcl.jar:/u01/app/siebel/jms/oc4jclient.jar:/u01/app/siebel/jms/javax77.jar:/u01/app/siebel/jms/ojdbc14dms.jar:/u01/app/siebel/jms/mail.jar:/u01/app/siebel/jms/jta.jar:. Found directory /u01/app/siebel/jms NOTE: A jndi.properties file is present in /u01/app/siebel/jms Found jar file /u01/app/siebel/jms/Siebel.jar with 638 entries. Found jar file /u01/app/siebel/jms/SiebelJI_enu.jar with 25 entries. Found jar file /u01/app/siebel/jms/jndi.jar with 123 entries. Found jar file /u01/app/siebel/jms/adminclient.jar with 1307 entries. Found jar file /u01/app/siebel/jms/bcel.jar with 399 entries. Found jar file /u01/app/siebel/jms/dms.jar with 192 entries. Found jar file /u01/app/siebel/jms/ejb.jar with 37 entries. Found jar file /u01/app/siebel/jms/jms.jar with 61 entries. Found jar file /u01/app/siebel/jms/optic.jar with 32 entries. Found jar file /u01/app/siebel/jms/pcl.jar with 270 entries. Found jar file /u01/app/siebel/jms/oc4jclient.jar with 850 entries. Found jar file /u01/app/siebel/jms/javax77.jar with 39 entries. Found jar file /u01/app/siebel/jms/ojdbc14dms.jar with 638 entries. Found jar file /u01/app/siebel/jms/mail.jar with 259 entries. Found jar file /u01/app/siebel/jms/jta.jar with 20 entries. Found directory /u01/app/siebel/siebsrvr/bin/. SUCCESSFUL TEST</PropertySet>

Wednesday, July 25, 2012

Cleaning the File System in Siebel


During normal operation of Siebel Business Applications software, it is likely that orphaned files will be stored in the Siebel File System and that orphaned records will exist in the Siebel Database.

Here comes in the handy SFS cleanup utility.....

Periodically run the SFSCLEANUP utility to remove orphaned files from the Siebel File System. This utility is located in the bin subdirectory within the Siebel Server root directory.

Run this and be a best practice compliant and responsible siebel  consultant :)

Cheers

Wednesday, July 4, 2012

Fix C028: “Unable to Connect to the Siebel Gateway Name Server”

Symptoms

The Server Configuration wizard has logged the following error message:
C028: Unable to Connect to the Siebel Gateway Name Server

Cause
Database Authentication failed.
Gateway authentication is a new feature in Siebel 8.1.1.  If the Configuration Wizard fails due to authentication it will log the error messages, above.

Solution

Follow these steps to resolve the issue:

1. In the ‘$SIEBEL_ROOT/gtwysrvr/siebenv.sh’ environment sourcing script, check the following environment variables and  set them appropriately before starting the Gateway server.
1a. For all servers: ORACLE_HOME must be declared before any library paths are declared.
Example:
ORACLE_HOME=/export/home/ora10g/10203 ; export ORACLE_HOME
1b. NOTE: For the following library paths, Oracle 32-bit libraries must be referenced before 64-bit libraries. An example is provided for each library path per Unix system, as follows:
For AIX: LIBPATH
LIBPATH=${SIEBEL_ROOT}/lib:${MWHOME}/lib:${SQLANY}/lib:/usr/lib:${LIBPATH}:${ORACLE_HOME}/lib32:${ORACLE_HOME}/lib
For HP-UX:  SHLIB_PATH
SHLIB_PATH=/usr/lib/hpux32:${SIEBEL_ROOT}/lib:${MWHOME}/lib:${SQLANY}/lib:${ORACLE_HOME}/lib32:${ORACLE_HOME}/lib
For Linux and Solaris:  LD_LIBRARY_PATH
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:${ORACLE_HOME}/lib32:
${ORACLE_HOME}/lib
2. Open the ‘gateway.cfg’ file, which is located in the ‘$SIEBEL_ROOT/gtwysrvr/bin’ directory.
Check the ‘ServerDataSrc’ section and confirm the parameters are correct, particularly:
ConnectString
TableOwner
GatewayAddress
EntepriseServer
3. Test Siebel database connectivity using the Oracle odbcsql utility for the ‘sadmin’ user.  This is typically located in the ‘$IEBEL_ROOT/siebsrvr/bin’ directory.
For example:
odbcsql /s sia811_DSN /u sadmin /p sadmin
where:
/s = the source ODBC DSN (the Siebel ConnectString parameter) for the database connection.
/u = the user ID.
/p = the password.
If connection is possible, continue with step 4.
4. Restart the Gateway server, and then try configuring the Siebel Server.

Hope that helps !!!! have a nice day