Oracle：User account

Shell Log：

SQL> col "Default TBS" for a8
SQL> col "Temprary" for a8
SQL> col profile for a8
SQL> 
SQL> select user_id,username,password,account_status,to_char(lock_date,'yyyy-mm-dd hh24:mi:ss') "Lock Date",to_char(expiry_date,'yyyy-mm-dd hh24:mi:ss') "Expiry Date",default_tablespace "Default TBS",temporary_tablespace "Temprary",to_char(created,'yyyy-mm-dd hh24:mi:ss') "Created Date",profile,password_versions,to_char(last_login,'yyyy-mm-dd hh24:mi:ss') "Last Login" from dba_users order by account_status,"Created Date";

   USER_ID USERNAME                PASSWORD     ACCOUNT_STATUS          Lock Date           Expiry Date         Default  Temprary Created Date        PROFILE  PASSWORD_VER Last Login
---------- ----------------------- ------------ ----------------------- ------------------- ------------------- -------- -------- ------------------- -------- ------------ -------------------
         7 AUDSYS                               EXPIRED & LOCKED        2014-07-07 05:39:13 2014-07-07 05:39:13 USERS    TEMP     2014-07-07 05:39:13 DEFAULT  10G 11G 12C
2147483617 SYSBACKUP                            EXPIRED & LOCKED        2014-07-07 05:39:13 2014-07-07 05:39:13 USERS    TEMP     2014-07-07 05:39:13 DEFAULT  10G 11G 12C
2147483619 SYSKM                                EXPIRED & LOCKED        2014-07-07 05:39:14 2014-07-07 05:39:14 USERS    TEMP     2014-07-07 05:39:14 DEFAULT  10G 11G 12C
2147483618 SYSDG                                EXPIRED & LOCKED        2014-07-07 05:39:14 2014-07-07 05:39:14 USERS    TEMP     2014-07-07 05:39:14 DEFAULT  10G 11G 12C
        13 OUTLN                                EXPIRED & LOCKED        2014-07-07 05:39:15 2014-07-07 05:39:15 SYSTEM   TEMP     2014-07-07 05:39:15 DEFAULT  10G 11G 12C
        22 GSMUSER                              EXPIRED & LOCKED        2014-07-07 05:42:58 2014-07-07 05:42:58 USERS    TEMP     2014-07-07 05:42:58 DEFAULT  10G 11G 12C
        21 GSMADMIN_INTERNAL                    EXPIRED & LOCKED        2014-07-07 05:42:58 2014-07-07 05:42:58 SYSAUX   TEMP     2014-07-07 05:42:58 DEFAULT  10G 11G 12C
        23 DIP                                  EXPIRED & LOCKED        2014-07-07 05:43:05 2014-07-07 05:43:05 USERS    TEMP     2014-07-07 05:43:05 DEFAULT  10G 11G 12C
2147483638 XS$NULL                              EXPIRED & LOCKED        2014-07-07 05:44:03 2014-07-07 05:44:03 USERS    TEMP     2014-07-07 05:44:03 DEFAULT  11G
        36 ORACLE_OCM                           EXPIRED & LOCKED        2014-07-07 05:44:37 2014-07-07 05:44:37 USERS    TEMP     2014-07-07 05:44:37 DEFAULT  10G 11G 12C
        48 DBSNMP                               EXPIRED & LOCKED        2014-07-07 05:53:06 2014-07-07 05:53:06 SYSAUX   TEMP     2014-07-07 05:53:06 DEFAULT  10G 11G 12C
        49 APPQOSSYS                            EXPIRED & LOCKED        2014-07-07 05:53:07 2014-07-07 05:53:07 SYSAUX   TEMP     2014-07-07 05:53:07 DEFAULT  10G 11G 12C
        51 ANONYMOUS                            EXPIRED & LOCKED        2014-07-07 06:52:34 2014-07-07 06:52:34 SYSAUX   TEMP     2014-07-07 05:53:17 DEFAULT  10G
        50 XDB                                  EXPIRED & LOCKED        2014-07-07 05:53:17 2014-07-07 05:53:17 SYSAUX   TEMP     2014-07-07 05:53:17 DEFAULT  10G 11G 12C
        61 GSMCATUSER                           EXPIRED & LOCKED        2014-07-07 05:56:36 2014-07-07 05:56:36 USERS    TEMP     2014-07-07 05:56:36 DEFAULT  10G 11G 12C
        62 WMSYS                                EXPIRED & LOCKED        2014-07-07 06:05:43 2014-07-07 06:05:43 SYSAUX   TEMP     2014-07-07 06:05:43 DEFAULT  10G 11G 12C
        70 OJVMSYS                              EXPIRED & LOCKED        2014-07-07 06:07:27 2014-07-07 06:07:27 USERS    TEMP     2014-07-07 06:07:27 DEFAULT  10G 11G 12C
        73 CTXSYS                               EXPIRED & LOCKED        2014-07-07 06:12:03 2014-07-07 06:12:03 SYSAUX   TEMP     2014-07-07 06:11:11 DEFAULT  10G 11G 12C
        75 ORDSYS                               EXPIRED & LOCKED        2014-07-07 06:12:11 2014-07-07 06:12:11 SYSAUX   TEMP     2014-07-07 06:12:11 DEFAULT  10G 11G 12C
        79 MDSYS                                EXPIRED & LOCKED        2014-07-07 06:12:11 2014-07-07 06:12:11 SYSAUX   TEMP     2014-07-07 06:12:11 DEFAULT  10G 11G 12C
        78 SI_INFORMTN_SCHEMA                   EXPIRED & LOCKED        2014-07-07 06:12:11 2014-07-07 06:12:11 SYSAUX   TEMP     2014-07-07 06:12:11 DEFAULT  10G 11G 12C
        77 ORDPLUGINS                           EXPIRED & LOCKED        2014-07-07 06:12:11 2014-07-07 06:12:11 SYSAUX   TEMP     2014-07-07 06:12:11 DEFAULT  10G 11G 12C
        76 ORDDATA                              EXPIRED & LOCKED        2014-07-07 06:12:11 2014-07-07 06:12:11 SYSAUX   TEMP     2014-07-07 06:12:11 DEFAULT  10G 11G 12C
        82 OLAPSYS                              EXPIRED & LOCKED        2014-07-07 06:20:30 2014-07-07 06:20:30 SYSAUX   TEMP     2014-07-07 06:20:30 DEFAULT  10G 11G 12C
        85 MDDATA                               EXPIRED & LOCKED        2014-07-07 06:52:34 2014-07-07 06:52:34 USERS    TEMP     2014-07-07 06:20:54 DEFAULT  10G 11G 12C
        87 SPATIAL_WFS_ADMIN_USR                EXPIRED & LOCKED        2014-07-07 06:24:57 2014-07-07 06:24:57 USERS    TEMP     2014-07-07 06:24:57 DEFAULT  10G 11G 12C
        90 SPATIAL_CSW_ADMIN_USR                EXPIRED & LOCKED        2014-07-07 06:25:01 2014-07-07 06:25:01 USERS    TEMP     2014-07-07 06:25:01 DEFAULT  10G 11G 12C
        92 LBACSYS                              EXPIRED & LOCKED        2014-07-07 06:52:34 2014-07-07 06:52:34 SYSTEM   TEMP     2014-07-07 06:29:01 DEFAULT  10G 11G 12C
        95 APEX_PUBLIC_USER                     EXPIRED & LOCKED        2014-07-07 06:29:17 2014-07-07 06:29:17 USERS    TEMP     2014-07-07 06:29:17 DEFAULT  10G 11G 12C
        98 APEX_040200                          EXPIRED & LOCKED        2014-07-07 06:31:11 2014-07-07 06:31:11 SYSAUX   TEMP     2014-07-07 06:29:17 DEFAULT  10G 11G 12C
        94 FLOWS_FILES                          EXPIRED & LOCKED        2014-07-07 06:31:11 2014-07-07 06:31:11 SYSAUX   TEMP     2014-07-07 06:29:17 DEFAULT  10G 11G 12C
   1279990 DVSYS                                EXPIRED & LOCKED        2014-07-07 06:52:07 2014-07-07 06:52:07 SYSAUX   TEMP     2014-07-07 06:51:55 DEFAULT  10G 11G 12C
        99 DVF                                  EXPIRED & LOCKED        2014-07-07 06:52:34 2014-07-07 06:52:34 SYSAUX   TEMP     2014-07-07 06:51:55 DEFAULT  10G 11G 12C
       102 SCOTT                                EXPIRED & LOCKED        2014-10-27 23:48:05 2014-10-27 23:48:05 USERS    TEMP     2014-10-27 23:47:42 DEFAULT  10G 11G 12C
         0 SYS                                  OPEN                                        2015-04-25 23:44:32 SYSTEM   TEMP     2014-07-07 05:39:13 DEFAULT  10G 11G 12C
         8 SYSTEM                               OPEN                                        2015-05-02 18:54:14 SYSTEM   TEMP     2014-07-07 05:39:13 DEFAULT  10G 11G 12C  2014-11-03 18:54:49

36 rows selected.

SQL>

SQL> col "Default TBS" for a8

SQL> col "Temprary" for a8

SQL> col profile for a8

SQL>

SQL> select user_id,username,password,account_status,to_char(lock_date,'yyyy-mm-dd hh24:mi:ss') "Lock Date",to_char(expiry_date,'yyyy-mm-dd hh24:mi:ss') "Expiry Date",default_tablespace "Default TBS",temporary_tablespace "Temprary",to_char(created,'yyyy-mm-dd hh24:mi:ss') "Created Date",profile,password_versions,to_char(last_login,'yyyy-mm-dd hh24:mi:ss') "Last Login" from dba_users order by account_status,"Created Date";

USER_ID USERNAME PASSWORD ACCOUNT_STATUS Lock Date Expiry Date Default Temprary Created Date PROFILE PASSWORD_VER Last Login

---------- ----------------------- ------------ ----------------------- ------------------- ------------------- -------- -------- ------------------- -------- ------------ -------------------

7 AUDSYS EXPIRED & LOCKED 2014-07-07 05:39:13 2014-07-07 05:39:13 USERS TEMP 2014-07-07 05:39:13 DEFAULT 10G 11G 12C

2147483617 SYSBACKUP EXPIRED & LOCKED 2014-07-07 05:39:13 2014-07-07 05:39:13 USERS TEMP 2014-07-07 05:39:13 DEFAULT 10G 11G 12C

2147483619 SYSKM EXPIRED & LOCKED 2014-07-07 05:39:14 2014-07-07 05:39:14 USERS TEMP 2014-07-07 05:39:14 DEFAULT 10G 11G 12C

2147483618 SYSDG EXPIRED & LOCKED 2014-07-07 05:39:14 2014-07-07 05:39:14 USERS TEMP 2014-07-07 05:39:14 DEFAULT 10G 11G 12C

13 OUTLN EXPIRED & LOCKED 2014-07-07 05:39:15 2014-07-07 05:39:15 SYSTEM TEMP 2014-07-07 05:39:15 DEFAULT 10G 11G 12C

22 GSMUSER EXPIRED & LOCKED 2014-07-07 05:42:58 2014-07-07 05:42:58 USERS TEMP 2014-07-07 05:42:58 DEFAULT 10G 11G 12C

21 GSMADMIN_INTERNAL EXPIRED & LOCKED 2014-07-07 05:42:58 2014-07-07 05:42:58 SYSAUX TEMP 2014-07-07 05:42:58 DEFAULT 10G 11G 12C

23 DIP EXPIRED & LOCKED 2014-07-07 05:43:05 2014-07-07 05:43:05 USERS TEMP 2014-07-07 05:43:05 DEFAULT 10G 11G 12C

2147483638 XS$NULL EXPIRED & LOCKED 2014-07-07 05:44:03 2014-07-07 05:44:03 USERS TEMP 2014-07-07 05:44:03 DEFAULT 11G

36 ORACLE_OCM EXPIRED & LOCKED 2014-07-07 05:44:37 2014-07-07 05:44:37 USERS TEMP 2014-07-07 05:44:37 DEFAULT 10G 11G 12C

48 DBSNMP EXPIRED & LOCKED 2014-07-07 05:53:06 2014-07-07 05:53:06 SYSAUX TEMP 2014-07-07 05:53:06 DEFAULT 10G 11G 12C

49 APPQOSSYS EXPIRED & LOCKED 2014-07-07 05:53:07 2014-07-07 05:53:07 SYSAUX TEMP 2014-07-07 05:53:07 DEFAULT 10G 11G 12C

51 ANONYMOUS EXPIRED & LOCKED 2014-07-07 06:52:34 2014-07-07 06:52:34 SYSAUX TEMP 2014-07-07 05:53:17 DEFAULT 10G

50 XDB EXPIRED & LOCKED 2014-07-07 05:53:17 2014-07-07 05:53:17 SYSAUX TEMP 2014-07-07 05:53:17 DEFAULT 10G 11G 12C

61 GSMCATUSER EXPIRED & LOCKED 2014-07-07 05:56:36 2014-07-07 05:56:36 USERS TEMP 2014-07-07 05:56:36 DEFAULT 10G 11G 12C

62 WMSYS EXPIRED & LOCKED 2014-07-07 06:05:43 2014-07-07 06:05:43 SYSAUX TEMP 2014-07-07 06:05:43 DEFAULT 10G 11G 12C

70 OJVMSYS EXPIRED & LOCKED 2014-07-07 06:07:27 2014-07-07 06:07:27 USERS TEMP 2014-07-07 06:07:27 DEFAULT 10G 11G 12C

73 CTXSYS EXPIRED & LOCKED 2014-07-07 06:12:03 2014-07-07 06:12:03 SYSAUX TEMP 2014-07-07 06:11:11 DEFAULT 10G 11G 12C

75 ORDSYS EXPIRED & LOCKED 2014-07-07 06:12:11 2014-07-07 06:12:11 SYSAUX TEMP 2014-07-07 06:12:11 DEFAULT 10G 11G 12C

79 MDSYS EXPIRED & LOCKED 2014-07-07 06:12:11 2014-07-07 06:12:11 SYSAUX TEMP 2014-07-07 06:12:11 DEFAULT 10G 11G 12C

78 SI_INFORMTN_SCHEMA EXPIRED & LOCKED 2014-07-07 06:12:11 2014-07-07 06:12:11 SYSAUX TEMP 2014-07-07 06:12:11 DEFAULT 10G 11G 12C

77 ORDPLUGINS EXPIRED & LOCKED 2014-07-07 06:12:11 2014-07-07 06:12:11 SYSAUX TEMP 2014-07-07 06:12:11 DEFAULT 10G 11G 12C

76 ORDDATA EXPIRED & LOCKED 2014-07-07 06:12:11 2014-07-07 06:12:11 SYSAUX TEMP 2014-07-07 06:12:11 DEFAULT 10G 11G 12C

82 OLAPSYS EXPIRED & LOCKED 2014-07-07 06:20:30 2014-07-07 06:20:30 SYSAUX TEMP 2014-07-07 06:20:30 DEFAULT 10G 11G 12C

85 MDDATA EXPIRED & LOCKED 2014-07-07 06:52:34 2014-07-07 06:52:34 USERS TEMP 2014-07-07 06:20:54 DEFAULT 10G 11G 12C

87 SPATIAL_WFS_ADMIN_USR EXPIRED & LOCKED 2014-07-07 06:24:57 2014-07-07 06:24:57 USERS TEMP 2014-07-07 06:24:57 DEFAULT 10G 11G 12C

90 SPATIAL_CSW_ADMIN_USR EXPIRED & LOCKED 2014-07-07 06:25:01 2014-07-07 06:25:01 USERS TEMP 2014-07-07 06:25:01 DEFAULT 10G 11G 12C

92 LBACSYS EXPIRED & LOCKED 2014-07-07 06:52:34 2014-07-07 06:52:34 SYSTEM TEMP 2014-07-07 06:29:01 DEFAULT 10G 11G 12C

95 APEX_PUBLIC_USER EXPIRED & LOCKED 2014-07-07 06:29:17 2014-07-07 06:29:17 USERS TEMP 2014-07-07 06:29:17 DEFAULT 10G 11G 12C

98 APEX_040200 EXPIRED & LOCKED 2014-07-07 06:31:11 2014-07-07 06:31:11 SYSAUX TEMP 2014-07-07 06:29:17 DEFAULT 10G 11G 12C

94 FLOWS_FILES EXPIRED & LOCKED 2014-07-07 06:31:11 2014-07-07 06:31:11 SYSAUX TEMP 2014-07-07 06:29:17 DEFAULT 10G 11G 12C

1279990 DVSYS EXPIRED & LOCKED 2014-07-07 06:52:07 2014-07-07 06:52:07 SYSAUX TEMP 2014-07-07 06:51:55 DEFAULT 10G 11G 12C

99 DVF EXPIRED & LOCKED 2014-07-07 06:52:34 2014-07-07 06:52:34 SYSAUX TEMP 2014-07-07 06:51:55 DEFAULT 10G 11G 12C

102 SCOTT EXPIRED & LOCKED 2014-10-27 23:48:05 2014-10-27 23:48:05 USERS TEMP 2014-10-27 23:47:42 DEFAULT 10G 11G 12C

0 SYS OPEN 2015-04-25 23:44:32 SYSTEM TEMP 2014-07-07 05:39:13 DEFAULT 10G 11G 12C

8 SYSTEM OPEN 2015-05-02 18:54:14 SYSTEM TEMP 2014-07-07 05:39:13 DEFAULT 10G 11G 12C 2014-11-03 18:54:49

36 rows selected.

SQL>

在12c中，你还可以通过CDB_USERS查看跨越多个可插拔库的全部用户信息：

SQL> select user_id,username,password,account_status,default_tablespace,temporary_tablespace,profile,password_versions,to_char(last_login,'yyyy-mm-dd hh24:mi:ss') "Last Login",con_id from cdb_users;

   USER_ID USERNAME               PASSWORD     ACCOUNT_STATUS     DEFAULT_T TEMPORARY PROFILE   PASSWORD_VER Last Login              CON_ID
---------- ---------------------- ------------ ------------------ --------- --------- --------- ------------ ------------------- ----------
        36 ORACLE_OCM                          EXPIRED & LOCKED   USERS     TEMP      DEFAULT   10G 11G 12C                               1
        70 OJVMSYS                             EXPIRED & LOCKED   USERS     TEMP      DEFAULT   10G 11G 12C                               1
2147483619 SYSKM                               EXPIRED & LOCKED   USERS     TEMP      DEFAULT   10G 11G 12C                               1
2147483638 XS$NULL                             EXPIRED & LOCKED   USERS     TEMP      DEFAULT   11G                                       1
        61 GSMCATUSER                          EXPIRED & LOCKED   USERS     TEMP      DEFAULT   10G 11G 12C                               1
        85 MDDATA                              EXPIRED & LOCKED   USERS     TEMP      DEFAULT   10G 11G 12C                               1
2147483617 SYSBACKUP                           EXPIRED & LOCKED   USERS     TEMP      DEFAULT   10G 11G 12C                               1
        23 DIP                                 EXPIRED & LOCKED   USERS     TEMP      DEFAULT   10G 11G 12C                               1
2147483618 SYSDG                               EXPIRED & LOCKED   USERS     TEMP      DEFAULT   10G 11G 12C                               1
        95 APEX_PUBLIC_USER                    EXPIRED & LOCKED   USERS     TEMP      DEFAULT   10G 11G 12C                               1
        90 SPATIAL_CSW_ADMIN_USR               EXPIRED & LOCKED   USERS     TEMP      DEFAULT   10G 11G 12C                               1
        87 SPATIAL_WFS_ADMIN_USR               EXPIRED & LOCKED   USERS     TEMP      DEFAULT   10G 11G 12C                               1
        22 GSMUSER                             EXPIRED & LOCKED   USERS     TEMP      DEFAULT   10G 11G 12C                               1
         7 AUDSYS                              EXPIRED & LOCKED   USERS     TEMP      DEFAULT   10G 11G 12C                               1
        94 FLOWS_FILES                         EXPIRED & LOCKED   SYSAUX    TEMP      DEFAULT   10G 11G 12C                               1
        99 DVF                                 EXPIRED & LOCKED   SYSAUX    TEMP      DEFAULT   10G 11G 12C                               1
        79 MDSYS                               EXPIRED & LOCKED   SYSAUX    TEMP      DEFAULT   10G 11G 12C                               1
        75 ORDSYS                              EXPIRED & LOCKED   SYSAUX    TEMP      DEFAULT   10G 11G 12C                               1
        48 DBSNMP                              EXPIRED & LOCKED   SYSAUX    TEMP      DEFAULT   10G 11G 12C                               1
        62 WMSYS                               EXPIRED & LOCKED   SYSAUX    TEMP      DEFAULT   10G 11G 12C                               1
        98 APEX_040200                         EXPIRED & LOCKED   SYSAUX    TEMP      DEFAULT   10G 11G 12C                               1
        49 APPQOSSYS                           EXPIRED & LOCKED   SYSAUX    TEMP      DEFAULT   10G 11G 12C                               1
        21 GSMADMIN_INTERNAL                   EXPIRED & LOCKED   SYSAUX    TEMP      DEFAULT   10G 11G 12C                               1
        76 ORDDATA                             EXPIRED & LOCKED   SYSAUX    TEMP      DEFAULT   10G 11G 12C                               1
        73 CTXSYS                              EXPIRED & LOCKED   SYSAUX    TEMP      DEFAULT   10G 11G 12C  2014-11-02 18:01:11          1
        51 ANONYMOUS                           EXPIRED & LOCKED   SYSAUX    TEMP      DEFAULT   10G                                       1
        50 XDB                                 EXPIRED & LOCKED   SYSAUX    TEMP      DEFAULT   10G 11G 12C                               1
        77 ORDPLUGINS                          EXPIRED & LOCKED   SYSAUX    TEMP      DEFAULT   10G 11G 12C                               1
   1279990 DVSYS                               EXPIRED & LOCKED   SYSAUX    TEMP      DEFAULT   10G 11G 12C                               1
        78 SI_INFORMTN_SCHEMA                  EXPIRED & LOCKED   SYSAUX    TEMP      DEFAULT   10G 11G 12C                               1
        82 OLAPSYS                             EXPIRED & LOCKED   SYSAUX    TEMP      DEFAULT   10G 11G 12C                               1
        92 LBACSYS                             EXPIRED & LOCKED   SYSTEM    TEMP      DEFAULT   10G 11G 12C                               1
        13 OUTLN                               EXPIRED & LOCKED   SYSTEM    TEMP      DEFAULT   10G 11G 12C                               1
         8 SYSTEM                              OPEN               SYSTEM    TEMP      DEFAULT   10G 11G 12C  2014-11-02 19:12:31          1
         0 SYS                                 OPEN               SYSTEM    TEMP      DEFAULT   10G 11G 12C                               1

35 rows selected.

SQL>

SQL> select user_id,username,password,account_status,default_tablespace,temporary_tablespace,profile,password_versions,to_char(last_login,'yyyy-mm-dd hh24:mi:ss') "Last Login",con_id from cdb_users;

USER_ID USERNAME PASSWORD ACCOUNT_STATUS DEFAULT_T TEMPORARY PROFILE PASSWORD_VER Last Login CON_ID

---------- ---------------------- ------------ ------------------ --------- --------- --------- ------------ ------------------- ----------

36 ORACLE_OCM EXPIRED & LOCKED USERS TEMP DEFAULT 10G 11G 12C 1

70 OJVMSYS EXPIRED & LOCKED USERS TEMP DEFAULT 10G 11G 12C 1

2147483619 SYSKM EXPIRED & LOCKED USERS TEMP DEFAULT 10G 11G 12C 1

2147483638 XS$NULL EXPIRED & LOCKED USERS TEMP DEFAULT 11G 1

61 GSMCATUSER EXPIRED & LOCKED USERS TEMP DEFAULT 10G 11G 12C 1

85 MDDATA EXPIRED & LOCKED USERS TEMP DEFAULT 10G 11G 12C 1

2147483617 SYSBACKUP EXPIRED & LOCKED USERS TEMP DEFAULT 10G 11G 12C 1

23 DIP EXPIRED & LOCKED USERS TEMP DEFAULT 10G 11G 12C 1

2147483618 SYSDG EXPIRED & LOCKED USERS TEMP DEFAULT 10G 11G 12C 1

95 APEX_PUBLIC_USER EXPIRED & LOCKED USERS TEMP DEFAULT 10G 11G 12C 1

90 SPATIAL_CSW_ADMIN_USR EXPIRED & LOCKED USERS TEMP DEFAULT 10G 11G 12C 1

87 SPATIAL_WFS_ADMIN_USR EXPIRED & LOCKED USERS TEMP DEFAULT 10G 11G 12C 1

22 GSMUSER EXPIRED & LOCKED USERS TEMP DEFAULT 10G 11G 12C 1

7 AUDSYS EXPIRED & LOCKED USERS TEMP DEFAULT 10G 11G 12C 1

94 FLOWS_FILES EXPIRED & LOCKED SYSAUX TEMP DEFAULT 10G 11G 12C 1

99 DVF EXPIRED & LOCKED SYSAUX TEMP DEFAULT 10G 11G 12C 1

79 MDSYS EXPIRED & LOCKED SYSAUX TEMP DEFAULT 10G 11G 12C 1

75 ORDSYS EXPIRED & LOCKED SYSAUX TEMP DEFAULT 10G 11G 12C 1

48 DBSNMP EXPIRED & LOCKED SYSAUX TEMP DEFAULT 10G 11G 12C 1

62 WMSYS EXPIRED & LOCKED SYSAUX TEMP DEFAULT 10G 11G 12C 1

98 APEX_040200 EXPIRED & LOCKED SYSAUX TEMP DEFAULT 10G 11G 12C 1

49 APPQOSSYS EXPIRED & LOCKED SYSAUX TEMP DEFAULT 10G 11G 12C 1

21 GSMADMIN_INTERNAL EXPIRED & LOCKED SYSAUX TEMP DEFAULT 10G 11G 12C 1

76 ORDDATA EXPIRED & LOCKED SYSAUX TEMP DEFAULT 10G 11G 12C 1

73 CTXSYS EXPIRED & LOCKED SYSAUX TEMP DEFAULT 10G 11G 12C 2014-11-02 18:01:11 1

51 ANONYMOUS EXPIRED & LOCKED SYSAUX TEMP DEFAULT 10G 1

50 XDB EXPIRED & LOCKED SYSAUX TEMP DEFAULT 10G 11G 12C 1

77 ORDPLUGINS EXPIRED & LOCKED SYSAUX TEMP DEFAULT 10G 11G 12C 1

1279990 DVSYS EXPIRED & LOCKED SYSAUX TEMP DEFAULT 10G 11G 12C 1

78 SI_INFORMTN_SCHEMA EXPIRED & LOCKED SYSAUX TEMP DEFAULT 10G 11G 12C 1

82 OLAPSYS EXPIRED & LOCKED SYSAUX TEMP DEFAULT 10G 11G 12C 1

92 LBACSYS EXPIRED & LOCKED SYSTEM TEMP DEFAULT 10G 11G 12C 1

13 OUTLN EXPIRED & LOCKED SYSTEM TEMP DEFAULT 10G 11G 12C 1

8 SYSTEM OPEN SYSTEM TEMP DEFAULT 10G 11G 12C 2014-11-02 19:12:31 1

0 SYS OPEN SYSTEM TEMP DEFAULT 10G 11G 12C 1

35 rows selected.

SQL>

——————————————————
Ending。

Post Views: 562

赏

Adamhuan

Waiting for the moment，热衷数据库技术、Linux/Unix，以及心理学、精神分析等...(etc)，习惯用文字（符号）阐述自己对世界的理解与认知。 ———————— 微信公众号：Leviathan2020 博客：http://www.d-prototype.com

2559

Adamhuan

Leave a Reply Cancel reply