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