This was previously sent to PHP-DB and PHP-GENERAL, but due to the responses and lower traffic, I'm going to send it here as well. I've gotten a couple e-mails from other coders interested in doing something like this if someone out there can point us in the right direction:
What would be the best way to set up a database for tracking users?
Need to track say, a user ID, date, time, and their path throughout the site:
example:
http://www.blah.com
http://www.blah.com/page1.php
http://www.blah.com/search.php
http://www.blah.com/cgi-bin/script.cgi
and put this information into an Oracle database. I'm a little unsure because I've never worked with Oracle before, only MySQL.. is the transition really difficult?