-
编辑 删除
ORACLE调优20130411
调优方式：sql配置硬件 10g出现awr9i是statspackawr对应的视图当一个节点异常的时候，可以通过另外一个节点上来生成awr报告 exec DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT &nb...
-
编辑 删除
ORACLE调优20130412
ACS--自适应游标，11g默认开；根据绑定变量来选择执行计划等待和默认参数的研究等待类型，官方文档查看v$event_namenetwork 等待一般小于3ms等待class---重要前提和后台的因果，一般后台是因，也有例外other...
-
编辑 删除
3-4tuning the shared pool
3-4tuning the shared poollibrary cachedata dictionary cacheUser global area--一般放在large poolshared pool:shared_pool_sizeSGA_TARGET--10G开始提供library cache:LRU算法used to prevent sta...
-
编辑 删除
3-3DB configuration and IO issuse
3-3DB configuration and IO issusethree standard storagefile system:network attached storage(NAS)SAN --storage area networkdirect attached storageRaw partitions --被淘汰Automatic Storage ma...
-
编辑 删除
3-2Tunning Tools
3-2Tunning Tools每天检查alert日志路径检查：show parameter dump关注ORA-错误关注点：Detect internal errors(ORA-600) and block corrption errosMonitor database operationsView the nondefault initia...
-
编辑 删除
3-1 Overview of tunning
3-1 Overview of tunning what does the dba tune?performance tuning areas:1、Application:SQL statement performance change managementshared with developers 2、Instance tuning:Memo...
