表格:sys.STREAMS$_PROCESS_PARAMS存储所有的stream进程参数,包含隐含参数。

desc sys.STREAMS$_PROCESS_PARAMS

SQL> desc sys.STREAMS$_PROCESS_PARAMS
Name              Type           Nullable Default Comments
—————– ————– ——– ——- ——–
PROCESS_TYPE      NUMBER
PROCESS#          NUMBER
NAME              VARCHAR2(128)
VALUE             VARCHAR2(4000) Y
USER_CHANGED_FLAG NUMBER         Y
INTERNAL_FLAG     NUMBER         Y
SPARE1            NUMBER         Y

select * from sys.STREAMS$_PROCESS_PARAMS where process_type=2

PROCESS_TYPE   PROCESS# NAME                                                                             VALUE                                                                            USER_CHANGED_FLAG INTERNAL_FLAG     SPARE1
———— ———- ——————————————————————————– ——————————————————————————– —————– ————- ———-
2          1 DISABLE_ON_LIMIT                                                                 N                                                                                                0             0
2          1 DOWNSTREAM_REAL_TIME_MINE                                                        N                                                                                                0             0
2          1 MAXIMUM_SCN                                                                      INFINITE                                                                                         0             0
2          1 MESSAGE_LIMIT                                                                    INFINITE                                                                                         0             0
2          1 PARALLELISM                                                                      1                                                                                                1             0
2          1 STARTUP_SECONDS                                                                  0                                                                                                0             0
2          1 TIME_LIMIT                                                                       INFINITE                                                                                         0             0
2          1 TRACE_LEVEL                                                                      0                                                                                                0             0
2          1 WRITE_ALERT_LOG                                                                  Y                                                                                                0             0
2          1 _CHECKPOINTS_PER_DAY                                                             4                                                                                                0             1
2          1 _CHECKPOINT_FORCE                                                                N                                                                                                0             1
2          1 _CHECKPOINT_FREQUENCY                                                            2000                                                                                             1             1
2          1 _CKPT_FORCE_FREQ                                                                 1800                                                                                             0             1
2          1 _CKPT_RETENTION_CHECK_FREQ                                                       21600                                                                                            0             1
2          1 _IGNORE_TRANSACTION                                                                                                                                                               0             1
2          1 _LOGMINER_IDLE_READ_POLL_FREQ                                                    0                                                                                                0             1
2          1 _MIN_DAYS_KEEP_ALL_CKPTS                                                         1                                                                                                0             1
2          1 _SEND_STREAMS_DICTIONARY                                                         0                                                                                                0             1
2          1 _SGA_SIZE                                                                        1024                                                                                             1             1
2          1 _SKIP_LCR_FOR_ASSERT                                                                                                                                                              0             1

PROCESS_TYPE   PROCESS# NAME                                                                             VALUE                                                                            USER_CHANGED_FLAG INTERNAL_FLAG     SPARE1
———— ———- ——————————————————————————– ——————————————————————————– —————– ————- ———-
2          1 _TURN_OFF_LIMIT_READ                                                             N                                                                                                0             1




Related posts

coded by nessus
分享:  DeliciousGReader鲜果豆瓣CSDN网摘
Trackback

only 1 comment untill now

  1. libraries@dobbs.backpack” rel=”nofollow”>.…

    ñïàñèáî çà èíôó….

Add your comment now

无觅相关文章插件