数据库维护手册第1页目录1前言................................................................................................42ORACLE维护方法......................................................................42.1数据库启动..............................................................................................................42.2数据库停止..............................................................................................................52.3监听器的启停...........................................................................................................52.4用户管理..................................................................................................................62.5数据库参数文件.......................................................................................................62.6数据库概况的查询...................................................................................................72.7常用对象的创建和使用...........................................................................................82.8失效数据库对象的检测和编译...............................................................................92.9数据备份的技巧.....................................................................................................102.10数据库命中率的监测.............................................................................................112.11最消耗资源进程的检测.........................................................................................112.12锁的监测及处理.....................................................................................................122.13SQL语句执行技巧..................................................................................................132.14表空间的管理.........................................................................................................142.15数据文件I/O的统计优化.....................................................................................152.16错误号的跟踪出理.................................................................................................153日常问题处理流程......................................................................163.1ORACLE数据库日常检查........................................................................................163.2会话连接日志的清理.............................................................................................163.3数据库hang住时的停止和方法...........................................................................163.4扩表空间方法.........................................................................................................173.5死锁会话的杀死.....................................................................................................173.6未决两阶段事务的回滚.........................................................................................184相关通用工具介绍......................................................................184.1EM工具....................................................................................................................18第2页1前言本文主要是简单介绍和总结日常Oracle数据在运行维护方面的一些方法和技巧。通过该手册以便于相关技术人员的日常运维工作。2ORACLEDB维护方法2.1数据库启动1、以oracle用户用户登录，sqlplus‘/assysdba’sqlplus>startup2...
