select a.id from numberbase a, pilotbase b where a.id=b.id

Execution Plan
----------------------------------------------------------

   0      SELECT STATEMENT Optimizer=CHOOSE (Cost=1 Card=2 Bytes=28)
   1    0   NESTED LOOPS (Cost=1 Card=2 Bytes=28)
   2    1     INDEX (FULL SCAN) OF 'PK_PILOTBASE' (UNIQUE) (Cost=1 Car
          d=2 Bytes=14)

   3    1     INDEX (UNIQUE SCAN) OF 'PK_NUMBERBASE' (UNIQUE)

...
create or replace view v_$sysstat as select * from v$sysstat;
create or replace public synonym v$sysstat for v_$sysstat;
grant select on v_$sysstat to select_catalog_role;
...

SQL> connect scott/tiger
Connected.
SQL> select * from v$mystat;
select * from v$mystat
              *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> 

SQL> connect sys / as sysdba
Enter password: ***********
Connected.
SQL> grant select on v_$mystat to scott;

Grant succeeded.

SQL> grant select on v_$statname to scott;

Grant succeeded.

SQL> 

SQL> set pagesize 9999
SQL> select s.name, v.value from v$mystat v, v$statname s where v.statistic#=s.statistic# and v.value>0;

NAME                                                                  VALUE
---------------------------------------------------------------- ----------

logons cumulative                                                         1
logons current                                                            1
opened cursors cumulative                                               147
opened cursors current                                                    1
user commits                                                              1
user calls                                                               97
recursive calls                                                        2404
recursive cpu usage                                                       1
session logical reads                                                   579
CPU used when call started                                                7
CPU used by this session                                                  7
session connect time                                             1090513206
process last non-idle time                                       1090513206
session uga memory                                                    77008
session uga memory max                                                77008
messages sent                                                             1
session pga memory                                                   220508
session pga memory max                                               220508
enqueue requests                                                          6
enqueue releases                                                          6
db block gets                                                             5
consistent gets                                                         574
physical reads                                                           34
db block changes                                                          5
redo synch writes                                                         1
free buffer requested                                                    35
commit cleanouts                                                          1
commit cleanouts successfully completed                                   1
switch current to new buffer                                              1
consistent gets - examination                                           309
shared hash latch upgrades - no wait                                     82
calls to kcmgas                                                           2
calls to get snapshot scn: kcmgss                                       200
redo entries                                                              3
redo size                                                               560
no work - consistent read gets                                          178
deferred (CURRENT) block cleanout applications                            1
table scans (short tables)                                                5
table scan rows gotten                                                    3
table scan blocks gotten                                                  3
table fetch by rowid                                                    108
cluster key scans                                                        78
cluster key scan block gets                                              79
rows fetched via callback                                                14
index fetch by key                                                      100
index scans kdiixs1                                                      74
cursor authentications                                                   10
buffer is pinned count                                                   38
buffer is not pinned count                                              271
workarea memory allocated                                                 4
workarea executions - optimal                                            88
parse time cpu                                                            2
parse time elapsed                                                       27
parse count (total)                                                     150
parse count (hard)                                                       13
parse count (failures)                                                    5
execute count                                                           186
bytes sent via SQL*Net to client                                      32702
bytes received via SQL*Net from client                                 5502
SQL*Net roundtrips to/from client                                        85
sorts (memory)                                                          107
sorts (rows)                                                            748

62 rows selected.