[thesite] dean, some oracle things again..

[Daniel J. Cody]

i dunno if you've gotten a chance to peak around on the new oracle box
yet, but here are a couple things we need to look at..
buffer cache hit rate is in the 30's - db_block_buffers ?
parse/execute ratio seems to be too high

also , the front page query is taking like 20 seconds to run.. can we
make a view out of this:?

SELECT
    content.contentid,
    content.keyphrase,
    content.contentname,
    content.synopsis,
    content.datemod,
        content.replies,
    users.userid,
    users.who,
    categorys.category,
    categorys.categoryid,
    (SELECT Count(*) FROM replies WHERE contentid = content.contentid
AND datemod > '') AS newcomments
  FROM
    content,
    users,
    categorys
  WHERE
      content.signoff = 1
      AND content.userid = users.userid
      AND content.categoryid <> 23
      AND content.categoryid <> 26
      AND content.categoryid <> 9741
      AND content.categoryid = categorys.categoryid
  
  ORDER BY
    content.datemod DESC,
    content.contentid DESC

thanks bud :)