oracle profile Idle_time设置

 sgcrm5*sgcrm5-/home/oracle >sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on Mon Oct 15 14:38:25 2012

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

[email protected]> show parameter resource_limit

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
resource_limit                       boolean     FALSE
[email protected]> alter system set resource_limit=true scope=both;

System altered.

Elapsed: 00:00:00.08
[email protected]> select username,profile from DBA_USERS
  2  ;

USERNAME                       PROFILE
------------------------------ ------------------------------
9959                           DEFAULT
SCOTT                          DEFAULT
SPOTLIGHT                      DEFAULT
SPATIAL_WFS_ADMIN_USR          DEFAULT
MDDATA                         DEFAULT
XS$NULL                        DEFAULT
APEX_PUBLIC_USER               DEFAULT
TSMSYS                         DEFAULT
DIP                            DEFAULT
SPATIAL_CSW_ADMIN_USR          DEFAULT
ORACLE_OCM                     DEFAULT
OWBSYS                         DEFAULT
EXFSYS                         DEFAULT
FLOWS_030000                   DEFAULT
FLOWS_FILES                    DEFAULT
WK_TEST                        DEFAULT
DBSNMP                         MONITORING_PROFILE
WMSYS                          DEFAULT
ORDSYS                         DEFAULT
WKSYS                          WKSYS_PROF
XDB                            DEFAULT
OLAPSYS                        DEFAULT
SI_INFORMTN_SCHEMA             DEFAULT
ORDPLUGINS                     DEFAULT
WKPROXY                        DEFAULT
MDSYS                          DEFAULT
SYSMAN                         DEFAULT
CTXSYS                         DEFAULT
ANONYMOUS                      DEFAULT
SYS                            DEFAULT
SYSTEM                         DEFAULT
MGMT_VIEW                      DEFAULT
OUTLN                          DEFAULT

33 rows selected.

Elapsed: 00:00:00.05
[email protected]> select distinct(profile) from dba_profiles;

PROFILE
------------------------------
WKSYS_PROF
DEFAULT
MONITORING_PROFILE
PROFILE9959

Elapsed: 00:00:00.01
[email protected]> SELECT name, value
  2  FROM gv$parameter
  3  WHERE name = 'resource_limit';

NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
resource_limit
TRUE


Elapsed: 00:00:00.01
[email protected]> alter user system profile PROFILE9959;

User altered.

Elapsed: 00:00:00.07
[email protected]>  sgcrm5*sgcrm5-/home/oracle >sqlplus / as sysdb