Re: SAMPLE BLOCK

From: Daniel W. Fink <Daniel.Fink_at_Sun.COM>
Date: Sat, 27 Dec 2003 11:24:26 -0800
Message-ID: <F001.005DB213.20031227112426@fatcity.com>

There are two things that I can theorize could cause this problem. 1) Oracle bug (have you logged a tar with OWS?) 2) The block sampled is below the high water mark, but does not contain any data. I don't know the exact sampling algorithm, but this seems to be the 2nd simplest explanation (bug being #1).

Daniel Fink

jaysingh1_at_optonline.net wrote:

> Hi Gurus,
>
> I don't understand the SAMPLE BLOCK behavior. Why is it giving different results for the query?
>
> sys_at_DEVDB SQL> select * from SALGRADE sample block (1);
>
> GRADE LOSAL HISAL
> ---------- ---------- ----------
> 2 1201 1400
>
> sys_at_DEVDB SQL> l
> 1* select * from SALGRADE sample block (1)
> sys_at_DEVDB SQL> /
>
> no rows selected
>
> sys_at_DEVDB SQL>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: jaysingh1_at_optonline.net
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel W. Fink
  INET: Daniel.Fink_at_Sun.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Sat Dec 27 2003 - 13:24:26 CST