select * from v$diag_info;
cd /u01/app/oracle/diag/rdbms/orcl/orcl/trace
cat alert_orcl.log
show variables like '%log%';
show variables like 'long_query_time';
vim /etc/my.cnf
・一般クエリの実行ログ(General query log)
general_log=1
general_log_file="/var/lib/mysql/mmm050.log"
log_output=FILE
・スロークエリの発生ログ(Slow query log)
slow_query_log=1
slow_query_log_file="/var/lib/mysql/mmm050-slow.log"
log_queries_not_using_indexes
--スロークエリーログに書き込まれるステートメントにスロー管理ステートメントを含めます。
log_slow_admin_statements
long_query_time=0.7
・バイナリログ(Binary log)
log_bin="mysql-bin-log"
log_bin_index="/var/lib/mysql/bin.list"
max_binlog_size=1073741824
expire_logs_days=7
server-id=101
・エラーログ(Error log)
log_error="/var/log/mysqld.log"
log_warnings=2
--一般クエリログとスロークエリログのDBへの出力
log_output=TABLE
select * from mysql.general_log;
select * from mysql.slow_log;
cd /var/lib/pgsql/9.4/data
vim postgresql.conf
log_destination = csvlog
logging_collector = 'on'
log_directory = 'pg_log'
log_filename = 'postgresql-%Y-%m-%d_%H%M.log'
log_line_prefix = '[%t][%p][%u][%d] '
log_rotation_age = '1d'
log_rotation_size = 10MB
log_min_messages = 'warning'
log_min_error_statement = 'error'
log_min_duration_statement = 1000
log_autovacuum_min_duration = 20000
log_checkpoints = 'on'
log_connections = 'on'
log_disconnections ='on'
log_duration = 'on'
log_lock_waits ='on'
log_statement = 'all'
log_temp_files = 2000
C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Log
ERRORLOG