alter session set statistics_level=all;

--create user, grant permissions, connect with the user:

create user ANDREY identified by whatever;
grant dba to ANDREY;
conn andrey/password@connstring;

--create the table for the testcase

 create table testcase
 (id number, name varchar(15));

--fill it with data

begin
for i in 1..50000 loop
insert into testcase values
(i, 'name' || i);
end loop;
end;

-commit:
commit;

--set statistics level to all:

alter session 
set statistics_level = all;

--run the query:

select * 
from testcase;

--then run the query to detect its sql_id:

select sql_id,prev_sql_id 
from v$session v
where 
lower(program) like '%plus%'
and upper(username) like '%ANDREY%'
order by logon_time desc

--make sure that this is my query:

select sql_text 
from v$sql 
where sql_id = '22qf4xxf1v5za';


--then query the plan table to try and see A-ROWS, 
--in the same session, or another one:

select * from table(dbms_xplan.display_cursor('22qf4xxf1v5za', 0 , 'all allstats advanced'))

--also tried
--select * from table(dbms_xplan.display_cursor('22qf4xxf1v5za', 0 , 'ADVANCED ALLSTATS LAST'))

SQL> @andrey
SQL> set echo on
SQL> 
SQL> set linesize 1000
SQL> set pagesize 1000
SQL> 
SQL> drop table testcase;
drop table testcase
           *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> 
SQL> --create the table for the testcase
SQL> 
SQL>  create table testcase
  2   (id number, name varchar(15));

Table created.

SQL> 
SQL> --fill it with data
SQL> 
SQL> begin
  2  for i in 1..50000 loop
  3  insert into testcase values
  4  (i, 'name' || i);
  5  end loop;
  6  end;
  7  /

PL/SQL procedure successfully completed.

SQL> 
SQL> commit;

Commit complete.

SQL> 
SQL> --set statistics level to all:
SQL> 
SQL> alter session
  2  set statistics_level = all;

Session altered.

SQL> 
SQL> --run the query:
SQL> 
SQL> select count(*) from testcase;

  COUNT(*)
----------
     50000

SQL> 
SQL> select * from table(dbms_xplan.display_cursor('', '' , 'all allstats advanced'));

PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL_ID  f4wzjckg705zs, child number 0
-------------------------------------
select count(*) from testcase

Plan hash value: 3221245523

-----------------------------------------------------------------------------------------------------------------
| Id  | Operation          | Name     | Starts | E-Rows | Cost (%CPU)| E-Time   | A-Rows |   A-Time   | Buffers |
-----------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT   |          |      1 |        |    40 (100)|          |      1 |00:00:00.01 |     141 |
|   1 |  SORT AGGREGATE    |          |      1 |      1 |            |          |      1 |00:00:00.01 |     141 |
|   2 |   TABLE ACCESS FULL| TESTCASE |      1 |  53169 |    40   (3)| 00:00:01 |  50000 |00:00:00.01 |     141 |
-----------------------------------------------------------------------------------------------------------------

Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------

   1 - SEL$1
   2 - SEL$1 / TESTCASE@SEL$1

Outline Data
-------------

  /*+
      BEGIN_OUTLINE_DATA
      IGNORE_OPTIM_EMBEDDED_HINTS
      OPTIMIZER_FEATURES_ENABLE('11.2.0.3')
      DB_VERSION('11.2.0.3')
      ALL_ROWS
      OUTLINE_LEAF(@"SEL$1")
      FULL(@"SEL$1" "TESTCASE"@"SEL$1")
      END_OUTLINE_DATA
  */

Column Projection Information (identified by operation id):
-----------------------------------------------------------

   1 - (#keys=0) COUNT(*)[22]

Note
-----
   - dynamic sampling used for this statement (level=2)


43 rows selected.

SQL> 
SQL> select * from table(dbms_xplan.display_cursor('f4wzjckg705zs', 0 , 'all allstats advanced'));

PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL_ID  f4wzjckg705zs, child number 0
-------------------------------------
select count(*) from testcase

Plan hash value: 3221245523

-----------------------------------------------------------------------------------------------------------------
| Id  | Operation          | Name     | Starts | E-Rows | Cost (%CPU)| E-Time   | A-Rows |   A-Time   | Buffers |
-----------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT   |          |      1 |        |    40 (100)|          |      1 |00:00:00.01 |     141 |
|   1 |  SORT AGGREGATE    |          |      1 |      1 |            |          |      1 |00:00:00.01 |     141 |
|   2 |   TABLE ACCESS FULL| TESTCASE |      1 |  53169 |    40   (3)| 00:00:01 |  50000 |00:00:00.01 |     141 |
-----------------------------------------------------------------------------------------------------------------

Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------

   1 - SEL$1
   2 - SEL$1 / TESTCASE@SEL$1

Outline Data
-------------

  /*+
      BEGIN_OUTLINE_DATA
      IGNORE_OPTIM_EMBEDDED_HINTS
      OPTIMIZER_FEATURES_ENABLE('11.2.0.3')
      DB_VERSION('11.2.0.3')
      ALL_ROWS
      OUTLINE_LEAF(@"SEL$1")
      FULL(@"SEL$1" "TESTCASE"@"SEL$1")
      END_OUTLINE_DATA
  */

Column Projection Information (identified by operation id):
-----------------------------------------------------------

   1 - (#keys=0) COUNT(*)[22]

Note
-----
   - dynamic sampling used for this statement (level=2)


43 rows selected.

SQL> 
SQL> drop table testcase;

Table dropped.

SQL> 
SQL> exit

1. make the following settings


set linesize 1000
set pagesize 1000



2. then run


alter session set statistics_level=all;



3. then run your sql,
4. after that run the following select:


select plan_table_output from table ( sys.dbms_xplan.display_cursor( '','','ADVANCED ALLSTATS LAST'));

select plan_table_output from table ( sys.dbms_xplan.display_cursor( '','','ADVANCED ALLSTATS LAST'));