Memang terkadang rancu antara penggunaan istilah optimization dan tuning dalam menangani database. Yg mana kedua2nya bertujuan sama,...agar databasenya enak dan kenceng dipakai oleh user.
Bagi saya pribadi, contoh penggunaan optimization misalnya: 1. rebuilding index 2. table reorganization --> Tujuannya mengoptimalkan penggunaan space di database. contoh penggunaan tuning misalnya: 1. pengaturan penggunaan memory : SGA & PGA --> Tujuannya: supaya pas/sesuai dengan kondisi yg ada (misal: memory size yg ada) 2. perubahan SQL statement yg lambat/bermasalah, misalnya dengan menambahkan hint /*+ INDEX (tbl Y) */ --> Tujuannya: supaya pas/sesuai dgn expektasi menggunakan index X misalnya. diambil dari Merriam Webster a. optimization::: : an act, process, or methodology of making something (as a design, system, or decision) as fully perfect, functional, or effective as possible ; specifically : the mathematical procedures (as finding the maximum of a function) involved in this b.tuning::: transitive verb 1: to adjust in musical pitch or cause to be in tune <tuned her guitar> 2 a: to bring into harmony : attune b: to adjust for precise functioning often used with up<tune up an engine> c: to make more precise, intense, or effective 3: to adjust with respect to resonance at a particular frequency: as a: to adjust (a radio or television receiver) to respond to waves of a particular frequency often used with in b: to establish radio contact with <tune in a directional beacon> 4: to adjust the frequency of the output of (a device) to a chosen frequency or range of frequencies ; also : to alter the frequency of (radiation) intransitive verb 1: to become attuned 2: to adjust a radio or television receiver to respond to waves of a particular frequency bw --- In [email protected], "Michael" <archangeloftheblueleg...@...> wrote: > > Halo boss dan biss, > > Numpang tanya nihh... > Apa sih bedanya tuning dengan optimasi kalo di oracle? Dan bisa tolong kasi > contoh tuning itu ngapain aja dan optimasi ngapain aja..? > Mohon pencerahannya... > Maap yah kalo seblumnya ini dah pernah dibahas.. > > Salam, > Michael >
