File: oracle.txt

package info (click to toggle)
pspg 5.8.16-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 12,368 kB
  • sloc: ansic: 23,416; sh: 101; makefile: 94; sql: 54
file content (29 lines) | stat: -rw-r--r-- 33,076 bytes parent folder | download | duplicates (3)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29

                    TABLE_NAME    TABLESPACE_NAME    CLUSTER_NAME    IOT_NAME    STATUS    PCT_FREE    PCT_USED    INI_TRANS    MAX_TRANS    INITIAL_EXTENT    NEXT_EXTENT    MIN_EXTENTS    MAX_EXTENTS    PCT_INCREASE    FREELISTS    FREELIST_GROUPS    LOGGING    BACKED_UP    NUM_ROWS    BLOCKS    EMPTY_BLOCKS    AVG_SPACE    CHAIN_CNT    AVG_ROW_LEN    AVG_SPACE_FREELIST_BLOCKS    NUM_FREELIST_BLOCKS        DEGREE     INSTANCES    CACHE    TABLE_LOCK    SAMPLE_SIZE    LAST_ANALYZED    PARTITIONED    IOT_TYPE    TEMPORARY    SECONDARY    NESTED    BUFFER_POOL    FLASH_CACHE    CELL_FLASH_CACHE    ROW_MOVEMENT    GLOBAL_STATS    USER_STATS           DURATION    SKIP_CORRUPT    MONITORING    CLUSTER_OWNER    DEPENDENCIES    COMPRESSION    COMPRESS_FOR    DROPPED    READ_ONLY    SEGMENT_CREATED    RESULT_CACHE    CLUSTERING    ACTIVITY_TRACKING    DML_TIMESTAMP    HAS_IDENTITY    CONTAINER_DATA    INMEMORY    INMEMORY_PRIORITY    INMEMORY_DISTRIBUTE    INMEMORY_COMPRESSION    INMEMORY_DUPLICATE    DEFAULT_COLLATION    DUPLICATED    SHARDED    EXTERNAL    CELLMEMORY    CONTAINERS_DEFAULT    CONTAINER_MAP    EXTENDED_DATA_LINK    EXTENDED_DATA_LINK_MAP    INMEMORY_SERVICE    INMEMORY_SERVICE_NAME    CONTAINER_MAP_OBJECT    MEMOPTIMIZE_READ    MEMOPTIMIZE_WRITE    HAS_SENSITIVE_COLUMN 
______________________________ __________________ _______________ ___________ _________ ___________ ___________ ____________ ____________ _________________ ______________ ______________ ______________ _______________ ____________ __________________ __________ ____________ ___________ _________ _______________ ____________ ____________ ______________ ____________________________ ______________________ _____________ _____________ ________ _____________ ______________ ________________ ______________ ___________ ____________ ____________ _________ ______________ ______________ ___________________ _______________ _______________ _____________ __________________ _______________ _____________ ________________ _______________ ______________ _______________ __________ ____________ __________________ _______________ _____________ ____________________ ________________ _______________ _________________ ___________ ____________________ ______________________ _______________________ _____________________ ____________________ _____________ __________ ___________ _____________ _____________________ ________________ _____________________ _________________________ ___________________ ________________________ _______________________ ___________________ ____________________ _______________________ 
LOGMNR_SESSION_EVOLVE$         SYSAUX                                         VALID              10                        1          255             65536        1048576              1     2147483645                                                 YES        N                      0         0               0            0            0              0                            0                      0          1             1        N    ENABLED                    0 18-OCT-18        NO                         N            N            NO        DEFAULT        DEFAULT        DEFAULT             DISABLED        YES             NO                               DISABLED        YES                            DISABLED        DISABLED                       NO         NO           YES                DEFAULT         NO                                                  NO              NO                DISABLED                                                                                              USING_NLS_COMP       N             N          NO                        NO                    NO               NO                    NO                                                                     NO                      DISABLED            DISABLED             NO                      
LOGMNR_GLOBAL$                 SYSAUX                                         VALID              10                        1          255             65536        1048576              1     2147483645                                                 YES        N                      0         0               0            0            0              0                            0                      0          1             1        N    ENABLED                    0 18-OCT-18        NO                         N            N            NO        DEFAULT        DEFAULT        DEFAULT             DISABLED        YES             NO                               DISABLED        YES                            DISABLED        DISABLED                       NO         NO           YES                DEFAULT         NO                                                  NO              NO                DISABLED                                                                                              USING_NLS_COMP       N             N          NO                        NO                    NO               NO                    NO                                                                     NO                      DISABLED            DISABLED             NO                      
LOGMNR_PDB_INFO$               SYSAUX                                         VALID              10                        1          255             65536        1048576              1     2147483645                                                 YES        N                      0         0               0            0            0              0                            0                      0          1             1        N    ENABLED                    0 18-OCT-18        NO                         N            N            NO        DEFAULT        DEFAULT        DEFAULT             DISABLED        YES             NO                               DISABLED        YES                            DISABLED        DISABLED                       NO         NO           YES                DEFAULT         NO                                                  NO              NO                DISABLED                                                                                              USING_NLS_COMP       N             N          NO                        NO                    NO               NO                    NO                                                                     NO                      DISABLED            DISABLED             NO                      
LOGMNR_DID$                    SYSAUX                                         VALID              10                        1          255             65536        1048576              1     2147483645                                                 YES        N                      0         0               0            0            0              0                            0                      0          1             1        N    ENABLED                    0 18-OCT-18        NO                         N            N            NO        DEFAULT        DEFAULT        DEFAULT             DISABLED        YES             NO                               DISABLED        YES                            DISABLED        DISABLED                       NO         NO           YES                DEFAULT         NO                                                  NO              NO                DISABLED                                                                                              USING_NLS_COMP       N             N          NO                        NO                    NO               NO                    NO                                                                     NO                      DISABLED            DISABLED             NO                      
LOGMNR_UID$                    SYSAUX                                         VALID              10                        1          255             65536        1048576              1     2147483645                                                 YES        N                      0         0               0            0            0              0                            0                      0          1             1        N    ENABLED                    0 18-OCT-18        NO                         N            N            NO        DEFAULT        DEFAULT        DEFAULT             DISABLED        YES             NO                               DISABLED        YES                            DISABLED        DISABLED                       NO         NO           YES                DEFAULT         NO                                                  NO              NO                DISABLED                                                                                              USING_NLS_COMP       N             N          NO                        NO                    NO               NO                    NO                                                                     NO                      DISABLED            DISABLED             NO                      
LOGMNRGGC_GTLO                 SYSTEM                                         VALID              10          40            1          255             65536        1048576              1     2147483645                            1                  1 YES        N                      0         0               0            0            0              0                            0                      0          1             1        N    ENABLED                    0 18-OCT-18        NO                         N            N            NO        DEFAULT        DEFAULT        DEFAULT             DISABLED        YES             NO                               DISABLED        YES                            DISABLED        DISABLED                       NO         NO           YES                DEFAULT         NO                                                  NO              NO                DISABLED                                                                                              USING_NLS_COMP       N             N          NO                        NO                    NO               NO                    NO                                                                     NO                      DISABLED            DISABLED             NO                      
LOGMNRGGC_GTCS                 SYSTEM                                         VALID              10          40            1          255             65536        1048576              1     2147483645                            1                  1 YES        N                      0         0               0            0            0              0                            0                      0          1             1        N    ENABLED                    0 18-OCT-18        NO                         N            N            NO        DEFAULT        DEFAULT        DEFAULT             DISABLED        YES             NO                               DISABLED        YES                            DISABLED        DISABLED                       NO         NO           YES                DEFAULT         NO                                                  NO              NO                DISABLED                                                                                              USING_NLS_COMP       N             N          NO                        NO                    NO               NO                    NO                                                                     NO                      DISABLED            DISABLED             NO                      
LOGMNRC_DBNAME_UID_MAP         SYSAUX                                         VALID              10                        1          255             65536        1048576              1     2147483645                                                 YES        N                      0         0               0            0            0              0                            0                      0          1             1        N    ENABLED                    0 18-OCT-18        NO                         N            N            NO        DEFAULT        DEFAULT        DEFAULT             DISABLED        YES             NO                               DISABLED        YES                            DISABLED        DISABLED                       NO         NO           YES                DEFAULT         NO                                                  NO              NO                DISABLED                                                                                              USING_NLS_COMP       N             N          NO                        NO                    NO               NO                    NO                                                                     NO                      DISABLED            DISABLED             NO                      
LOGMNR_LOG$                    SYSAUX                                         VALID              10                        1          255             65536        1048576              1     2147483645                                                 YES        N                      0         0               0            0            0              0                            0                      0          1             1        N    ENABLED                    0 18-OCT-18        NO                         N            N            NO        DEFAULT        DEFAULT        DEFAULT             DISABLED        YES             NO                               DISABLED        YES                            DISABLED        DISABLED                       NO         NO           YES                DEFAULT         NO                                                  NO              NO                DISABLED                                                                                              USING_NLS_COMP       N             N          NO                        NO                    NO               NO                    NO                                                                     NO                      DISABLED            DISABLED             NO                      
LOGMNR_PROCESSED_LOG$          SYSAUX                                         VALID              10                        1          255             65536        1048576              1     2147483645                                                 YES        N                      0         0               0            0            0              0                            0                      0          1             1        N    ENABLED                    0 18-OCT-18        NO                         N            N            NO        DEFAULT        DEFAULT        DEFAULT             DISABLED        YES             NO                               DISABLED        YES                            DISABLED        DISABLED                       NO         NO           YES                DEFAULT         NO                                                  NO              NO                DISABLED                                                                                              USING_NLS_COMP       N             N          NO                        NO                    NO               NO                    NO                                                                     NO                      DISABLED            DISABLED             NO                      
LOGMNR_SPILL$                  SYSAUX                                         VALID              10                        1          255             65536        1048576              1     2147483645                                                 YES        N                      0         0               0            0            0              0                            0                      0          1             1        N    ENABLED                    0 18-OCT-18        NO                         N            N            NO        DEFAULT        DEFAULT        DEFAULT             DISABLED        YES             NO                               DISABLED        YES                            DISABLED        DISABLED                       NO         NO           YES                DEFAULT         NO                                                  NO              NO                DISABLED                                                                                              USING_NLS_COMP       N             N          NO                        NO                    NO               NO                    NO                                                                     NO                      DISABLED            DISABLED             NO                      
LOGMNR_AGE_SPILL$              SYSAUX                                         VALID              10                        1          255             65536        1048576              1     2147483645                                                 YES        N                      0         0               0            0            0              0                            0                      0          1             1        N    ENABLED                    0 18-OCT-18        NO                         N            N            NO        DEFAULT        DEFAULT        DEFAULT             DISABLED        YES             NO                               DISABLED        YES                            DISABLED        DISABLED                       NO         NO           YES                DEFAULT         NO                                                  NO              NO                DISABLED                                                                                              USING_NLS_COMP       N             N          NO                        NO                    NO               NO                    NO                                                                     NO                      DISABLED            DISABLED             NO                      
LOGMNR_RESTART_CKPT_TXINFO$    SYSAUX                                         VALID              10                        1          255             65536        1048576              1     2147483645                                                 YES        N                      0         0               0            0            0              0                            0                      0          1             1        N    ENABLED                    0 18-OCT-18        NO                         N            N            NO        DEFAULT        DEFAULT        DEFAULT             DISABLED        YES             NO                               DISABLED        YES                            DISABLED        DISABLED                       NO         NO           YES                DEFAULT         NO                                                  NO              NO                DISABLED                                                                                              USING_NLS_COMP       N             N          NO                        NO                    NO               NO                    NO                                                                     NO                      DISABLED            DISABLED             NO                      
LOGMNR_ERROR$                  SYSAUX                                         VALID              10                        1          255             65536        1048576              1     2147483645                                                 YES        N                      0         0               0            0            0              0                            0                      0          1             1        N    ENABLED                    0 18-OCT-18        NO                         N            N            NO        DEFAULT        DEFAULT        DEFAULT             DISABLED        YES             NO                               DISABLED        YES                            DISABLED        DISABLED                       NO         NO           YES                DEFAULT         NO                                                  NO              NO                DISABLED                                                                                              USING_NLS_COMP       N             N          NO                        NO                    NO               NO                    NO                                                                     NO                      DISABLED            DISABLED             NO                      
LOGMNR_KOPM$                                                                  VALID                                                                                                                                                                                 N                      0         0               0            0            0              0                            0                      0          1             1        N    ENABLED                    0 18-OCT-18        YES                        N            N            NO        DEFAULT        DEFAULT        DEFAULT             DISABLED        YES             NO                               DISABLED        YES                            DISABLED                                       NO         N/A          N/A                DEFAULT         NO                                                  NO              NO                                                                                                                      USING_NLS_COMP       N             N          NO                        NO                    NO               NO                    NO                                                                     NO                      N/A                 N/A                  NO                      
LOGMNR_PROPS$                                                                 VALID                                                                                                                                                                                 N                      0         0               0            0            0              0                            0                      0          1             1        N    ENABLED                    0 18-OCT-18        YES                        N            N            NO        DEFAULT        DEFAULT        DEFAULT             DISABLED        YES             NO                               DISABLED        YES                            DISABLED                                       NO         N/A          N/A                DEFAULT         NO                                                  NO              NO                                                                                                                      USING_NLS_COMP       N             N          NO                        NO                    NO               NO                    NO                                                                     NO                      N/A                 N/A                  NO                      
LOGMNR_ENC$                                                                   VALID                                                                                                                                                                                 N                      0         0               0            0            0              0                            0                      0          1             1        N    ENABLED                    0 18-OCT-18        YES                        N            N            NO        DEFAULT        DEFAULT        DEFAULT             DISABLED        YES             NO                               DISABLED        YES                            DISABLED                                       NO         N/A          N/A                DEFAULT         NO                                                  NO              NO                                                                                                                      USING_NLS_COMP       N             N          NO                        NO                    NO               NO                    NO                                                                     NO                      N/A                 N/A                  NO                      
LOGMNR_REFCON$                                                                VALID                                                                                                                                                                                 N                      0         0               0            0            0              0                            0                      0          1             1        N    ENABLED                    0 18-OCT-18        YES                        N            N            NO        DEFAULT        DEFAULT        DEFAULT             DISABLED        YES             NO                               DISABLED        YES                            DISABLED                                       NO         N/A          N/A                DEFAULT         NO                                                  NO              NO                                                                                                                      USING_NLS_COMP       N             N          NO                        NO                    NO               NO                    NO                                                                     NO                      N/A                 N/A                  NO                      
LOGMNR_IDNSEQ$                                                                VALID                                                                                                                                                                                 N                      0         0               0            0            0              0                            0                      0          1             1        N    ENABLED                    0 18-OCT-18        YES                        N            N            NO        DEFAULT        DEFAULT        DEFAULT             DISABLED        YES             NO                               DISABLED        YES                            DISABLED                                       NO         N/A          N/A                DEFAULT         NO                                                  NO              NO                                                                                                                      USING_NLS_COMP       N             N          NO                        NO                    NO               NO                    NO                                                                     NO                      N/A                 N/A                  NO                      
LOGMNR_PARTOBJ$                                                               VALID                                                                                                                                                                                 N                      0         0               0            0            0              0                            0                      0          1             1        N    ENABLED                    0 18-OCT-18        YES                        N            N            NO        DEFAULT        DEFAULT        DEFAULT             DISABLED        YES             NO                               DISABLED        YES                            DISABLED                                       NO         N/A          N/A                DEFAULT         NO                                                  NO              NO                                                                                                                      USING_NLS_COMP       N             N          NO                        NO                    NO               NO                    NO                                                                     NO                      N/A                 N/A                  NO                      
LOGMNRP_CTAS_PART_MAP                                                         VALID                                                                                                                                                                                 N                      0         0               0            0            0              0                            0                      0          1             1        N    ENABLED                    0 18-OCT-18        YES                        N            N            NO        DEFAULT        DEFAULT        DEFAULT             DISABLED        YES             NO                               DISABLED        YES                            DISABLED                                       NO         N/A          N/A                DEFAULT         NO                                                  NO              NO                                                                                                                      USING_NLS_COMP       N             N          NO                        NO                    NO               NO                    NO                                                                     NO                      N/A                 N/A                  NO                      
LOGMNR_SHARD_TS                                                               VALID                                                                                                                                                                                 N                      0         0               0            0            0              0                            0                      0          1             1        N    ENABLED                    0 18-OCT-18        YES                        N            N            NO        DEFAULT        DEFAULT        DEFAULT             DISABLED        YES             NO                               DISABLED        YES                            DISABLED                                       NO         N/A          N/A                DEFAULT         NO                                                  NO              NO                                                                                                                      USING_NLS_COMP       N             N          NO                        NO                    NO               NO                    NO                                                                     NO                      N/A                 N/A                  NO                      
LOGSTDBY$APPLY_PROGRESS                                                       VALID                                                                                                                                                                                 N                      0         0               0            0            0              0                            0                      0          1             1        N    ENABLED                    0 18-OCT-18        YES                        N            N            NO        DEFAULT        DEFAULT        DEFAULT             DISABLED        YES             NO                               DISABLED        YES                            DISABLED                                       NO         N/A          N/A                DEFAULT         NO                                                  NO              NO                                                                                                                      USING_NLS_COMP       N             N          NO                        NO                    NO               NO                    NO                                                                     NO                      N/A                 N/A                  NO                      

131 rows selected.