New answers tagged

0

If you want to connect your java software to a Oracle DB, I recommend you to use JDBC API instead http://docs.oracle.com/javase/tutorial/jdbc/basics/index.html You are welcome. PS- ask for help to your IT-team/DBAs


1

If you are connecting to an Oracle instance 11.2+, you can fetch data from the column temp_space_allocated of the view v$active_session_history, which shows the amount of TEMP memory (in bytes) consumed by your session at the time the sample was taken. Otherwise, you may look at the V$TEMPSEG_USAGE view, column blocks, and convert it to megabytes depending ...



Top 50 recent answers are included