Consistent gets oracleTag Archive

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… Continue Reading Logical IO vs Physical IO vs Consistent gets oracle