Re: Increasing load on Oracle

Select bigger tables for nested query disable indexes in sql statement then watch the performance by making timed_statistcs=true

Rao

--

On Tue, 26 Sep 2000 07:06:14  
 Erma Fernando wrote:


>Our Sun 3500 box houses the 8.1.6 database which is in test mode.  We

>are going to install another application (non Oracle which comprises a

>core document repository etc). This application needs 50% resources of

>our machine (that's the specification).  The application is also in the

>test phase.  How can I increase the workload on Oracle so that I can

>test the overall performance?  (imports, exports, queries?????).  Also

>how will I measure the performance?

>Thank you very much for your help. 

>-- 

>Please see the official ORACLE-L FAQ: http://www.orafaq.com

>-- 

>Author: Erma Fernando

>  INET: FernanEr_at_oeb.gov.on.ca

>

>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).

>



Get your FREE Email and Voicemail at Lycos Communications at