Oracle Database timezone

SELECT SESSIONTIMEZONE FROM DUAL;

ALTER SESSION SET TIME_ZONE='-7:00';

SELECT DBTIMEZONE FROM DUAL;


Note:- DBTIMEZONE only apply when you have "TIMESTAMP WITH LOCAL TIME ZONE" (TSLTZ) datatype.

SOA: SOAP fault handling

http://www.xenta.nl/blog/2010/07/17/oracle-service-bus-11g-handling-soap-faults/

ADF Certification and Support Matrix

http://www.oracle.com/technology/products/jdev/collateral/papers/11/certification/index.html

Browsers

The Oracle ADF Faces rich client components are certified or supported with the following browsers. For the ADF Faces components that render in Flash, Flash 9 and Flash 10 are certified. Please also see Apache MyFaces Trinidad supported platforms information.

Browser	Operating Systems	ADF (ADF Faces)
Firefox 2.0, 3.0, 3.5+2	Windows, Linux, Mac OS, Solaris	Certified
Internet Explorer 7, 82	Windows	Certified
Safari 3.2, 4.02	Windows, Mac OS	Certified
Safari 3.0 (mobile)2	iPhone OS	Supported
Chrome 1.0+1	Windows	Supported

* 32 bit JDK required for Windows platforms. 32 bit JDK required for profiling features on Linux platforms
** Oracle ADF Mobile Client 11.1.1.3.0 is in "Developer Preview" and as such is not
1. Support or certification added in 11g Release 1 (11.1.1.1.0). Does not apply to 11g versions prior to 11.1.1.1.0.
2. Support or certification added in 11g Release 1 Patch Set 1 (11.1.1.2.0). Does not apply to 11g Release 1 versions prior to 11.1.1.2.0.
3. Support or certification added in 11g Release 1 Patch Set 2 (11.1.1.3.0). Does not apply to 11g Release 1 versions prior to 11.1.1.3.0. supported, so this is for informational purposes only.

How to increase no. of sessions in oracle database?

If you are increasing sessions parameter you should consider increasing processes and transactions parameter as well.

Here is the formula you can use to determine their values.

processes=x
sessions=x*1.1+5
transactions=sessions*1.1

E.g.

processes=500
sessions=555
transactions=610

Commands:-
sqlplus "/as sysdba"
or
sqlplus '/as sysdba'


show parameter sessions;
show parameter processes;
show parameter transactions;
alter system set processes=500 SCOPE=SPFILE; 
alter system set sessions=555 SCOPE=SPFILE; 
alter system set transactions=610 SCOPE=SPFILE; 

and restart the database.

Settings for higher performance:-

alter system set open_cursors=1500 scope=both;
alter system set processes=3000 scope=spfile;
alter system set undo_retention=10800 scope=both;
alter system set max_shared_servers=50 scope=both;
alter system set db_files=2000 scope=spfile; 
alter system set sessions=3305 SCOPE=SPFILE;  
alter system set transactions=3635 SCOPE=SPFILE; 

If you facing below issue while doing alter system
SQL> ALTER SYSTEM SET memory_target = 0 SCOPE=SPFILE;
ALTER SYSTEM SET memory_target = 0 SCOPE=SPFILE
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE is in use

then perform 'CREATE SPFILE FROM PFILE' to create a SPFILE and do restart the database.

How to get the list of all users in Oracle Database?

1. Connect to sql using 'sqlplus / as sysdba'

2. Execute 'Select * from all_users;' to display all users in Oracle db.

Weblogic - MBean

Creation of MBean and register them with Weblogic server
http://blogs.oracle.com/WebLogicServer/2009/10/developing_custom_mbeans_to_ma.html


Modification of default attribute and parameter descriptions to custom info.
http://blogs.oracle.com/WebLogicServer/2009/11/developing_custom_mbeans_to_manage_j2ee_applications_part_ii.html


Localizing MBean's attribute and parameter description
http://blogs.oracle.com/WebLogicServer/2010/03/developing_custom_mbeans_to_ma_1.html

BPEL Useful links

Home Page

Sample code

Much more info

http://apps2fusion.com/at/gt/tc/252-what-is-oracle-bpel-for-developer-perspective

http://www.codeguru.com/cpp/sample_chapter/article.php/c10789/Oracle-BPEL-Process-Manager.htm