SELECT FROM hist_head$
497150Sep 27 2006 — edited Feb 1 2007The statement below is running on dev server (Oracel 10.1.0.4-aix 5.2) and the server is kind of slow. The statement runs under SMON login and show all the time as long operation. As long as I could see nobody runs anything on the server and a far as I checked everything else looks good.
There's no jobs or anything else scheduled as well.
Is this really the problem? Any solution,
Thanks a lot,mj
SELECT /*+ RULE */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#,
sample_size, minimum, maximum, distcnt, lowval, hival, density, col#,
spare1, spare2, avgcln
FROM hist_head$
WHERE obj# = :1
AND intcol# = :2