Zukus and Oracle

 First example is convert seconds to HH24:MI with using to_char: with t as (select 800000000 sec from dual) select nvl(trim(to_char(trunc(r...

set linesize 256 col owner for a30 col table_name for a30 col segment_name for a90 col LOB_SECURED for a11 col LOB_COMPRESSION for a15 w...

Sessions utilization SQL> select (100*current_utilization / limit_value) as session_percent from v$resource_limit where resource_n...

set linesize 256 col machine format a50 select machine, username, count(*) cnt FROM v$session WHERE 1 = 1 group by ...

Find similar SQL statements 1. Find similar SQL statements using gv$open_cursor select saddr, sid, user_name, address,hash_value,sql_id,...