QueryDB

1) Change the permission of the file you downloaded to be executable. Type: chmod a+x jre-6u -linux-i586.bin 2) Verify that you have permission to execute the file. Type: ls -l 3) Change to the directory in which you want to install. Type: cd For example, to install the software in the /usr/java/ directory, Type: cd /usr/java/ 4) Run the self-extracting binary Type: ./jre-6u -linux-i586.bin 5) Verify that the jre1.6.0_ sub-directory is listed under the current directory.

To find the Oracle Version: Sql>Select * from v$version;

FIRST SOLUTION: (for administrators; is a global solution) Set the system property when invoking Java process : -Djavax.xml.soap.MessageFactory=org.apache.axis.soap.MessageFactoryImpl SECOND SOLUTION: (for developers; is a local solution) a ) Locate in the source code of your application the place where de message factory is instantied to create SOAP messages: MessageFactory.newInstance() // --> javax.xml.soap.MessageFactory b) Replace this expression (MessageFactory.newInstance()) with: new org.apache.axis.soap.MessageFactoryImpl()

Sys.V_$SQL v$sql_bind_capture v$session V$SQLAREA v$sql_bind_capture for further details:- http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_2111.htm

select scn_to_timestamp(max(ora_rowscn)) from OWNER.TABLE_NAME while running above query you can have error:- ERROR at line 1: ORA-08181: specified number is not a valid system change number ORA-06512: at "SYS.SCN_TO_TIMESTAMP", line 1 Cause: supplied scn was beyond the bounds of a valid scn. Action: use a valid scn. reason behind this can be:- This only works as long as the snapshot is still around. After that, it appears to go into a frozen state. All off my records older than a certain point have the same SCN. you can also use:- SELECT * FROM all_tab_modifications