Oracle Database Discussions

dear all

i am creating a profile and using some resource parameter

my resource_limit parameter is true....


SQL> show parameter resource;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
resource_limit boolean TRUE
resource_manager_plan string INTERNAL_PLAN





SQL> CREATE PROFILE poweruser LIMIT
2 SESSIONS_PER_USER UNLIMITED,
3 CPU_PER_SESSION UNLIMITED ,
4 CPU_PER_CALL 30000,
5 CONNECT_TIME 60,
6 LOGICAL_READS_PER_SESSION UNLIMITED,
7 LOGICAL_READS_PER_CALL 1000,
8 COMPOSITE_LIMIT 5000000;
SESSIONS_PER_USER UNLIMITED,
*
ERROR at line 2:
ORA-02376: invalid or redundant resource


help me

CHeers