read sql log file

I usually contact the EBS module is mainly the following: PO, INV, OM. Therefore, it is often necessary to collect the relevant log information. If the interface is reported incorrectly, it is easy to see where the code executes the error from the log.This blog summarizes the methods for collecting several of these logs, along with SQL Trace and FRD log.1. OM Log

The following error occurs when you attach an SQL Server 2000 database to SQL Server 2005 today: An error occurred while appending the database to the server (Microsoft. sqlserver. SMO), the database test cannot be upgraded because it is read-only or has read-only files. Set the database or

Label:This article was reproduced from the blog of Birch Tsaihttp://www.cnblogs.com/lyhabc/archive/2013/07/16/3194220.html explain SQL Server transaction log recordsAs you know, under the full recovery model, SQL Server records the operations that are done by each transaction, which are stored in the transactions log,

The sql2008 shrink log is as follows: The code is as follows Copy Code BACKUP LOG dbname to disk= ' Dbname.log 'DBCC shrinkfile (' Dbname_log ', 1) But remember to perform two times before you can finally perform the contraction; Shrink database files (if not compressed, database files do not reduce Enterprise Manager--right--the database you want to compress--all tas

.log') SIZE 100 M-- STANDBY LOGFILEDATAFILE'/U01/app/oracle/oradata/PROD/disk1/system01.dbf ','/U01/app/oracle/oradata/PROD/disk1/undotbs01.dbf ','/U01/app/oracle/oradata/PROD/disk1/sysaux01.dbf ','/U01/app/oracle/oradata/PROD/disk1/users_01.dbf ','/U01/app/oracle/oradata/PROD/disk1/tools_01.dbf ','/U01/app/oracle/oradata/PROD/disk1/mssm_01.dbf'Character set US7ASCII;========================================================== =========================

Tags: blog http os using AR for file SP dataAfter AlwaysOn is configured, because there is no use of the full recovery model, the simple or bulk-logged mode is not available, so the log is growing and cannot be emptied using the change recovery modeManual operation shrinking or truncating the log is also invalidAfter reading some articles, it was found that someo

Comparison and analysis of the efficiency of php file read/write and database read/write Set_time_limit (0 ); Function fnGet ($ filename) { $ Content = file_get_contents ($ filename ); Return $ content; } Function fnGetContent ($ filename) { $ Content = fnGet ($ filename ); Return $ con

Original: SQL transaction log TransportOverviewYou can use log shipping to send transaction logs uninterrupted from one database (primary database) to another (secondary database). Continuously back up the transaction logs in the primary database, and then copy and restore them to the secondary database, which basically keeps the secondary database in sync with t

size of 18555KB:FileOutputStream execution time consuming: 12063 hao secondsBufferedoutputstream execution time consuming: 1484 Hao secondsFileWriter execution time consuming: 969 Hao seconds As can be seen from the above data, it is not good to write a file without buffering the stream bufferedoutputstream,fileoutputstream. When writing 1000000-line files, FileOutputStream is 11094 milliseconds (11 seconds) slower than FileWriter, and Bufferedoutput

needs to be added, it can only be added at the end of the Innodb_data_file_path configuration, and MySQL must be restarted to complete ibdata additions.3. log file (to be supplemented) 3.1 error logPASS3.2 Binary LogPASS3.3 Query LogQuery log records All of the queries in MySQL and opens the function with the "--log[=

server| Data | database The steps that you must perform when the transaction log expands to an unacceptable limit. The extension of the transaction log will cause the Microsoft SQL Server database to become unusable. In SQL Server 2000, each database contains at least one data file