Logical IO vs Physical IO vs Consistent gets oracle
Logical IO vs Physical IO vs Consistent gets I have created 1 GB table T1. Let me check how many blocks are there in the table after I have analyzed it. SQL> select BLOCKS from user_tables where table_name=’T1′; BLOCKS ———- 139153 Autotrace report Let me clean buffer cache and check the auto trace report. SQL>set autotrace […]