Hi guys,
I'm trying to get some info on the IO per object, so I installed catio.sql.
Next I ran "exec sample_io(5,60);" a few times at busy and not-so-busy moments. But when I look at the result-view "IO_PER_OBJECT", I always get the same result:
Code:
SQL> select * from sys.io_per_object;
NAME PARTITION_NAME KIND IO_TYPE BLOCKS_READ
---------------- --------------- ---------------- -------------------- -----------
C_TS# CLUSTER sequential 1
Database: 8.1.7.0.0 on Wi(n)dows 2000 Adv.Server
Buffer cache:
Code:
SQL> select * from vw_ideal_buffer_cache ;
DATE BUFFER_POOL CURRENT IDEAL
-------- --------------- ---------- ----------
...
13-04-04 DEFAULT 8192 7256
I think I'm following the correct procedure... How must I interpret this info?
I hope someone can help me...