Forum OpenACS Q&A: Re: ACS3/Oracle DATA Model Question

Collapse
Posted by Dirk Gomez on
It should be safe to remove 99.9% of the data in that table. Is the scheduler for this proc not working?

Your config files look fine. Take a look at your log files and see if something weird happens. Any queries that take forever?
Have a close look at V$SESSION_LONGOPS.

Are you using ACS3 pre- or post-bind variables?

If pre-variables, then Oracle may just be killed by too much parsing - how busy is your site? - try cursor_sharing=force to reduce parsing activity.

Collapse
Posted by Miguel Albuquerque on
V$SESSION_LONGOPS looks ok although i'am not sure what am i looking for in that table...there is no unfinished queries, and the average time seems pretty good actually.

ACS3 pre or post-variables? How do I check that? Not sure i understand what you mean.

Our site has about 1500 - 2500 hits per day.

Collapse
Posted by Dirk Gomez on
What is the version of your Oracle driver? It should be 2.6.

How are SQL queries generated, like this:

select foo from bar where bar_id=$bar_id

or like this:

select foo from bar where bar_id=:bar_id

Additionally take a look at the SQL queries that were executed on your system. v$sql is the data dictonary view you want to look into.