Thursday, October 23, 2014

Show full list of program arguments in top command

Pass the -c argument to top to display the command line arguments that were passed to the process
top -c

Monday, September 29, 2014

List all references to a table in Oracle

Got this query from this blog:
select * from all_constraints
where r_constraint_name in
    (select constraint_name from all_constraints
      where table_name='TABLE_NAME');