Re: Improve this querry!?

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1068245369.453336_at_yasure>...
> I could write a book on the subject you've asked. Lets start at the
> beginning.

Holy Molly. I'm not a DBA. I have been to Oracle Admin/DBA-1 class years ago - but do not do Oracle stuff regularly. However, I am the most knowledgeable person about Oracle so I get these tasks when they come up.  

> What is a "min" when used in the context "73 min of records"?

Minutes.

> But which optimizer mode are you using?

{mark_at_jaost1}>grep optim /intg/oracle/databases/MT/pfile/initMT.ora optimizer_mode = rule

> If CBO did you run DBMS_STATS to create current statistics for the
> optimizer?

By CBO - I assume you mean "cost based optimizer"? I have no idea what this is. And I'm not familiar with "running DBMS_STATS" - I'm sure I could, but would have to look it up.

> Have you run Explain Plan?

No. I wouldn't readily understand the output anyway. And when I say that, I mean I COULD do it, but I figure I'd spend more time trying to understand it than it was worth.

> What is the cardinality?

Big (to me) - I'm sure by your question you have seen larger databases. We get about 13 million messages a day. The database is 48g. We get about 10000 messages per minute (input) and the ratio is 1.8 avg output to each input message. The med_mt_tb is the input message (1 unique record [ISN]) and the mrd_mt_tb is the output messages (1 record for each delivery [same ISN as input]) . The database has 5-7 days worth of data.

> What percentage of records are being returns?

A 73 minute period would be less that 1 percent. (using 6 days of data). I would have to run this more that 100 times
> Why haven't you patched to 8.1.7.4?

We are running this on IBM Dynix/ptm and I have pressed for them to install 8.1.7.4 - however, management is pursuing a port to another platform (either SUN, IBM (AIX), etc) and would rather pursue that in priority.

> and on and on and on.

Would love to entertain more questions if it will bring a solution... Thanks!

Mark. Received on Mon Nov 10 2003 - 10:40:30 CST