Oracle-L: RE: OCP Architecture question

From: Ed Sherman <esherman_at_techskills.com>
Date: Fri, 15 Aug 2003 05:00:43 -0800
Message-ID: <F001.005CAE94.20030815050043@fatcity.com>

Ryan,

I will research the answer but I have an urgent question.

Do you have SelfTest Software for the SQL and PL/SQL test or do you have the Architecure and Administration SelfTest Software?

Thanks,
Ed
  -----Original Message-----
  From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]On Behalf Of Ryan
  Sent: Thursday, August 14, 2003 9:24 PM   To: Multiple recipients of list ORACLE-L   Subject: OCP Architecture question

Im using the self test software and here is a question... I dont like the answers. Please tell me if Im wrong.

Which Three methods can be used to avoid snapshot too old errors. This is for the 8i test.

User larger extents
Increase MAXEXTENTS for existing rollback segments
Create rollback segments with higher optimal values
Create rollback segments iwth high minextents
Run long queries when transaction processing is high.

Ruling out 5 is obvious. The test says its.

1,3,4

How does using large extents help this? What about a higher minextents value?

--

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

Author: Ed Sherman
INET: esherman_at_techskills.com

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: 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 Fri Aug 15 2003 - 08:00:43 CDT