cover.prestreaming.com | ||
Simple .NET/ASP.NET PDF document editor web control SDKYou can also set an identifier that would be part of the trace file name by issuing the following command: SQL> alter session set tracefile_identifier='my_trace_file'; Session altered. The size of the trace files is restricted by the value of the max_dump_file_size initialization parameter set in init.ora for the database instance. You may also alter this at the session level using the alter session command, for example: SQL> alter session set max_dump_file_size = unlimited; Session altered. barcode in microsoft excel 2010, how to print 2d barcode in excel, how to barcode in excel 2010, excel 2d barcode font, tbarcode excel, barcode activex in microsoft office excel 2010, excel 2007 barcode generator free, convert text to barcode in excel 2016, excel barcode schriftart, how to create barcodes in excel 2010,rule token = parse | whitespace { | newline { | "(" { | ")" { | "+" { | "-" { | "*" { | ";" { | ":=" { | ident { | integer { | eof { This results in an assembly, but it s a Dynamic Link Library (DLL) and not an EXE Remember that the Page class is an implementation of the IHttpHandler interface, and, therefore, it plugs into the request processing pipeline of the ASP NET infrastructure (see 2) Another generated type, named FastObjectFactory (under a namespace called __ASP), creates and serves instances of this type to the Framework as requests come in This DLL is just-in-time (JIT) compiled (meaning the IL is transformed to binary executable code) and written to disk This is called a shadow copy DLL (oooh) This shadow copying is the reason you can XCopy a new version of your application to a server while your application is under a production load. The method firstMethod() is overridden to implement the logic of reading the benchmark file line by line from the BFILE column in the table bfile_table: /* reads an ASCII file using BFILE. */ public void firstMethod( Connection conn, Object[] params ) throws Exception { OracleResultSet orset = null; BFILE bfile = null; BufferedReader reader = null; InputStream in = null; long numOfCharacersRead = 0; try { _bfilePstmt.setInt( 1, 1 ); orset = (OracleResultSet) _bfilePstmt.executeQuery(); String line = null; while( orset.next() ) { bfile = orset.getBfile( 1 ); bfile.openFile(); in = bfile.getBinaryStream(); reader = new BufferedReader(new InputStreamReader(in)); numOfCharacersRead = 0; while (( line = reader.readLine() ) != null ) { //System.out.println( line ); numOfCharacersRead += line.length(); } } } finally { if( in != null ) in.close(); if( bfile != null ) bfile.closeFile(); JDBCUtil.close( orset); } //System.out.println( "No of characters read: " + numOfCharacersRead ); } The method secondMethod() is overridden to implement the logic of reading the benchmark file by selecting from the external table et_table: /* reads from a text file using external tables. */ public void secondMethod( Connection conn, Object[] parameters ) throws Exception { ResultSet rset = null; token lexbuf } (lexbuf: lexbuf).EndPos <- lexbuf.EndPos.NextLine; token lexbuf } LPAREN } RPAREN } PLUS } MINUS } TIMES } SEMI } ASSIGN } ident lexbuf (lexeme lexbuf) } INT (Int32.Parse(lexeme lexbuf)) } EOF } long numOfCharacersRead = 0; int prefetchSize = ((Integer) parameters[0]).intValue(); try { _externalTablePstmt.setFetchSize( prefetchSize ); rset = _externalTablePstmt.executeQuery(); numOfCharacersRead = 0; while( rset.next() ) { String line1 = rset.getString(1); numOfCharacersRead += line1.length(); } } finally { JDBCUtil.close( rset); } //System.out.println( "No of characters read: " + numOfCharacersRead ); } The methods _prepareBenchmarkStatements() and _closeBenchmarkStatements() simply prepare and close the SQL statements used to run the appropriate query for the BFILE and external table cases: private static void _prepareBenchmarkStatements( Connection conn ) throws SQLException { String stmtString = "select data from et_table"; _externalTablePstmt = conn.prepareStatement( stmtString ); stmtString = "select bfile_col from bfile_table "+ " where id = "; _bfilePstmt = conn.prepareStatement( stmtString ); } private static void _closeBenchmarkStatements( Connection conn ) throws SQLException { JDBCUtil.close( _bfilePstmt ); JDBCUtil.close( _externalTablePstmt ); } private static final String BFILE_DESC = "Using Bfile"; private static final String EXTERNAL_TABLE_DESC = "Using external table"; private static PreparedStatement _bfilePstmt; private static PreparedStatement _externalTablePstmt; }
|