DATABASE - oracle 小記

查詢 table 的 index

SELECT index_name, column_position, column_name
  FROM all_ind_columns
 WHERE table_name='XXX'
 ORDER BY index_name,column_position;

得知目前 oracle connection 數量

db-server # ps –ef | grep oracle | wc –l