SQL> select * from dba_profiles
  2  where profile='CHECK_PROF'
  3  and resource_name in ('IDLE_TIME','CONNECT_TIME');

PROFILE                        RESOURCE_NAME                    RESOURCE
------------------------------ -------------------------------- --------
LIMIT
----------------------------------------
CHECK_PROF                     IDLE_TIME                        KERNEL
1

CHECK_PROF                     CONNECT_TIME                     KERNEL
2

11:45:05 SQL> select username,profile from dba_users
11:45:12   2  where username='SCOTT';    

USERNAME                       PROFILE
------------------------------ ------------------------------
SCOTT                          CHECK_PROF


11:51:32 SQL> conn scott/tiger
Connected.

11:53:44 SQL> create table t2(n1 number);
create table t2(n1 number)
*
ERROR at line 1:
ORA-02396: exceeded maximum idle time, please connect again

11:57:19 SQL> conn scott/tiger     
Connected.

12:02:27 SQL> create table n1(col1 number);

Table created.

12:03:02 SQL> drop table n1;

Table dropped.

12:05:09 SQL>