DROP INDEX CMON_UPLOAD_DETAILS_SERIAL;
CREATE INDEX CMON_UPLOAD_DETAILS_SERIAL ON CMON_UPLOAD_DETAILS(NLSSORT(SERIAL,'NLS_SORT=RUSSIAN'));
begin dbms_stats.gather_table_stats('SOM','CMON_UPLOAD_DETAILS'); end;
/
alter session set NLS_SORT = russian; -- russian --binary
select --+ gather_plan_statistics --chk1
serial 
from CMON_UPLOAD_DETAILS
order by serial;

SQL_ID  9wv1s7v3818ck, child number 0
-------------------------------------
select --+ gather_plan_statistics --chk1 serial from 
CMON_UPLOAD_DETAILS order by serial

Plan hash value: 3483996437

---------------------------------------------------------------------------------------------------------------------------------
| Id  | Operation            | Name                | Starts | E-Rows | A-Rows |   A-Time   | Buffers |  OMem |  1Mem | Used-Mem |
---------------------------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT     |                     |      1 |        |   4886 |00:00:00.02 |     110 |       |       |          |
|   1 |  SORT ORDER BY       |                     |      1 |   4886 |   4886 |00:00:00.02 |     110 |   337K|   337K|  299K (0)|
|   2 |   PARTITION RANGE ALL|                     |      1 |   4886 |   4886 |00:00:00.01 |     110 |       |       |          |
|   3 |    TABLE ACCESS FULL | CMON_UPLOAD_DETAILS |      3 |   4886 |   4886 |00:00:00.01 |     110 |       |       |          |
---------------------------------------------------------------------------------------------------------------------------------