Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Snapshot too old during stress test... how to avoid

Re: Snapshot too old during stress test... how to avoid

From: <Jared.Still_at_radisys.com>
Date: Thu, 05 Jun 2003 08:43:07 -0700
Message-ID: <F001.005AA929.20030604150500@fatcity.com>


... and if it still doesn't work, use the trick of putting a transaction in
each of the rollback segments while the system is otherwise quiesced, and *do not* commit or rollback the transactions.

This forces the rollbacks to extend if necessary, they will never wrap back to the first extent ( actually the second) as long as those transactions
are not committed.

It just uses a lot of disk space. Disk is cheap, right? :)

Consider offlining all your production RBS and creating temporary ones that you can easily drop later.

I've used it with SAP client copies, which will not run to completion without
doing this, at least on our system.

Jared

Kirtikumar Deshpande <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]
 06/04/2003 09:45 AM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc: 
        Subject:        Re: Snapshot too old during stress test... how to avoid


Try removing optimal setting, and shrinking RBS to the min extents (or even below) before running
your tests.

> scenarios.
>
> Im in 8.1.7.3 and I have increased the size of my RBS tablespace to 11GB

> for this test. I have 4 standard RBS with optimal size set to 1GB. Why
> would I get a snapshot too old? I would think that 11GBs of rollback
would
> be big enough. Would increasing the number of Rollback segments avoid
this
> even though I have the same amount of space in the tablespace?
>
> In reality Im going to seriallize the process to avoid this and to
improve
> performance, however, I want to stress the system.
>
> any advice?
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: <[EMAIL PROTECTED]
> INET: [EMAIL PROTECTED]
>
 



Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
Received on Thu Jun 05 2003 - 10:43:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US