Hi,all,
I meet a question about materialized view:
In a LAN env,remote DB (hp-ux /Oracle 9201 EE) has a table named
BASE_TB ( 6 million records ), table's size is bout 20M; at local
db(linux / Oracle 9204 EE) ,
I create a MV use the following SQL:
CREATE MATERIALIZED VIEW base_tb_local
BUILD IMMEDIATE
REFRESH fast START WITH SYSDATE NEXT trunc(SYSDATE) + 1
WITH ROWID
AS SELECT * FROM base_tb_at_dblinkname
;
slow-going, took me about one hour . then I ftp a big file to remote
,and download a big file from remote db's site , the speed is OK, very
fast. .
I tried to refresh the MV ,slowly......then at remote db ,I do some
trace about the session.Such as :
execute dbms_system.set_ev(<sid>,<serial>,10046,12,'');
and found that :
- SESSION ID:(26.6530) 2004-08-04 22:49:36.393
WAIT #1: nam='SQL*Net more data to client' ela= 22 p1=1413697536 p2=1989 p3=0
WAIT #1: nam='SQL*Net more data to client' ela= 33 p1=1413697536 p2=2019 p3=0
.....
WAIT #1: nam='SQL*Net more data to client' ela= 20 p1=1413697536 p2=2007 p3=0
WAIT #1: nam='SQL*Net more data to client' ela= 17 p1=1413697536 p2=1997 p3=0
WAIT #1: nam='SQL*Net more data to client' ela= 18 p1=1413697536 p2=1999 p3=0
WAIT #1: nam='SQL*Net more data to client' ela= 20 p1=1413697536 p2=2007 p3=0
WAIT #1: nam='SQL*Net more data to client' ela= 7746560 p1=1413697536
p2=1995 p3=0
WAIT #1: nam='SQL*Net more data to client' ela= 41 p1=1413697536 p2=2014 p3=0
.............
WAIT #1: nam='SQL*Net more data to client' ela= 16 p1=1413697536 p2=2000 p3=0
- 2004-08-04 22:49:54.372
WAIT #1: nam='SQL*Net more data to client' ela= 9780202 p1=1413697536
p2=2005 p3=0
WAIT #1: nam='SQL*Net more data to client' ela= 41 p1=1413697536 p2=1999 p3=0
WAIT #1: nam='SQL*Net more data to client' ela= 17 p1=1413697536 p2=2003 p3=0
WAIT #1: nam='SQL*Net more data to client' ela= 16 p1=1413697536 p2=2001 p3=0
WAIT #1: nam='SQL*Net more data to client' ela= 17 p1=1413697536 p2=1997 p3=0
WAIT #1: nam='SQL*Net more data to client' ela= 16 p1=1413697536 p2=2001 p3=0
WAIT #1: nam='SQL*Net more data to client' ela= 16 p1=1413697536 p2=2002 p3=0
WAIT #1: nam='SQL*Net more data to client' ela= 16 p1=1413697536 p2=2000 p3=0
WAIT #1: nam='SQL*Net more data to client' ela= 16 p1=1413697536 p2=2006 p3=0
WAIT #1: nam='SQL*Net more data to client' ela= 17 p1=1413697536 p2=2005 p3=0
......
WAIT #1: nam='SQL*Net more data to client' ela= 7758084 p1=1413697536
p2=2013 p3=0
WAIT #1: nam='SQL*Net more data to client' ela= 34 p1=1413697536 p2=1993 p3=0
WAIT #1: nam='SQL*Net more data to client' ela= 16 p1=1413697536 p2=1999 p3=0
WAIT #1: nam='SQL*Net more data to client' ela= 17 p1=1413697536 p2=2002 p3=0
WAIT #1: nam='SQL*Net more data to client' ela= 17 p1=1413697536 p2=1992 p3=0
WAIT #1: nam='SQL*Net more data to client' ela= 17 p1=1413697536 p2=2009 p3=0
WAIT #1: nam='SQL*Net more data to client' ela= 16 p1=1413697536 p2=2007 p3=0
WAIT #1: nam='SQL*Net more data to client' ela= 7757175 p1=1413697536
p2=1997 p3=0
I know "ela" is about time , in the trace file,"ela= 7757175 " ,means
77571750ms ? my GOD!
Would you like give me some advise about this ?
Thanks anyway!!
--
David Fenng
http://www.dbanotes.net
some articles about Oracle RDBMS 8i/9i/10g (in Chinese)
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu Aug 05 2004 - 21:46:05 CDT