Skip to content

Query is stuck on LogMiner view #101

@VaibhaveS

Description

@VaibhaveS

Hi, I am trying to read the redo logs from logminer, but it seems stuck at stmt.query, it never returns. Any idea?

    let start_logminer_sql = format!(
        "BEGIN 
           SYS.DBMS_LOGMNR.START_LOGMNR(
             STARTSCN => {},
             OPTIONS => SYS.DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + 
                        SYS.DBMS_LOGMNR.CONTINUOUS_MINE
           );
         END;",
        current_scn
    );
    
    oracle_conn.execute(&start_logminer_sql, &[])?;
    let query = "
            SELECT 
                SCN,
                TIMESTAMP,
                OPERATION,
                SEG_OWNER,
                TABLE_NAME,
                SQL_REDO
            FROM V$LOGMNR_CONTENTS
            WHERE SCN > :1 AND SCN <= :2
            AND OPERATION IN ('INSERT', 'UPDATE', 'DELETE')
            AND SEG_OWNER NOT IN ('SYS', 'SYSTEM')
            ORDER BY SCN
        ";
        
        println!("Querying for changes with SCN range {} to {}", last_processed_scn, end_scn);
        
        let mut stmt = oracle_conn.statement(query).build()?;
        
        let mut result_rows = stmt.query(&[&last_processed_scn, &end_scn]);

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions