Bagaimana pengaturan volume group di external storagenya ? ada berapa disk controller dan berapa disk?
On 8/24/06, praneko <[EMAIL PROTECTED]> wrote: > > Dear DBA-er, > > Saya ada 2 machine Power5-550 untuk 2 database Oracle9i (9.2.0.1) > dengan 1 external storage (IBM Storage DS4300). > Nah, 2 database tersebut database file nya (data files, undo, log, > control file, etc) semua sama-sama di stored di external hdisk tsb > (hdisk2 - cuma beda volume group). > Satu hal lagi, data dan index dalam satu tablespace (tablespace USERS). > Applikasi yg running adlah jenis OLAP- untuk reporting. > > Permasalahannya : > 1. wait IO di hdisk2 always/selalu 90 - 100% waiting. > 2. applikasi report-nya luambat banget 1 klik butuh > 80seconds. > 3. Sudah di lakukan analyze (reorganising) all tables tapi tetap saja > lambat. > > Minta tolong dunk pencerahannya.:) > > Terima kasih banyak sebelumnya, > Amang N > > > [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.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> 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/
