select avg_row_len from dba_tables where table_name='EMPLOYEES'-> tapi ini avg bukan per row klo valuenya = 0 -> tabelnya harus di compute statistic..
fetch : 1. oradebug setmypid; 2. oradebug event 10046 trace name context forever, level 12;-> enable trace 10046 3. oradebug tracefile_name; -> lokasi dari trace filenya 4. --tulis query yang pengen dicheck di bagian ini-- 5. oradebug event 10046 trace name context off; -> disable trace 10046 trace file output: FETCH #5:c=62500,e=59525,p=0,cr=804,cu=0,mis=0,r=1,dep=0,og=1,tim=926305036 WAIT #5: nam='SQL*Net message from client' ela= 721 driver id=1111838976 #bytes=1 p3=0 obj#=-1 tim=926305939 WAIT #5: nam='SQL*Net message to client' ela= 3 driver id=1111838976 #bytes=1 p3=0 obj#=-1 tim=926306352 FETCH #5:c=0,e=1096,p=0,cr=30,cu=0,mis=0,r=3,dep=0,og=1,tim=926307113 WAIT #5: nam='SQL*Net message from client' ela= 308342 driver id=1111838976 #bytes=1 p3=0 obj#=-1 tim=926615770 STAT #5 id=1 cnt=4 pid=0 pos=1 obj=0 op='HASH JOIN RIGHT OUTER (cr=834 pr=0 pw=0 time=59442 us)' 3. yang mempengaruhi fetching data -> jumlah datanya CMIIW Best Regards, Taufiq ________________________________ From: ragil martha <[email protected]> To: [email protected] Cc: [email protected] Sent: Wednesday, May 6, 2009 10:36:50 AM Subject: [indo-oracle] tanya faktor2 yg mempengaruhi fetching data Dear all,, saya mau tanya nich.. 1. Kalo mau liat ukuran data per row di tabel gmn caranya? 2. Klo mau liat tiap fetching, memory ambil berapa row di tabel kita gmn caranya?? 3. apa saja yang mempengaruhi fecthing data?? Makasi bnyk...mohon bantuannya.. . :D Menambah banyak teman sangatlah mudah dan cepat. Undang teman dari Hotmail, Gmail ke Yahoo! Messenger sekarang! http://id.messenger.yahoo.com/invite/ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
