Friday, November 04, 2011

Change HTTP port in OracleXE


SQL> begin
 2    dbms_xdb.sethttpport('9080');
 3  end;
 4  /

Tuesday, November 01, 2011

How to Database options in Oracle

select * from v$options;


 it  will give parameters configured in DB like Partitioning(TRUE/FALSE),RAC,DB queuing,Indexing ,Spatial,Duplex backup,Java,OLAP,DataMinig