ITPub博客

OS: SunOS 5.9DB: Oracle RDBMS 9.2.0.7 64bitCase: 业务应用程序运行缓慢，出现Hung住现象[@more@]诊断思路：一：检测OS性能，分析定位问题二：检测数据库等待，判断问题原因三：处理措施1、检测OS性能信息load averages: 2.75, 2.77, 2.96; up 18+00:54:02 11:02:53377 processes: 372 sleeping, 1 stopped, 4 on cpuCPU states: 75.6% idle, 22.4% user, 1.0% kernel, 1.1% iowait, 0.0% swapMemory: 24G phys mem, 3806M free mem, 31G swap, 29G free swapPID USERNAME LWP PRI NICE SIZE RES STATE TIME CPU COMMAND6766 oracle9i 2