Note : Jangan berasumsi Full Table Scan gak bagus

2010/8/16 Sandi Jatmika <[email protected]>

>
>
> di oracle 9i, coba menggunakan statspack.
>
> ________________________________
>
> From: Teguh Susanto <[email protected] <teguh4milis%40yahoo.com>>
> To: [email protected] <indo-oracle%40yahoogroups.com>
> Sent: Mon, August 16, 2010 10:33:14 AM
>
> Subject: [indo-oracle] OOT:tahapan apa saja untuk optimization tuning pada
> oracle 9i
>
> kepada miliser dan senior DBA
>
> kebetulan saya buat query dengan model pivot tapi pas dieksekusi lemot
> banget,
> tahapan apa saja untuk mengoptimasi query,tool apa saja yg bisa digunakan
> klo
> query yg saya buat bagus optimasinya, o ya saya menggunakan oracle jadul
> yaitu
> 9i
>
> terima kasih atas atensinya...
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>  
>


[Non-text portions of this message have been removed]



------------------------------------

--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [email protected]
Website: http://indooracle.wordpress.com
http://www.facebook.com/group.php?gid=51973053515
-----------------------------------------------

Bergabung dengan Indonesia Thin Client User Groups, 
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.blogspot.comYahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/indo-oracle/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/indo-oracle/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/

Kirim email ke