2014-08-02-3.sql

botang

select  * from dba_profiles p where p.profile='PROFILE1' and p.resource_type='KERNEL';

select  * from v_$session s  where s.TERMINAL='pts/1';

select  * from resource_cost;

alter   resource cost CONNECT_TIME  1;

-- real  connect_time(mins) *1 +  real cpu_per_session*0 + .......=cost

select * from dba_users u where u.username='HR';