text: SQL> @eg1
  
  OWNER      OBJECT_NAME          SUBOBJECT_NAME        OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE             CREATED   LAST_DDL_ TIMESTAMP           STATUS  T G S  NAMESPACE EDITION_NA SHARING            E O A DEFAULT_COLLATION                                                                                    D S CREATED_APPID CREATED_VSNID
  ---------- -------------------- -------------------- ---------- -------------- ----------------------- --------- --------- ------------------- ------- - - - ---------- ---------- ------------------ - - - ---------------------------------------------------------------------------------------------------- - - ------------- -------------
  MODIFIED_APPID MODIFIED_VSNID
  -------------- --------------
  AUDSYS     SYS_IL0000017945C000 SYS_IL_P387               73694          73694 INDEX PARTITION         17-SEP-18 17-SEP-18 2018-09-17:12:34:46 VALID   N Y N          4            NONE                 N N                                                                                                      N N
             97$$
  
  
  AUDSYS     SYS_IL0000017945C000 SYS_IL_P387               73694          73694 INDEX PARTITION         17-SEP-18 17-SEP-18 2018-09-17:12:34:46 VALID   N Y N          4            NONE                 N N                                                                                                      N N
             97$$
  
  
  AUDSYS     SYS_IL0000017945C000 SYS_IL_P387               73694          73694 INDEX PARTITION         17-SEP-18 17-SEP-18 2018-09-17:12:34:46 VALID   N Y N          4            NONE                 N N                                                                                                      N N
             97$$
  
  
  AUDSYS     SYS_IL0000017945C000 SYS_IL_P387               73694          73694 INDEX PARTITION         17-SEP-18 17-SEP-18 2018-09-17:12:34:46 VALID   N Y N          4            NONE                 N N                                                                                                      N N
             97$$
  
  
  AUDSYS     SYS_IL0000017945C000 SYS_IL_P387               73694          73694 INDEX PARTITION         17-SEP-18 17-SEP-18 2018-09-17:12:34:46 VALID   N Y N          4            NONE                 N N                                                                                                      N N
             97$$
  
  
  AUDSYS     SYS_IL0000017945C000 SYS_IL_P387               73694          73694 INDEX PARTITION         17-SEP-18 17-SEP-18 2018-09-17:12:34:46 VALID   N Y N          4            NONE                 N N                                                                                                      N N
             97$$
  
  
  AUDSYS     SYS_IL0000017945C000 SYS_IL_P387               73694          73694 INDEX PARTITION         17-SEP-18 17-SEP-18 2018-09-17:12:34:46 VALID   N Y N          4            NONE                 N N                                                                                                      N N
             97$$
  
  
  AUDSYS     SYS_IL0000017945C000 SYS_IL_P387               73694          73694 INDEX PARTITION         17-SEP-18 17-SEP-18 2018-09-17:12:34:46 VALID   N Y N          4            NONE                 N N                                                                                                      N N
             97$$
  
  
  AUDSYS     SYS_IL0000017945C000 SYS_IL_P387               73694          73694 INDEX PARTITION         17-SEP-18 17-SEP-18 2018-09-17:12:34:46 VALID   N Y N          4            NONE                 N N                                                                                                      N N
             97$$
  
  
  AUDSYS     SYS_IL0000017945C000 SYS_IL_P387               73694          73694 INDEX PARTITION         17-SEP-18 17-SEP-18 2018-09-17:12:34:46 VALID   N Y N          4            NONE                 N N                                                                                                      N N
             97$$
  
  
  
  10 rows selected.
  
  Elapsed: 00:00:00.31
  
  PLAN_TABLE_OUTPUT
  ----------------------------------------------------------------------------------------------------
  SQL_ID  0qtbtttf5rs5y, child number 0
  -------------------------------------
  select * from ( select *   from   t   order by object_id desc   ) where
  rownum <= 10
  
  Plan hash value: 1635572796
  
  --------------------------------------------------------------------------------------
  | Id  | Operation                     | Name | Rows  | Bytes | Cost (%CPU)| Time     |
  --------------------------------------------------------------------------------------
  |   0 | SELECT STATEMENT              |      |       |       |    13 (100)|          |
  |   1 |  COUNT STOPKEY                |      |       |       |            |          |
  |   2 |   VIEW                        |      |    10 |  4810 |    13   (0)| 00:00:01 |
  |   3 |    TABLE ACCESS BY INDEX ROWID| T    |   727K|    92M|    13   (0)| 00:00:01 |
  |   4 |     INDEX FULL SCAN DESCENDING| IX   |    10 |       |     3   (0)| 00:00:01 |
  --------------------------------------------------------------------------------------
  
  
  17 rows selected.
  
  Elapsed: 00:00:00.10
  
  OWNER      OBJECT_NAME          SUBOBJECT_NAME        OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE             CREATED   LAST_DDL_ TIMESTAMP           STATUS  T G S  NAMESPACE EDITION_NA SHARING            E O A DEFAULT_COLLATION                                                                                    D S CREATED_APPID CREATED_VSNID
  ---------- -------------------- -------------------- ---------- -------------- ----------------------- --------- --------- ------------------- ------- - - - ---------- ---------- ------------------ - - - ---------------------------------------------------------------------------------------------------- - - ------------- -------------
  MODIFIED_APPID MODIFIED_VSNID
  -------------- --------------
  AUDSYS     SYS_IL0000017945C000 SYS_IL_P387               73694          73694 INDEX PARTITION         17-SEP-18 17-SEP-18 2018-09-17:12:34:46 VALID   N Y N          4            NONE                 N N                                                                                                      N N
             97$$
  
  
  AUDSYS     SYS_IL0000017945C000 SYS_IL_P387               73694          73694 INDEX PARTITION         17-SEP-18 17-SEP-18 2018-09-17:12:34:46 VALID   N Y N          4            NONE                 N N                                                                                                      N N
             97$$
  
  
  AUDSYS     SYS_IL0000017945C000 SYS_IL_P387               73694          73694 INDEX PARTITION         17-SEP-18 17-SEP-18 2018-09-17:12:34:46 VALID   N Y N          4            NONE                 N N                                                                                                      N N
             97$$
  
  
  AUDSYS     SYS_IL0000017945C000 SYS_IL_P387               73694          73694 INDEX PARTITION         17-SEP-18 17-SEP-18 2018-09-17:12:34:46 VALID   N Y N          4            NONE                 N N                                                                                                      N N
             97$$
  
  
  AUDSYS     SYS_IL0000017945C000 SYS_IL_P387               73694          73694 INDEX PARTITION         17-SEP-18 17-SEP-18 2018-09-17:12:34:46 VALID   N Y N          4            NONE                 N N                                                                                                      N N
             97$$
  
  
  AUDSYS     SYS_IL0000017945C000 SYS_IL_P387               73694          73694 INDEX PARTITION         17-SEP-18 17-SEP-18 2018-09-17:12:34:46 VALID   N Y N          4            NONE                 N N                                                                                                      N N
             97$$
  
  
  AUDSYS     SYS_IL0000017945C000 SYS_IL_P387               73694          73694 INDEX PARTITION         17-SEP-18 17-SEP-18 2018-09-17:12:34:46 VALID   N Y N          4            NONE                 N N                                                                                                      N N
             97$$
  
  
  AUDSYS     SYS_IL0000017945C000 SYS_IL_P387               73694          73694 INDEX PARTITION         17-SEP-18 17-SEP-18 2018-09-17:12:34:46 VALID   N Y N          4            NONE                 N N                                                                                                      N N
             97$$
  
  
  AUDSYS     SYS_IL0000017945C000 SYS_IL_P387               73694          73694 INDEX PARTITION         17-SEP-18 17-SEP-18 2018-09-17:12:34:46 VALID   N Y N          4            NONE                 N N                                                                                                      N N
             97$$
  
  
  AUDSYS     SYS_IL0000017945C000 SYS_IL_P387               73694          73694 INDEX PARTITION         17-SEP-18 17-SEP-18 2018-09-17:12:34:46 VALID   N Y N          4            NONE                 N N                                                                                                      N N
             97$$
  
  
  
  10 rows selected.
  
  Elapsed: 00:00:00.00
  
  PLAN_TABLE_OUTPUT
  ----------------------------------------------------------------------------------------------------
  SQL_ID  0qtbtttf5rs5y, child number 0
  -------------------------------------
  select * from ( select *   from   t   order by object_id desc   ) where
  rownum <= 10
  
  Plan hash value: 1635572796
  
  --------------------------------------------------------------------------------------
  | Id  | Operation                     | Name | Rows  | Bytes | Cost (%CPU)| Time     |
  --------------------------------------------------------------------------------------
  |   0 | SELECT STATEMENT              |      |       |       |    13 (100)|          |
  |   1 |  COUNT STOPKEY                |      |       |       |            |          |
  |   2 |   VIEW                        |      |    10 |  4810 |    13   (0)| 00:00:01 |
  |   3 |    TABLE ACCESS BY INDEX ROWID| T    |   727K|    92M|    13   (0)| 00:00:01 |
  |   4 |     INDEX FULL SCAN DESCENDING| IX   |    10 |       |     3   (0)| 00:00:01 |
  --------------------------------------------------------------------------------------
  
  
  17 rows selected.
  
  Elapsed: 00:00:00.01
  
  OWNER      OBJECT_NAME          SUBOBJECT_NAME        OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE             CREATED   LAST_DDL_ TIMESTAMP           STATUS  T G S  NAMESPACE EDITION_NA SHARING            E O A DEFAULT_COLLATION                                                                                    D S CREATED_APPID CREATED_VSNID
  ---------- -------------------- -------------------- ---------- -------------- ----------------------- --------- --------- ------------------- ------- - - - ---------- ---------- ------------------ - - - ---------------------------------------------------------------------------------------------------- - - ------------- -------------
  MODIFIED_APPID MODIFIED_VSNID
  -------------- --------------
  SYS        C_OBJ#                                             2              2 CLUSTER                 26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          5            METADATA LINK        Y N                                                                                                      N N
  
  
  SYS        C_OBJ#                                             2              2 CLUSTER                 26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          5            METADATA LINK        Y N                                                                                                      N N
  
  
  SYS        C_OBJ#                                             2              2 CLUSTER                 26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          5            METADATA LINK        Y N                                                                                                      N N
  
  
  SYS        C_OBJ#                                             2              2 CLUSTER                 26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          5            METADATA LINK        Y N                                                                                                      N N
  
  
  SYS        C_OBJ#                                             2              2 CLUSTER                 26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          5            METADATA LINK        Y N                                                                                                      N N
  
  
  SYS        C_OBJ#                                             2              2 CLUSTER                 26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          5            METADATA LINK        Y N                                                                                                      N N
  
  
  SYS        C_OBJ#                                             2              2 CLUSTER                 26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          5            METADATA LINK        Y N                                                                                                      N N
  
  
  SYS        C_OBJ#                                             2              2 CLUSTER                 26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          5            METADATA LINK        Y N                                                                                                      N N
  
  
  SYS        C_OBJ#                                             2              2 CLUSTER                 26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          5            METADATA LINK        Y N                                                                                                      N N
  
  
  SYS        C_OBJ#                                             2              2 CLUSTER                 26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          5            METADATA LINK        Y N                                                                                                      N N
  
  
  
  10 rows selected.
  
  Elapsed: 00:00:00.29
  
  PLAN_TABLE_OUTPUT
  ----------------------------------------------------------------------------------------------------
  SQL_ID  8jd6tct901zsq, child number 0
  -------------------------------------
  select * from   t order by object_id asc fetch first 10 rows only
  
  Plan hash value: 3047187157
  
  -----------------------------------------------------------------------------------------
  | Id  | Operation                | Name | Rows  | Bytes |TempSpc| Cost (%CPU)| Time     |
  -----------------------------------------------------------------------------------------
  |   0 | SELECT STATEMENT         |      |       |       |       | 25486 (100)|          |
  |   1 |  VIEW                    |      |    10 |  5070 |       | 25486   (1)| 00:00:01 |
  |   2 |   WINDOW SORT PUSHED RANK|      |   727K|    92M|   135M| 25486   (1)| 00:00:01 |
  |   3 |    TABLE ACCESS FULL     | T    |   727K|    92M|       |  3901   (1)| 00:00:01 |
  -----------------------------------------------------------------------------------------
  
  
  15 rows selected.
  
  Elapsed: 00:00:00.01
  
  OWNER      OBJECT_NAME          SUBOBJECT_NAME        OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE             CREATED   LAST_DDL_ TIMESTAMP           STATUS  T G S  NAMESPACE EDITION_NA SHARING            E O A DEFAULT_COLLATION                                                                                    D S CREATED_APPID CREATED_VSNID
  ---------- -------------------- -------------------- ---------- -------------- ----------------------- --------- --------- ------------------- ------- - - - ---------- ---------- ------------------ - - - ---------------------------------------------------------------------------------------------------- - - ------------- -------------
  MODIFIED_APPID MODIFIED_VSNID
  -------------- --------------
  SYS        C_OBJ#                                             2              2 CLUSTER                 26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          5            METADATA LINK        Y N                                                                                                      N N
  
  
  SYS        C_OBJ#                                             2              2 CLUSTER                 26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          5            METADATA LINK        Y N                                                                                                      N N
  
  
  SYS        C_OBJ#                                             2              2 CLUSTER                 26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          5            METADATA LINK        Y N                                                                                                      N N
  
  
  SYS        C_OBJ#                                             2              2 CLUSTER                 26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          5            METADATA LINK        Y N                                                                                                      N N
  
  
  SYS        C_OBJ#                                             2              2 CLUSTER                 26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          5            METADATA LINK        Y N                                                                                                      N N
  
  
  SYS        C_OBJ#                                             2              2 CLUSTER                 26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          5            METADATA LINK        Y N                                                                                                      N N
  
  
  SYS        C_OBJ#                                             2              2 CLUSTER                 26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          5            METADATA LINK        Y N                                                                                                      N N
  
  
  SYS        C_OBJ#                                             2              2 CLUSTER                 26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          5            METADATA LINK        Y N                                                                                                      N N
  
  
  SYS        C_OBJ#                                             2              2 CLUSTER                 26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          5            METADATA LINK        Y N                                                                                                      N N
  
  
  SYS        C_OBJ#                                             2              2 CLUSTER                 26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          5            METADATA LINK        Y N                                                                                                      N N
  
  
  
  10 rows selected.
  
  Elapsed: 00:00:00.28
  
  PLAN_TABLE_OUTPUT
  ----------------------------------------------------------------------------------------------------
  SQL_ID  8jd6tct901zsq, child number 0
  -------------------------------------
  select * from   t order by object_id asc fetch first 10 rows only
  
  Plan hash value: 3047187157
  
  -----------------------------------------------------------------------------------------
  | Id  | Operation                | Name | Rows  | Bytes |TempSpc| Cost (%CPU)| Time     |
  -----------------------------------------------------------------------------------------
  |   0 | SELECT STATEMENT         |      |       |       |       | 25486 (100)|          |
  |   1 |  VIEW                    |      |    10 |  5070 |       | 25486   (1)| 00:00:01 |
  |   2 |   WINDOW SORT PUSHED RANK|      |   727K|    92M|   135M| 25486   (1)| 00:00:01 |
  |   3 |    TABLE ACCESS FULL     | T    |   727K|    92M|       |  3901   (1)| 00:00:01 |
  -----------------------------------------------------------------------------------------
  
  
  15 rows selected.
  
  Elapsed: 00:00:00.01
  
  OWNER      OBJECT_NAME          SUBOBJECT_NAME        OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE             CREATED   LAST_DDL_ TIMESTAMP           STATUS  T G S  NAMESPACE EDITION_NA SHARING            E O A DEFAULT_COLLATION                                                                                    D S CREATED_APPID CREATED_VSNID
  ---------- -------------------- -------------------- ---------- -------------- ----------------------- --------- --------- ------------------- ------- - - - ---------- ---------- ------------------ - - - ---------------------------------------------------------------------------------------------------- - - ------------- -------------
  MODIFIED_APPID MODIFIED_VSNID
  -------------- --------------
  SYS        I_OBJ#                                             3              3 INDEX                   26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          4            NONE                 Y N                                                                                                      N N
  
  
  SYS        I_OBJ#                                             3              3 INDEX                   26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          4            NONE                 Y N                                                                                                      N N
  
  
  SYS        I_OBJ#                                             3              3 INDEX                   26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          4            NONE                 Y N                                                                                                      N N
  
  
  SYS        I_OBJ#                                             3              3 INDEX                   26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          4            NONE                 Y N                                                                                                      N N
  
  
  SYS        I_OBJ#                                             3              3 INDEX                   26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          4            NONE                 Y N                                                                                                      N N
  
  
  SYS        I_OBJ#                                             3              3 INDEX                   26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          4            NONE                 Y N                                                                                                      N N
  
  
  SYS        I_OBJ#                                             3              3 INDEX                   26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          4            NONE                 Y N                                                                                                      N N
  
  
  SYS        I_OBJ#                                             3              3 INDEX                   26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          4            NONE                 Y N                                                                                                      N N
  
  
  SYS        I_OBJ#                                             3              3 INDEX                   26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          4            NONE                 Y N                                                                                                      N N
  
  
  SYS        I_OBJ#                                             3              3 INDEX                   26-JAN-17 26-JAN-17 2017-01-26:13:52:45 VALID   N N N          4            NONE                 Y N                                                                                                      N N
  
  
  
  10 rows selected.
  
  Elapsed: 00:00:00.29
  
  PLAN_TABLE_OUTPUT
  ----------------------------------------------------------------------------------------------------
  SQL_ID  fgs3tqafr6jna, child number 0
  -------------------------------------
  select * from   t order by object_id asc offset 10 rows fetch first 10
  rows only
  
  Plan hash value: 3047187157
  
  -----------------------------------------------------------------------------------------
  | Id  | Operation                | Name | Rows  | Bytes |TempSpc| Cost (%CPU)| Time     |
  -----------------------------------------------------------------------------------------
  |   0 | SELECT STATEMENT         |      |       |       |       | 25486 (100)|          |
  |   1 |  VIEW                    |      |   727K|   351M|       | 25486   (1)| 00:00:01 |
  |   2 |   WINDOW SORT PUSHED RANK|      |   727K|    92M|   135M| 25486   (1)| 00:00:01 |
  |   3 |    TABLE ACCESS FULL     | T    |   727K|    92M|       |  3901   (1)| 00:00:01 |
  -----------------------------------------------------------------------------------------
  
  
  16 rows selected.
  
  Elapsed: 00:00:00.01
  SQL> spool off
  