Buffer waits on partition table
My DBA partition table two weeks ago. The partitioning is ok, I review statspack (we use 9.2.0.4) and see at the "Top 5 Buf. Busy Waits per Segment for DB", I can see Buffer Busy Waits of these partitions are high, they look like:
Buffer
Subobject Obj. Busy
Owner Tablespace Object Name Name Type Waits %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
ACEVNPRD2 LIFEDATA_T_1 T_CUST_DEPOSIT_LIST T_01012010 TABLE 8,479 23.26
ACEVNPRD2 LIFEDATA_T_2 T_CUST_DEPOSIT_LIST T_31122010 TABLE 5,081 13.94
ACEVNPRD2 LIFEDATA_T _1 T_CUST_DEPOSIT_LIST T_31122011 TABLE 3,350 9.19
ACEVNPRD2 LIFEDATA_T _3 T_CUST_DEPOSIT_LIST T_30062011 TABLE 3,113 8.54
ACEVNPRD2 LIFEDATA_T _2 T_CUST_DEPOSIT_LIST T_30062012 TABLE 2,554 7.01