topic Re: Setting Appropriate Size for ATTRBUFSIZE Parameter in Data Management Questions

Setting Appropriate Size for ATTRBUFSIZE Parameter

BruceGreen — Thu, 09 Jun 2011 20:56:44 GMT

Hi Guys,
I wonder how we can determine and set an appropriate size of ATTRBUFSIZE in a way that to have a perfect performance besides NOT wasting too memory?
As you know, the default value of ATTRBUFSIZE is 50000 , If we set too low value then the buffer will not be used effectively, slowing performance. A too large a value also will wastes memory, sh how we can set the best value for this parameter?

Thanks for your time in advanced

Re: Setting Appropriate Size for ATTRBUFSIZE Parameter

VinceAngelo — Thu, 09 Jun 2011 22:44:39 GMT

There isn't any one perfect value ATTRBUFSIZE for all datasets. How many columns do you have
in your average table, and how many in your maximum? What is the sum of the *potential*
widths in your average table, and how wide is your maximum? What is the *actual* width of
your average and widest tables? Do you store a lot of BLOBs, CLOBs or NCLOBs? Do you have
a very large number of concurrent connections?

I've never had a reason to change any parameter controlled by 'sdeconfig' beyond CONNECTIONS,
INT64TYPES, TCPKEEPALIVE, and MAXGRIDSPERFEAT (and the number of changes at customer
sites beyond CONNECTIONS could be measured with a single digit). Do you have some reason
to believe your site is misconfigured? It's a lot easier to hurt performance with the *SIZE and
MAX* parameters than it is to improve it (they all interrelate with one another).

- V

Re: Setting Appropriate Size for ATTRBUFSIZE Parameter

BruceGreen — Fri, 10 Jun 2011 06:04:33 GMT

Hi Vangelo,
Thanks for your great reply.The reason that I am trying to update the ATTRBUFSIZE value is I was encountering with an issue (Error) as "Attribute buffer is too small" whenever I want to delete a road in ArcSDE.
Can you please let me know that what could be possible cause for this? I update the defualt value of ATTRBUFSIZE to 500000 and then I can edit(delete) the layer withot any problem but I am not sure how to tune the best value size for it?

Thanks,

Re: Setting Appropriate Size for ATTRBUFSIZE Parameter

VinceAngelo — Fri, 10 Jun 2011 09:58:28 GMT

I couldn't begin to help you before you answered the litany of questions I posed last time.
In addition, you'd need to tell:
Which database you're using, and its version and service pack level,
Which version and service pack of ArcSDE you are using,
Which version and service pack of ArcGIS you are using, , and
Whether the table you are accessing is versioned.

This is probably a topic best raised with Tech Support, but you still need to collect the
answers to all these questions, since they'll ask them as well.

- V

Re: Setting Appropriate Size for ATTRBUFSIZE Parameter

BruceGreen — Fri, 10 Jun 2011 16:01:08 GMT

Hi,
Here are some information about the system I am working on:

SELECT BYTES/1024 FROM SYS.DBA_SEGMENTS WHERE SEGMENT_NAME='Map_ROAD' AND SEGMENT_TYPE='TABLE';

BYTES/1024
----------------------
13312
================================================================
SELECT AVG_ROW_LEN * NUM_ROWS FROM USER_TABLES WHERE table_name = 'Map_ROAD';

AVG_ROW_LEN* NUM_ROWS
----------------------
9083080
================================================================
SELECT TABLE_NAME, ROUND((AVG_ROW_LEN * NUM_ROWS / 1024), 2) ROW_SIZE_KB, (BLOCKS * 😎 BLOCK_SIZE_KB FROM USER_TABLES WHERE table_name = 'Map_ROAD'

TABLE_NAME : Map_ROAD
ROW_SIZE_KB : 8870.2
BLOCK_SIZE_KB: 6032

Which database you're using, and its version and service pack level,
- Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
Which version and service pack of ArcSDE you are using,
- ArcSDE 9.3 Service Pack 1
Which version and service pack of ArcGIS you are using, , and
- ArcGIS 9.3.1 - Service Pack 2
Whether the table you are accessing is versioned.
-Yes the table is version-ed.
Do you store a lot of BLOBs, CLOBs or NCLOBs?
No
Do you have a very large number of concurrent connections?
Not Really

Re: Setting Appropriate Size for ATTRBUFSIZE Parameter

VinceAngelo — Fri, 10 Jun 2011 16:34:17 GMT

In this context, row width does not include geometry storage. Keep in mind that ATTRBUFSIZE
impacts *every* table. You'll need to give Tech Support the DBTUNE creation parameters and a
data sample if they're going to be able to reproduce the error.

- V

Re: Setting Appropriate Size for ATTRBUFSIZE Parameter

BruceGreen — Fri, 10 Jun 2011 16:56:19 GMT

I am sorry vangelo, but I didn't get what exactly you mean?

Re: Setting Appropriate Size for ATTRBUFSIZE Parameter

VinceAngelo — Fri, 10 Jun 2011 18:50:38 GMT

The information you provided did not answer all of the initial questions. You will need to
provide even more data to Tech Support to discover why you got this message.

- V

Re: Setting Appropriate Size for ATTRBUFSIZE Parameter

BruceGreen — Fri, 10 Jun 2011 20:31:43 GMT

Can you please let me know what else is needed?
I really appreciate if you kindly let me know what exactly you need to figure the issue out?

Re: Setting Appropriate Size for ATTRBUFSIZE Parameter

VinceAngelo — Fri, 10 Jun 2011 21:05:56 GMT

Please contact Tech Support. They will tell you what they need.

- V

Re: Setting Appropriate Size for ATTRBUFSIZE Parameter

AndresCastillo — Mon, 01 Mar 2021 14:57:20 GMT

This is addressed for Oracle in

Bug BUG-000107844:

https://support.esri.com/en/bugs/nimbus/QlVHLTAwMDEwNzg0NA==

Re: Setting Appropriate Size for ATTRBUFSIZE Parameter

andreamangeruca — Tue, 16 Jan 2024 10:53:54 GMT

I had the same problem!!

The technical support suggest to degrease the character limit to 24000.

I dont'know how to do this. Anybody can help me?

thanks