How to query the operation of hot spot fast and hot spot block in database
This article mainly introduces how to query the hot spot fast and hot block operation in the database. The article is very detailed and has certain reference value. Interested friends must read it!
---Query hot block object sql statement:
SELECT *
FROM (SELECT O.OWNER, O.OBJECT_NAME, O.OBJECT_TYPE, SUM(TCH) TOUCHTIME,
FROM X$BH B, DBA_OBJECTS O
WHERE B.OBJ = O.DATA_OBJECT_ID
AND B.TS# > 0
GROUP BY O.OWNER, O.OBJECT_NAME, O.OBJECT_TYPE
ORDER BY SUM(TCH) DESC)
WHERE ROWNUM
