DB Performans terimleri

Posted by sezai can kiren on Jan 16, 2021; 9:33am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/DB-Performans-terimleri-tp9249.html

Selamlar Erman bey,

https://ermanarslan.blogspot.com/search?q=awr+report postunuzdaki açıklamalara istinaden bir kaç sorum olacaktı.

1. Bu eventlerde nasıl bir iyileştirme yapabiliriz.
2. Read I/O for sorts / Read I/O for sorts kısmındaki  I/O for sorts un anlamı nedir. ?

db file sequential read – Random I/O , single row , mostly index IO
db file scattered Read – Sequential I/O , Full table scan, index fast full scan
direct path read – Sequential I/O , Full table scan , directly to the PGA
direct path read temp – Read I/O for sorts
direct path write temp – Write I/O for sorts
read by other session – sessions waiting  while another session is reading the same from the disk.

Selamlar,
Sezai.