Re: LOB Table - PCTVERSION 50%

From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Thu, 20 Oct 2016 21:28:08 +0200
Message-ID: <CALH8A91oaN=Zsu-w2kAvFdarsqr00CeA5LvE9BOCFk8CjfB1Mg_at_mail.gmail.com>



Hi Nick,

 ora-1555 and ora-22294 are something different.

for the first, do you see them on LOBs or other columns?

for the last, it claims the LOB was opened RO - so what was the statement attempt to do?

before going onto detail, I'd like to know if we have 1 or 2 issues.

Martin

2016-10-20 21:19 GMT+02:00 Nik Tek <niktek2005_at_gmail.com>:

> Hi Oracle gurus,
>
> I have a question, I'm noticing lot of ora-1555 and ora-22294 (snapshot
> too old) errors.
>
> The default value is 10% for PCTVERSION as you all know.
>
> I was wondering if I can change the value to 50%, would this have any side
> effects?
> How do I measure if there a problem?
>
> I could not find much of the information related to PCTVERSION for LOB
> tables.
>
> --
> Thank you
> NikTeki
>

-- 
Martin Berger           martin.a.berger_at_gmail.com
                                  +43 660 2978929 <+436602978929>
_at_martinberx <https://twitter.com/martinberx>
http://berxblog.blogspot.com

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 20 2016 - 21:28:08 CEST

Original text of this message