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.
