oracle pdb受限制模式,inmemory选项不能用于PDB?

读2次，逻辑读就少了

SQL> create table as_1 as select * from all_source;

Table created.

SQL> select count(*) from as_1;

COUNT(*)

----------

342458

SQL> set autot on

SQL> /

COUNT(*)

----------

342458

Execution Plan

----------------------------------------------------------

Plan hash value: 1097547578

-------------------------------------------------------------------

| Id  | Operation          | Name | Rows  | Cost (%CPU)| Time     |

-------------------------------------------------------------------

|   0 | SELECT STATEMENT   |      |     1 |  2202   (1)| 00:00:01 |

|   1 |  SORT AGGREGATE    |      |     1 |            |          |

|   2 |   TABLE ACCESS FULL| AS_1 |   342K|  2202   (1)| 00:00:01 |

-------------------------------------------------------------------

Statistics

----------------------------------------------------------

0  recursive calls

0  db block gets

7988  consistent gets

0  physical reads

0  redo size

544  bytes sent via SQL*Net to client

552  bytes received via SQL*Net from client

2  SQL*Net roundtrips to/from client

0  sorts (memory)

0  sorts (disk)

1  rows processed

SQL> set autot off

SQL> alter table as_1 inmemory;

Table altered.

SQL> select * from V$INMEMORY_AREA;

POOL                       ALLOC_BYTES USED_BYTES POPULATE_STATUS                CON_ID

-------------------------- ----------- ---------- -------------------------- ----------

1MB POOL                     804257792          0 DONE                                3

64KB POOL                    251658240          0 DONE                                3

SQL> set autot on

SQL> select count(*) from as_1;

COUNT(*)

----------

342458

Execution Plan

----------------------------------------------------------

Plan hash value: 1097547578

----------------------------------------------------------------------------

| Id  | Operation                   | Name | Rows  | Cost (%CPU)| Time     |

----------------------------------------------------------------------------

|   0 | SELECT STATEMENT            |      |     1 |    82   (0)| 00:00:01 |

|   1 |  SORT AGGREGATE             |      |     1 |            |          |

|   2 |   TABLE ACCESS INMEMORY FULL| AS_1 |   342K|    82   (0)| 00:00:01 |

----------------------------------------------------------------------------

Statistics

----------------------------------------------------------

18  recursive calls

0  db block gets

8002  consistent gets

0  physical reads

0  redo size

544  bytes sent via SQL*Net to client

552  bytes received via SQL*Net from client

2  SQL*Net roundtrips to/from client

2  sorts (memory)

0  sorts (disk)

1  rows processed

SQL> /

COUNT(*)

----------

342458

Execution Plan

----------------------------------------------------------

Plan hash value: 1097547578

----------------------------------------------------------------------------

| Id  | Operation                   | Name | Rows  | Cost (%CPU)| Time     |

----------------------------------------------------------------------------

|   0 | SELECT STATEMENT            |      |     1 |   119   (1)| 00:00:01 |

|   1 |  SORT AGGREGATE             |      |     1 |            |          |

|   2 |   TABLE ACCESS INMEMORY FULL| AS_1 |   342K|   119   (1)| 00:00:01 |

----------------------------------------------------------------------------

Statistics

----------------------------------------------------------

0  recursive calls

0  db block gets

3  consistent gets

0  physical reads

0  redo size

544  bytes sent via SQL*Net to client

552  bytes received via SQL*Net from client

2  SQL*Net roundtrips to/from client

0  sorts (memory)

0  sorts (disk)

1  rows processed

SQL>