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

Collapse
6: Re: ACS3/Oracle DATA Model Question (response to 5)
Posted by Miguel Albuquerque on 06/16/04 03:45 PM
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
7: Re: ACS3/Oracle DATA Model Question (response to 6)
Posted by Dirk Gomez on 06/16/04 04:14 PM
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.