????6.??ж?????????δ???????In-Memory?????
SQL> SELECT * FROM V$INMEMORY_AREA;
POOL                 ALLOC_BYTES USED_BYTES POPULATE_STATUS          CON_ID
-------------------- ----------- ---------- -------------------- ----------
1MB POOL               837812224          0 DONE                          3
64KB POOL              201326592          0 DONE                          3
SQL> select count(*) from bmw.t;
COUNT(*)
----------
90927
????7.?????κ???????USED_BYTES????????????
????SQL> SELECT * FROM V$INMEMORY_AREA;
????POOL                 ALLOC_BYTES USED_BYTES POPULATE_STATUS          CON_ID
????-------------------- ----------- ---------- -------------------- ----------
????1MB POOL               837812224    4194304 DONE                          3
????64KB POOL              201326592     131072 DONE                          3
????8.???????м??
SQL> set autot trace
SQL>  SELECT * FROM bmw.t;
90927 rows selected.
Execution Plan
----------------------------------------------------------
Plan hash value: 1601196873
-----------------------------------------------------------------------------------
| Id  | Operation                  | Name | Rows  | Bytes | Cost (%CPU)| Time     |
-----------------------------------------------------------------------------------
|   0 | SELECT STATEMENT           |      | 90927 |     9M|    20  (20)| 00:00:01 |
|   1 |  TABLE ACCESS INMEMORY FULL| T    | 90927 |     9M|    20  (20)| 00:00:01 |
-----------------------------------------------------------------------------------
Statistics
----------------------------------------------------------
5  recursive calls
0  db block gets
5  consistent gets
0  physical reads
0  redo size
4944325  bytes sent via SQL*Net to client
67223  bytes received via SQL*Net from client
6063  SQL*Net roundtrips to/from client
0  sorts (memory)
0  sorts (disk)
90927  rows processed
???????????????????TABLE ACCESS INMEMORY FULL??裬????consistent gets?5.???????INMEMORY??????????????????????????