New answers tagged


If you want to connect your java software to a Oracle DB, I recommend you to use JDBC API instead You are welcome. PS- ask for help to your IT-team/DBAs


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