oracle 变慢怎么解决方法,oracle数据库变得非常慢解决方案一例.doc

oracle数据库变得非常慢解决方案一例.doc

ORACLE数据库变得非常慢解决方案一例数据库变得非常慢[/b][/b]接到客户报告最近数据库速度慢了好多,同样的应用慢了4,5倍.我做了个statspack,没发现什么问题,主要信息:CacheSizes(end)~~~~~~~~~~~~~~~~~BufferCache:3,104MStdBlockSize:8KSharedPoolSize:400MLogBuffer:3,072KLoadProfile~~~~~~~~~~~~PerSecondPerTransaction------------------------------Redosize:394,918.9168,578.62Logicalreads:40,718.267,070.82Blockchanges:3,516.66610.68Physicalreads:1,673.37290.59Physicalwrites:63.5811.04Usercalls:122.8321.33Parses:22.043.83Hardparses:2.230.39Sorts:10.361.80Logons:0.380.07cutes:54.359.44Transactions:5.76%BlockschangedperRead:8.64RecursiveCall%:46.61Rollbackpertransaction%:0.00RowsperSort:1601.81InstanceEfficiencyPercentages(Target100%)~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~BufferNowait%:99.99RedoNoWait%:100.00BufferHit%:95.91In-memorySort%:99.99LibraryHit%:98.08SoftParse%:89.90cutetoParse%:59.45LatchHit%:99.88ParseCPUtoParseElapsd%:%Non-ParseCPU:SharedPoolStatisticsBeginEndMemoryUsage%:86.5986.84%SQLwithcutions>1:88.1988.59%MemoryforSQLw/c>1:94.3494.96Top5TimedEvents~~~~~~~~~~~~~~~~~~%TotalEventWaitsTime(s)ElaTime---------------------------------------------------------------------------dbfilescatteredread585,3735,11036.24latchfree38,1463,33123.63dbfilesequentialread328,8812,09614.87PXDeq:TxnRecoveryStart6451,1247.97dbfileparallelwrite3,8407545.35****************************AIX系统:***********************************#iostat55tty:tintoutavg-cpu:%user%sys%idle%iowait0.02.516.42.869.711.1Disks:%tm_actKbpstpsKb_readKb_wrtnhdisk020.9141.933.011768529371037907344hdisk120.4136.631.31136554209996356546hdisk212.6140.356.67021958931487895240hdisk310.6249.139.518870712512001871356cd00.00.00.000tty:tintoutavg-cpu:%user%sys%idle%iowait0.0339.422.16.619.052.4Disks:%tm_actKbpstpsKb_readKb_wrtnhdisk095.6615.2152.02112964hdisk196.0612.0150.82156904hdisk283.02470.4226.411524828hdisk37.060.012.63000cd00.00.00.000tty:tintoutavg-cpu:%user%sys%idle%iowait0.0460.431.37.713.147.9Disks:%tm_actKbpstpsKb_readKb_wrtnhdisk095.4648.0158.418441396hdisk198.4679.2163.418961500hdisk289.62595.2260.212088888hdisk35.844.810.221212cd00.00.00.000tty:tintoutavg-cpu:%user%sys%idle%iowait0.0364.521.97.414.955.9Disks:%tm_actKbpstpsKb_readKb_wrtnhdisk096.6750.9177.911522604hdisk195.2773.3177.711762692hdisk270.22002.5205.19740276hdisk35.0132.88.4152512cd00.00.00.000************FZYC1/#sar55AIXFZYC134000177DF4C0006/06/0610:15:40%usr%sys%wio%idle10:15:45152631910:15:50193562210:15:55225542010:16:002010512010:16:052595115Average2065519******************FZYC1/#ps-ef|pgUIDPIDPPIDCSTIMETTYTIMEroot100Dec07-29:33/etc/initroot415810Dec07-0:00/usr/lib/s/ssa_daemon-lssa0root4446110960Dec07-182:03/usr/dt/bin/dtsessionroot501410Dec07-1577:46/usr/sbin/syncd10root5958103220Dec07-24:57/usr/lpp/X11/bin/X-xabx-xdbe-xGLX-D/usr/lib/X11//rgb-T-force:0-auth/var/dt/A:0-aWkfiaroot1032210Dec07-0:01/usr/dt/bin/dtlogin-daemonroot1061010Dec07-0:00/usr/lib/errdemonroot1092644460Dec07-0:00/usr/dt/bin/dttermroot11096103220Dec07-0:00dtlogin-daemonroot11364176260Dec07pts/00