Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
CURSOR c_get_capture_sqls IS select distinct ash.client_id,du.name, sql_bind_capture.value_string from v$active_session_history ash, dimuser du, v$sql sql, v$session sesion, v$sql_bind_capture sql_bind_capture where to_number(substr(ash.client_id,instr(ash.client_id,'/')+1))=du.dimuserid AND ash.sample_time between sysdate - 60/2500 and sysdate AND ash.sql_id = sql.sql_id (+) And sql.HASH_VALUE = sql_bind_capture.HASH_VALUE AND ash.SESSION_ID =sesion.SID (+) AND ash.sql_id = sql_bind_capture.sql_id;
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!