V$SQL view has the following column and statistics data. select sql_txt from v$sql select s.username, s.sid, s.serial#,t.sql_text “Last SQL”from gv$session s, gv$sqlarea twhere s.sql_address =t.address ands.sql_hash_value =t.hash_value

Go to Oracle Linux x86-64 instant clients download page Download the matching client Install Set environment variables in your ~/.bash_profile Reload your .bash_profile by simply typing source ~/.bash_profile (suggested by jbass) or Log-out user and […]