package com.fitbank.common;

import java.sql.CallableStatement;

/**
 * Calse que se encarga de habilitar un trace para la session en la base de datos. 
 * @author FitBank
 * @version 2.0
 */
public class TraceHelper {
	
	/**
	 * Habilita el trace para una session.  
	 * @throws Exception
	 */
	public static void sessionTraceEnable() throws Exception {
    	CallableStatement cstmt = null;
    	cstmt = (CallableStatement) Helper.getConnection().prepareCall( "begin DBMS_MONITOR.session_trace_enable; end;" );
    	cstmt.execute();
	}

	/**
	 * Deshabilita el trace para una session 
	 * @throws Exception
	 */
	public static void sessionTraceDisable() throws Exception {
    	CallableStatement cstmt = null;
    	cstmt = (CallableStatement)Helper.getConnection().prepareCall( "begin DBMS_MONITOR.session_trace_disable; end;" );
    	cstmt.execute();		
	}
	
}