MySQL Slave lag很高，逐渐增加，表面现象是slave
sql进程很慢，从MySQL角度已经找到原因，在此通过perf验证。
perf是一款Linux性能分析工具。Linux性能计数器是一个新的基于内核的子系统，它提供一个性能分析框架，比如硬件（CPU、PMU(Performance
Monitoring
Unit)）功能和软件(软件计数器、tracepoint)功能。通过perf，应用程序可以利用PMU、tracepoint和内核中的计数器来进行性能统计。它不但可以分析制定应用程序的性能问题（per
thread），也可以用来分析内核的性能问题。
3. High-Frequency Automatic Optimizer
Statistics Collection
高频自动优化器统计收集
您可以配置轻量级，高频率的自动任务，定期收集过时对象的优化程序统计信息。在执行DBMS_STATS统计信息收集作业之间，统
SELECT a.ksppinm 'Parameter', b.ksppstvl 'Session
Value', c.ksppstvl 'Instance Value'
FROM x$ksppi a, x$ksppcv b, x$ksppsv c
WHERE a.indx = b.indx AND a.indx = c.indx
AND SUBSTR(ksppinm,1,1)='_'
ORDER BY a.ksppinm;
alter system set db_file_multiblock_read_count=32 scope=spfile
sid='*';
alter system set max_dump_file_size = '500M' scope=spfile
sid='*';
alter system set '_memory_imm_mode_without_autosga'=FALSE
scope=spfile sid='*';
alter system set job_queue_processes=100 scope=spfile
sid='*';
alter system set DB_FILES=4096 scope=spfile sid='*';
alter system set nls_date_format='YYYY-MM-DD HH24:MI:SS'
scope=spfile sid='*';
alter system set open_cursors=3000 scope=spfile sid='*';
alter system set open_links_per_instance=48 scope=spfile
sid='*';
alter system set open_links=100
Clusterized commands are completely operating system
independent; they rely on the OHASD (Oracle High Availability
Services daemon).
If this daemon is running, then you can perform remote
operations, such as the starting, stopping, and checking the status
of remote nodes.
Clusterized commands include the following:
crsctl check cluster
crsctl start cluster
crsctl stop cluster
$ crsctl status resource -t
$ crsctl check cluster -all
[root@19c01 bin]# pwd
/u01/app/19.3.0/grid/bin
[root@19c01 bin]#
[root@19c01 bin]# ./crsctl stop cluster -all
[root@19c01 bin]# ./crsctl stop cluster -n node1
[root@19c01 bin]# ./crsctl stop crs ###every
node
[root@19c01 bin]# ./crsctl start crs ###every node(you
need not execute 'crsctl sta
load data
infile '/oracle/t_ash_dec_25.txt'
append into table t_ash_dec_25
fields terminated by ','
trailing nullcols
(DBID, INSTANCE_NUMBER, SAMPLE_ID, SAMPLE_TIME, SESSION_ID,
SESSION_SERIAL#, USER_ID, SQL_ID, SQL_CHILD_NUMBER,
SQL_PLAN_HASH_VALUE, SERVICE_HASH, SESSION_TYPE, SQL_OPCODE,
PLSQL_ENTRY_OBJECT_ID, PLSQL_ENTRY_SUBPROGRAM_ID, PLSQL_OBJECT_ID,
PLSQL_SUBPROGRAM_ID, BLOCKING_SESSION, BLOCKING_SESSION_SERIAL#,
QC_SESSION_ID, QC_INSTANCE_ID, XID, CURRENT_OBJ#, CURRENT_FILE#,
CURRENT_BLOCK#, EVENT_ID, SEQ#, P1, P2, P3, WAIT_TIME, TIME_WAITED,
FLAGS, FORCE_MATCHING_SIGNATURE, PROGRAM, MODULE, ACTION,
CLIENT_ID, MACHINE, PORT, ECID)
oracle@DBxxx01$ls -lt load*
-rw-r--r-- 1 oracle oinstall
4825 Dec 29 11:28 load_data_ash.log
-rw-r--r-- 1 oracle oinstall
&nb
http://www.cnblogs.com/zscyun/p/3314877.html
架构构建块可以说是企业架构内容的核心，也是企业架构开发方法的最终产物。
http://www.cnblogs.com/zscyun/p/3357211.html
5. 架构合同
架构合同是在开发团体和赞助者之间关于架构的交付物、质量以及适用目标的联合协议，并且通过有效的架构治理将会促使这些协议的成功施行。
6. 架构成熟度模型
对于很多组织来说，在哪些方面进行改
加载中…
转载▼