Oracle Magazine, Jan/Feb 2018
Database Application Developer and DBA BEYOND SQL 101 ORACLE MAGAZINE JANUARY FEBRUARY 2018 131 SQL select resource_ name resource_ type limit 2 from dba_ profiles 3 where profile DEFAULT 4 order by resource_ type resource_ name RESOURCE_ NAME RESOURCE LIMIT COMPOSITE_ LIMIT KERNEL UNLIMITED CONNECT_ TIME KERNEL UNLIMITED CPU_ PER_ CALL KERNEL UNLIMITED CPU_ PER_ SESSION KERNEL UNLIMITED IDLE_ TIME KERNEL UNLIMITED LOGICAL_ READS_ PER_ CALL KERNEL UNLIMITED LOGICAL_ READS_ PER_ SESSION KERNEL UNLIMITED PRIVATE_ SGA KERNEL UNLIMITED SESSIONS_ PER_ USER KERNEL UNLIMITED FAILED_ LOGIN_ ATTEMPTS PASSWORD 10 PASSWORD_ GRACE_ TIME PASSWORD 7 PASSWORD_ LIFE_ TIME PASSWORD 180 PASSWORD_ LOCK_ TIME PASSWORD 1 PASSWORD_ REUSE_ MAX PASSWORD UNLIMITED PASSWORD_ REUSE_ TIME PASSWORD UNLIMITED PASSWORD_ VERIFY_ FUNCTION PASSWORD NULL 16 rows selected
You must have JavaScript enabled to view digital editions.