| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> HP OpenView Service Desk 3.0
has any body use or administering this application please?
I have encountered with several problems, because of the bad application design. eg they are not using bind variables, there 4 or 5 similar statements with the count upto 300 or more. lots of full table scan. though I have indexed some but some other heavily used table (4000 rows with long columns therefore used about 600 blocks of 8k block) can not be indexed as there are only a few distinct values. and thing of setting shared_cursor = force. also use lots of outer joins.
look at the stat report,comparing the total wait time to 'cpu used in this session', total wait time comes less than 1 %, so most of the time it spends on is executing statements
any advice please?
Thanks And Regards
Chark Sairlao
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sairlao, Chark
INET: SairlaoC_at_transfield.com.au
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Jun 18 2001 - 21:36:23 CDT
 |
 |