Klo mau view di index pake mview aj tapi mview itu biasanya tabel summary, oracle bkn bandwith setau wa si tp resource cpu yg blh dipake tiap user biasanya si org sering blg dgn nama resource profile Sent from my BlackBerry® smartphone from Sinyal Bagus XL, Nyambung Teruuusss...!
-----Original Message----- From: Suhartoyo <[email protected]> Sender: [email protected] Date: Mon, 16 Aug 2010 04:09:15 To: <[email protected]> Reply-To: [email protected] Subject: Re: [indo-oracle] Tanya Maaf... sekedar meluruskan... bukan view nya yg di index, tetapi tabel yg di pakai di dalam view tersebut... Yg di index adalah kolom pada "where clause nya" di index, agar dapat membantu mempercepat proses execute nya, terutama bila jumlah data nya banyak.... Kalau masalah, Apakah mungkin DBA bisa mengatur speed/bandwith dari hak akses user thd skema database di sebuah server? Saya sendiri kurang paham... Yang saya tau, User di Oracle bisa di set profile nya... di Profile tsb, ada parameter yg dapat di set... Tetapi apakah parameter di Profile User tsb berhubungan dengan speed/bandwith dari user tsb, Saya kurang mengetahui nya... Mungkin rekan rekan para Master Oracle dapat membantu? -Toyo- --- On Sat, 8/14/10, [email protected] <[email protected]> wrote: From: [email protected] <[email protected]> Subject: Re: [indo-oracle] Tanya To: [email protected] Date: Saturday, August 14, 2010, 2:42 PM Setahu sy view ga pakai index pak, bukan bgitu? Apakah mngkin DBA bisa mengatur speed/bandwith dari hak akses user thd skema database di sebuah server? Sent from my BlackBaron® powered by Sinyal Kuat INDOSESAT -----Original Message----- From: Rubinhut Sihar <[email protected]> Sender: [email protected] Date: Sat, 14 Aug 2010 12:33:07 To: <[email protected]> Reply-To: [email protected] Subject: Re: [indo-oracle] Tanya Dear All, Mungkin untuk tabel yang pertama where clause nya di index, sedangkan tabel yang kedua where clause nya tidak di index. Best Regards, Rubinhut Sihar 2010/8/14 Suhartoyo <[email protected]> > > > kalo menggunakan schema lain, pada from nya ditambahkan schema.table nya > contohnya: select from schema.table where > > Regards, > > Toyo > > --- On Thu, 8/12/10, [email protected]<altaufan_riza%40yahoo.co.id>< > [email protected] <altaufan_riza%40yahoo.co.id>> wrote: > > From: [email protected] <altaufan_riza%40yahoo.co.id> < > [email protected] <altaufan_riza%40yahoo.co.id>> > Subject: [indo-oracle] Tanya > To: [email protected] <indo-oracle%40yahoogroups.com> > Date: Thursday, August 12, 2010, 1:39 AM > > > permisi pak/bu, nubie ingin numpang nanya: > > Saya mempunyai mslah sbb: > > view yg saya execute (cm select where doank) di 1 skema berjalan lancar, > namun di skema lain (structure view sm persis) berjalan tdk lancar, butuh > wkt hingga 1 jam. Padahal query nya sama persis, SELECT WHERE. Knp ya pak/bu > ? > > Mohon pencerahannya pak/bu :) > > Sent from my BlackBaron® > powered by Sinyal Kuat INDOSESAT > > ------------------------------------ > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: > [email protected]<indo-oracle-unsubscribe%40yahoogroups.com> > 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 > > [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 ------------------------------------ -- -----------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 [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/
