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
