RE: Optimizer uses either index or full scan in a partitioned table

RE: Optimizer uses either index or full scan in a partitioned table

 

  

Hi all,

Can any one tell me what actions should be taken when there is more
iowait and less idle % on a solaris servers where around 13 oracle
databases are running.

Below is the snapshot of the top command.

last pid: 11328; load averages: 3.33, 3.59, 3.75
13:53:41
932 processes: 864 sleeping, 64 zombie, 4 on cpu
CPU states: 5.2% idle, 24.7% user, 24.0% kernel, 46.1% iowait, 0.0%
swap
Memory: 2048M real, 30M free, 2452M swap in use, 2627M swap free

PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
5113 root 1 60 10 1912K 1488K sleep 0:12 3.84% filmon
13414 batch 1 32 0 83M 60M sleep 1:50 2.10% oracle
26102 batch 1 31 0 81M 58M cpu0 1:39 2.05% oracle
9634 batch 1 51 0 317M 296M sleep 0:03 1.63% oracle
28943 batch 1 60 0 81M 61M sleep 8:11 1.21% oracle
9805 batch 1 60 0 69M 52M sleep 1:27 0.92% oracle
3359 batch 11 54 0 318M 297M sleep 11:31 0.86% oracle
417 batch 1 60 0 69M 51M cpu9 19:17 0.78% oracle
23230 oracle 235 58 0 73M 47M sleep 10:45 0.76% oracle
16292 batch 1 60 0 88M 68M sleep 0:15 0.63% oracle
12432 batch 1 44 0 16M 6056K sleep 0:36 0.60% emco560m
1 root 1 58 0 752K 200K sleep 9:23 0.42% init
16910 oracle 14 58 0 317M 290M sleep 0:33 0.41% oracle
24425 root 1 34 0 2584K 1528K sleep 0:16 0.35% top
16830 oracle 160 58 0 84M 55M sleep 3:02 0.33% oracle



Surya Prakash Gunupudi
Oracle DBA
ISP Technical Services
Satyam City Center
4th Floor - Ext:2291
Ph: +919885452811


DISCLAIMER:
This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.


Oracle LazyDBA home page