-
Monitor Oracle DB Server Processes
To see DB processes running on your Oracle DB, the code below can be used. Specially handy if you want to check which part of your package or stored procedure is taking time to execute. Indispensable for performance tuning. SELECT sess.sid, sess.serial#, sess.sql_child_number, sess.sql_exec_id, sess.process, sess.status, sess.username, sess.osuser, sess.program, sess.schemaname, sql.sql_text FROM v$session sess, v$sql…
-
Select Random Records in Oracle
Recently, I needed to sort the result of a query in random and show a limited number of records. Honestly, I didn’t know how to do it and had to search various online forums to get the correct answer. So for my own sanity, I’ll be posting the solution here. Step 1 SELECT field_name1, field_name2…
Recent Comments