High-Speed Paging resolution of rowid in oracle

In oracle, rowid High-Speed Paging resolution-rowid paging, step 1 select rowid rid, sal from emp order by sal desc; -- rowid paging, step 2 select rownum rn, rid from (select rowid rid, sal from emp order by sal desc) where rownum <10; www.2cto.com -- rowid paging, step 3 select rid from (select rownum rn, rid from (select rowid rid, sal from emp order by sal desc) where rownum <10) where rn> 5; -- rowid paging, step 4 select * from emp where rowid in (select rid from (select rownum rn, rid from (select rowid rid, sal from emp order by sal desc) where rownum <10) where rn> 5 ); **************************************** * the first layer: obtain data physical address Layer 2: obtain the maximum number of pages Layer 3: obtain the minimum number of pages Layer 4: Because the obtained Number of pages is a physical address, then according to the physical address, insert a specific data