-- 19с: ?/rdbms/admin/denv.bsq
create profile "DEFAULT" limit            /* default value, always present */
  composite_limit               unlimited                   /* service units */
  sessions_per_user             unlimited              /* logins per user id */
  cpu_per_session               unlimited            /* cpu usage in minutes */
  cpu_per_call                  unlimited        /* max cpu minutes per call */
  logical_reads_per_session     unlimited
  logical_reads_per_call        unlimited
  idle_time                     unlimited
  connect_time                  unlimited
  private_sga                   unlimited      /* valid only with TP-monitor */
  failed_login_attempts         10
  password_life_time            unlimited
  password_reuse_time           unlimited
  password_reuse_max            unlimited
  password_verify_function      null
  password_lock_time            unlimited
  password_grace_time           unlimited
  inactive_account_time         unlimited
  password_rollover_time        0
  container=current
/
-- 21c:
create profile "DEFAULT" limit            /* default value, always present */
  composite_limit               unlimited                   /* service units */
  sessions_per_user             unlimited              /* logins per user id */
  cpu_per_session               unlimited            /* cpu usage in minutes */
  cpu_per_call                  unlimited        /* max cpu minutes per call */
  logical_reads_per_session     unlimited
  logical_reads_per_call        unlimited
  idle_time                     unlimited
  connect_time                  unlimited
  private_sga                   unlimited      /* valid only with TP-monitor */
  failed_login_attempts         10
  password_life_time            unlimited
  password_reuse_time           unlimited
  password_reuse_max            unlimited
  password_verify_function      null
  password_lock_time            unlimited
  password_grace_time           unlimited
  inactive_account_time         365
  password_rollover_time        0
  container=current
/

CHANGE #4 MEDIA RECOVERY MARKER CON_ID:4 SCN:0x0000000000000000 SEQ:0 OP:5.19 ENC:0 FLG:0x0000
session number   = 10
serial  number   = 26564
current username = SYS
login   username =
client info      =
OS username      = oracle
Machine name     = db-21.localdomain
OS terminal      = UNKNOWN
OS process id    = 2866_2871
OS program name  = oracle@db-21.localdomain (GEN1)
transaction name =
Recursive transaction
version 352321536
audit sessionid 0
Client Id  =

select user#, name, cast(ctime as timestamp) at time zone 'UTC' creation_time, spare6 lslt, rownum from user$ a, profile$ b where           a.type# = 1 AND           nvl(a.password, 'NULL') not in ('EXTERNAL','GLOBAL')   AND           ((sys_context('userenv', 'con_id') = 0) OR            ((sys_context('userenv', 'con_id') = 1)              AND (bitand(spare1, 128) = 128))    OR            ((sys_context('userenv', 'con_id') > 1)             AND (bitand(spare1, 128) != 128)))   AND           a.name not in ('XS$NULL','SYSRAC') AND           bitand(a.spare1, 2080) not in            (32, 2048, 2080) AND           (bitand(a.astatus,8) <> 8 OR           bitand(a.astatus,8) = 8 AND           a.name in ('SYS','SYSBACKUP','SYSDG','SYSKM')) AND           a.resource$ = b.profile# AND           b.resource# = 7 AND           b.type#     = 1 AND           ((b.limit#   != 2147483647) AND           NOT (b.limit# = 0 and exists (select 1 from profile$ where            profile#=0 and resource#=7 and type#=1 and limit#=2147483647)))           AND           (bitand(spare1,65536) = 0)           order by rownum DESC