Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Dynamic Performance (V$) Views, 212 of 237


V$STREAMS_CAPTURE

V$STREAMS_CAPTURE displays information about the capture processes.

Column Datatype Description

SID

NUMBER

Session identifier of the capture process

SERIAL#

NUMBER

Session serial number of the capture process

CAPTURE#

NUMBER

Capture process number. A capture process is an Oracle background process, prefixed by CP.

CAPTURE_NAME

VARCHAR2(30)

Name of the capture process

STARTUP_TIME

DATE

Time when the capture started

STATE

VARCHAR2(17)

State of the capture process (INITIALIZING, CAPTURING CHANGES, EVALUATING RULE, ENQUEUING MESSAGE, SHUTTING DOWN, or CREATING LCR)

TOTAL_MESSAGES_CAPTURED

NUMBER

Total changes captured

CAPTURE_TIME

DATE

Time when the most recent message was captured

CAPTURE_MESSAGE_NUMBER

NUMBER

Number of the most recent message

CAPTURE_MESSAGE_CREATE_TIME

DATE

Creation time of the most recent message

TOTAL_MESSAGES_ENQUEUED

NUMBER

Total number of messages enqueued

ENQUEUE_TIME

DATE

Time when the last message was enqueued

ENQUEUE_MESSAGE_NUMBER

NUMBER

Number of the last enqueued message

ENQUEUE_MESSAGE_CREATE_TIME

DATE

Creation time of the last enqueued message

ELAPSED_CAPTURE_TIME

NUMBER

Elapsed time capturing changes

ELAPSED_RULE_TIME

NUMBER

Elapsed time evaluating rules

ELAPSED_ENQUEUE_TIME

NUMBER

Elapsed time enqueuing messages

ELAPSED_LCR_TIME

NUMBER

Elapsed time creating lcrs


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback