strange wait?

From: hopehope_123 <hopehope_123_at_yahoo.com>
Date: 7 Jul 2005 23:18:36 -0700
Message-ID: <1120803515.959388.189880@o13g2000cwo.googlegroups.com>

Hi ,

The below session ( sid=62) is waiting on db_file_sequental_read event for more than 627 seconds. When i strace the process id , i see it is polling. Why is this session waiting for disk index read although there is no real io in the process? What does this mean?

INST_ID	SID	SEQ#	EVENT	P1TEXT	P1	P1RAW	P2TEXT	P2	P2RAW	P3TEXT	P3	P3RAW	WAIT_TIME	SECONDS_IN_WAIT	STATE
1	62	37	db file sequential
read	file#	348	000000000000015C	block#	48779	000000000000BE8B	blocks	1	0000000000000001	2	627	WAITED

KNOWN TIME This is oracle warehouse builder session . The seq , p1, p2 values are all same , it seems the session cont. is requesting the same blcok number .

Kind Regards,
tolga Received on Fri Jul 08 2005 - 01:18:36 CDT