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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
