Oracle path analysis tool?

Looking for a tool that could take full advantage of an Oracle db

[cfx211]

We currently record traffic to certain areas of our site directly into our Oracle database in a format similar to traffic logs but fleshed out with some additional data. This table is extremely useful for understanding cause and effect behavior because it can be custom coded to record specific responses to site actions. For instance if you failed trying to login, we can code the error response displayed in the asp.

It can also be joined back to the rest of our database so for instance I can say for everyone who hits page X, tell me how many buy or signup.

This data would also be nice to do some path analysis with, but you can't really write SQL queries for that. Has anyone worked with a path analysis program that can take advantage of the fact that our log table can be easily joined to our sales or member tables.

For instance I would like to join our log table to our account create table and say for everyone who created an account today, tell me the 10 most common paths to that event. Or I would like to find out what people who fall into a certain profile do on our site.

I am looking for a free or inexpensive solution here, not something that costs an arm and a leg and requires a 3 month install. Our site is also fairly large so this program would have to be robust.

[aspdaddy]

I'm not sure if Netracker can do this type of thing, there are others here who use it who may know.

You might get some more ideas searching google for
clickstream ETL [google.com]