Jul 20, 2010

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.

May 28, 2010

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.




May 4, 2010

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.

Nov 7, 2009

Thomson Prometric Testing Centres, Hyderabad


PROMETRIC TESTING (P) LTD
HYDERABAD, Andhra Pradesh 500034
Phone: 4023303903 Site Code: II001

AVENUE 1 STREET 20, ABOVE SBI
PLOT 1672 ROAD 12
BANJARA HILLS


Telesis Technologies P Ltd.
Hyderabad, Andhra Pradesh 500020
Phone: 27666894 Site Code: II412

1-1-162,
III floor, Crystal building
RTC X Raods
Opp Big Bazaar


NIIT Ltd.
Hyderabad, Andhra Pradesh 500063
Phone: 66622249 Site Code: IIC

2nd Floor
Prashanti Complex
Opp. to Old Gandhi Medical College
Basheerbagh


CMS Info Systems Private Limited
Hyderabad, Andhra Pradesh 500003
Phone: 40100088 Site Code: IIH50

CMS COMPUTERS LTD
#19,2ND FLOOR,HARDY COMPLEX
OPP.CHERMAS,M.G.ROAD,
Paradise,Secunderabad


NIIT Ltd.-Ameerpet
Hyderabad, Arunachal Pradesh 500016
Phone: 66747792 Site Code: IIN36

4th Floor
Pavan Vanijya Vihar
Beside R S Brothers
Above Srikrishna Sweets


KARROX TECHNOLOGIES LTD
Hyderabad, Andhra Pradesh 500016
Phone: 66625561 Site Code: II449

6-3-788/A/10
Opp. Lane Chandana Bros
Durganagar Colony
Ameerpet


HCL Infosystems Limited
Hyderabad, Andhra Pradesh 500003
Phone: 27890520 Site Code: II582

503-504,5th Floor
Minerva Complex
S D Road
Near Park Lane