PDA

View Full Version : Querying Dbvisit transfer process


Arjen Visser
06-09-2008, 09:29 PM
The following query can be used to display the entries from the Dbvisit transfer process from the primary server to the standby server.
This SQL will create a spool file called dbv_transfer.log which contains the records.

clear col
set heading on
column c1 heading SID format A10
column c2 heading seq format 999999
column c3 heading archive format A32
column c4 heading timestamp format A15
column c5 heading process format A8
column c6 heading start format A17
column c7 heading end format A17
column c8 heading source format A10
column c9 heading dest format A10
column c10 heading MB format 999999
column c11 heading CMP format A3
column c12 heading LOG_ID format 99999999999
set pagesize 100
set linesize 10000
set trimspool on
set verify off
set echo off
set tab off
set space 1
set serveroutput on
spool dbv_transfer.log
select
ORACLE_SID c1
,SEQUENCE# c2
,substr(ARCHIVE_NAME,length(ARCHIVE_NAME)-30, length(ARCHIVE_NAME)) c3
,PROCESS c5
,TIMESTAMP c4
,to_char(START_TIME_DATE,'yyyymmdd hh24:mi:ss') c6
,to_char(END_TIME_DATE,'yyyymmdd hh24:mi:ss') c7
,UPPER_SOURCE_HOST c8
,UPPER_DESTINATION_HOST c9
,round(SIZE_IN_BYTES/1024/1024,2) c10
,PROCESS_COMPLETED c11
,LOG_ID c12
from dbvisit.dbv_transfer_log
order by sequence#,
process
;
spool off
set heading off
/