Hello All,
i am doing some performance testing, in this i can see "logical read from cache" in statistics. But i have cleared the Buffer cache and shared pool using
alter tablespace DATA11 offline; (to make objects associated with the tablespace to invalid)
alter tablespace DATA11 online;
alter session enable parallel dml;
alter system flush buffer_cache;
alter system flush shared_pool;
create table test_table
tablespace DATA11
Parallel (degree 8)
NolOGGING
AS
SELECT /* + append */
CREATED_BY,
CREATED,
...
...
FROM table_1;
And also took tablespace offline and again took it to online.
But still i can see the "logical read from cache" Can anyone tell me why i am getting this?
STATISTICS:
| logical read bytes from cache | 6563463168 |
| cell physical IO interconnect bytes | 6307463168 |
| cell physical IO interconnect bytes | 6296674304 |
| cell physical IO interconnect bytes | 6291234816 |
| cell physical IO interconnect bytes | 6289620992 |
| cell physical IO interconnect bytes | 6267420672 |
| cell physical IO interconnect bytes | 6257401856 |
| cell physical IO interconnect bytes | 6241845248 |
| cell physical IO interconnect bytes | 5828321280 |
| logical read bytes from cache | 5393104896 |
| logical read bytes from cache | 5250514944 |
| logical read bytes from cache | 4909072384 |
| logical read bytes from cache | 4800905216 |
| logical read bytes from cache | 4775616512 |
| logical read bytes from cache | 4428521472 |
| logical read bytes from cache | 4366057472 |
| physical read bytes | 3516940288 |