Coba bikin public synonym utk schema1.A , dan di schema2 coba select berdasarkan public synonym tersebut, dan bandingkan apakah kecepatan transfer sama antara login dengan memakai schema 1 dan schema 2.
----- Original Message ----- From: "Yoel" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, October 10, 2006 14:10 Subject: Re: [indo-oracle] proses insert lambat jika antar schema yang berbeda > menarik nih.. > gimana code stored procedurenya?bisa dishare? > > On 10/10/06, artanto rizky cahyono <[EMAIL PROTECTED]> wrote: > > > > rekan-rekan, > > saya ada permasalahan sebagai berikut. saya memiliki 2 schema database, > > taruhlah schema 1 dan schema 2. di schema 1 terdapat table A dan di schema 2 > > terdapat tabel B. > > saya membuat stored procedure X di schema 2. di dalam stored procedure ini > > melakukan query select column1 from schema1.A, kemudian hasil query ini di > > insert kan ke column2 yang ada di table B (schema 2). permasalahnnya proses > > insert ini membutuhkan waktu yg lama, untuk 1 record saja membutuhkan waktu > > 1 detik. > > tetapi jika tabel B saya pindah ke schema 1 (schema yang sama dengan table > > A). maka proses inserting untuk 1 record hanya membutuhkan waktu 0.09detik. > > Cache Hit Ratio pada database saya adala 91%. > > atas bantuan rekan-rekan, saya mengucapkan terima kasih. > > > > artanto rizky cahyono > > > > > > --------------------------------- > > Stay in the know. Pulse on the new Yahoo.com. Check it out. > > > > [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://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 > > > > > > > -- -----------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/ <*> 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: mailto:[EMAIL PROTECTED] mailto:[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/
