oracle queries

oracle.sql

SELECT *
  FROM all_constraints
 WHERE constraint_name = 'SYS_C0010867';
 
 SELECT *
  FROM all_cons_columns
 WHERE table_name = 'oc_preferences';
 
 SELECT sess.process, sess.status, sess.username, sess.schemaname, sql.sql_text
  FROM v$session sess,
       v$sql     sql
 WHERE sql.sql_id(+) = sess.sql_id
   AND sess.type     = 'USER';
   
   
execute dbms_connection_pool.start_pool()

select connection_pool, status, maxsize
 from dba_cpool_info;
 
  select num_requests,num_hits,num_misses,num_waits
 from v$cpool_stats;
 
  select *
 from v$cpool_stats;
 
  select cclass_name, num_requests, num_hits, num_misses
 from v$cpool_cc_stats;
 
  select *
 from v$cpool_cc_stats;