Hi,
I am using Oracle's Intermedia for text searches in my database. This is one of the important functionality as far as the application is concerned. My application accesses the database thru JDBC. I have many questions regarding the time taken for a particular search.
The PL/SQL procedure I have written accesses the database with the intermedia search string and after the search I am joining almost four tables with the output of intermedia using temporary tables. i.e I am storing the search output in temporary tables and then joining the tables with the temporary tables. Then the output I am giving as a cursor OUT parameter which the application accesses.
1. I have pinned the packages into the shared pool using DBMS_SHARED_POOL.keep procedure. Since the application is using the same username with different sessions, does this help?
2.There was a parameter SESSION_SHARED_CURSORS which I know is obsolete in Oracle 8i. Is there any similar parameters which I can use?
3. I have kept SESSION_CACHED_CURSORS as 90. Does this help?
4. With 75 users doing the search with less than 50 rows of result set I am getting the time taken as 20 secs.
5. Does using the same input parameters by different sessions will use the same result set which is cached?
6. Does the intermedia deteriorates the performance?
An immediate answer is greatly appreciated.
I am using Oracle's Intermedia for text searches in my database. This is one of the important functionality as far as the application is concerned. My application accesses the database thru JDBC. I have many questions regarding the time taken for a particular search.
The PL/SQL procedure I have written accesses the database with the intermedia search string and after the search I am joining almost four tables with the output of intermedia using temporary tables. i.e I am storing the search output in temporary tables and then joining the tables with the temporary tables. Then the output I am giving as a cursor OUT parameter which the application accesses.
1. I have pinned the packages into the shared pool using DBMS_SHARED_POOL.keep procedure. Since the application is using the same username with different sessions, does this help?
2.There was a parameter SESSION_SHARED_CURSORS which I know is obsolete in Oracle 8i. Is there any similar parameters which I can use?
3. I have kept SESSION_CACHED_CURSORS as 90. Does this help?
4. With 75 users doing the search with less than 50 rows of result set I am getting the time taken as 20 secs.
5. Does using the same input parameters by different sessions will use the same result set which is cached?
6. Does the intermedia deteriorates the performance?
An immediate answer is greatly appreciated.