semoga isi artikel ini sedikit membantu ya..
bila dirasa mengganggu performance, maka perlu di lakukan tuning sql
termasuk indexing..
------------------------------------------------------------------
The DB file sequential read' event indicates a single block read is
occurring.
The appearance of this event may not necessarily indicate a problem, as I/O
is a normal activity on a healthy instance.
Block reads are fairly inevitable so the aim should be to minimize
unnecessary I/O.
This is best achieved by good application design and efficient execution
plans. Changes to execution plans can yield orders of magnitude changes in
performance. Tweaking at system level usually only achieves percentage
gains. A larger buffer cache may help - test this by actually increasing
DB_BLOCK_BUFFERS and not by using DB_BLOCK_LRU_EXTENDED_STATISTICS.
Never increase the SGA size if it may induce additional paging or swapping
on the system.
--------------------------------
salaam,
On 5/22/06, nadas <[EMAIL PROTECTED]> wrote:
>
> Hi oracle mania
>
> saya mo tanya
> kalo db file sequential read itu
> terjadi karena apa yach ??
>
> teruas efeknya ke aplikasi apa
> dan cara ngindarinnya gimana??
>
> salam
> NDS
>
> ========================================================================================
> Ikuti Lomba Puisi Online Jawa Timur, dapatkan hadiah menarik setiap
> bulannya
> dan hadiah total senilai 60 juta rupiah
> hanya di http://www.plasa.com
> ========================================================================================
>
>
>
> --
> -----------I.N.D.O - O.R.A.C.L.E---------------
> Keluar: [EMAIL PROTECTED]
> Website: http://indo-oracle.lizt.org (NEW)
> -----------------------------------------------
>
> Bergabung dengan Indonesia Thin Client User Groups,
> Terminal Server, Citrix, New Moon Caneveral, di:
> http://indo-thin.vze.com
>
>
>
> SPONSORED LINKS
> Membership database software<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Oracle+database+administration&w6=Oracle+database+management&c=6&s=195&.sig=eDDh4hKVCztlkTEeYzirSg> Database
> mortgage software<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Oracle+database+administration&w6=Oracle+database+management&c=6&s=195&.sig=hXxg74XuhXSzegVx-t1xkA> Pda
> database software<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Oracle+database+administration&w6=Oracle+database+management&c=6&s=195&.sig=roR_Z1cY1-GOzqzt3GgyUw> Database
> management software<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Oracle+database+administration&w6=Oracle+database+management&c=6&s=195&.sig=qVd58SCSnEG4iKPrZDnKTA> Oracle
> database administration<http://groups.yahoo.com/gads?t=ms&k=Oracle+database+administration&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Oracle+database+administration&w6=Oracle+database+management&c=6&s=195&.sig=HnkpKGBwHtP2yh9OvVaS3Q> Oracle
> database management<http://groups.yahoo.com/gads?t=ms&k=Oracle+database+management&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Oracle+database+administration&w6=Oracle+database+management&c=6&s=195&.sig=8YpXzkCJ2hlCDM-NY94dXQ>
> ------------------------------
> YAHOO! GROUPS LINKS
>
>
> - Visit your group "indo-oracle<http://groups.yahoo.com/group/indo-oracle>"
> on the web.
>
> - To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]<[EMAIL PROTECTED]>
>
> - Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
> ------------------------------
>
--
[Non-text portions of this message have been removed]
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
SPONSORED LINKS
| Membership database software | Database mortgage software | Pda database software |
| Database management software | Oracle database administration | Oracle database management |
YAHOO! GROUPS LINKS
- Visit your group "indo-oracle" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
