Neil, I am not sure if i am understanding what you are saying.... but i will give it a try. We use cfa_contentobjectget and getmultiple... to retrieve content.... this all comes out of the objects table i would expect.... would it be wrong for me to assume that there should be a index on this table by default...? .. but please... tell me if i am saying something stupid now... Mathijs "Robertson-Ravo, Neil (REC)" <[EMAIL PROTECTED]> wrote:I think you will find that there are a lot of calls for objects and types not performed on an index...!
So you know what tables are affectted? -----Original Message----- From: Mathijs dew [mailto:mathijsdew@;yahoo.com] Sent: 23 October 2002 11:44 To: Spectra-Talk Subject: Spectra/Oracle issue: high non-index lookup ratio on codb Hi, I have a .. uhmmm... let's call it a bit of a weird question. Okay here's the case: We have a large public website running using Spectra 1.5.1 using a Oracle 8.1.7 Enterprise database (runnin on a largescaled AIX environment). The spectra site runs on a highend compaq dlt380, 1 GB of ram. The problem: >From the dba's who maintain the database environment i've received the following information. They are saying the following: "We see a very high non-index lookup ratio in the application (they are talking about the codb). Could you please have a look at it." Then they have also supplied some statistics. They measured the performance during a two hour time span. consistent gets = 7440165 db block gets = 5195 physical reads = 93272 logical reads = 7445360 hit ratio = 98 table scans long = 697 table scans short = 97 non-index lookup ratio = 87 My guess would be... some bad use of indexes in the codb db's design. But what i can't do is just go in there and make some changes and so... because i am not sure about the things that can go wrong. So my question would be if somebody out there experienced the same problem... and how did they go about handling this. Kind regards. Mathijs --------------------------------- Do you Yahoo!? Y! Web Hosting - Let the expert host your web site ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
