Re: LOB Table - PCTVERSION 50%
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-lReceived on Thu Oct 20 2016 - 21:28:08 CEST