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

List all references to a table in Oracle

Got this query from this blog: http://www.dba-oracle.com/t_find_all_references_to_oracle_table.htm

select * from all_constraints
where r_constraint_name in
    (select constraint_name from all_constraints
      where table_name='TABLE_NAME');