Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.4K Development
- 17 Developer Projects
- 139 Programming Languages
- 293.1K Development Tools
- 111 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 161 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 475 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Selecting an extent size for Queues

530582
Member Posts: 3
Hi,
Has anyone got experience in selecting an extent size for BDB Queue toplogy databases? I'm trying to pick an extent size for a database and have come to the conclusion that throughput of data through the queue is a good guide when selecting an extent size. I.e. make your extent size proportional to the amount of data which moved through the queue. For example: Assuming you're not too worried about disc space, for a queue with 50MB of data throughput pick an extent size of 10MB.
Has anyone got any ideas whether this approach is sound?
The technical reference makes the following statement, which although accurate isn't very helpful:
In choosing an extent size there is a tradeoff between the amount of disk space used and the overhead of creating and deleting files. If the extent size is too small, the system will pay a performance penalty, creating and deleting files frequently. In addition, if the active part of the queue spans many files, all those files will need to be open at the same time, consuming system and process file resources.
Regards, Sebastian.
Has anyone got experience in selecting an extent size for BDB Queue toplogy databases? I'm trying to pick an extent size for a database and have come to the conclusion that throughput of data through the queue is a good guide when selecting an extent size. I.e. make your extent size proportional to the amount of data which moved through the queue. For example: Assuming you're not too worried about disc space, for a queue with 50MB of data throughput pick an extent size of 10MB.
Has anyone got any ideas whether this approach is sound?
The technical reference makes the following statement, which although accurate isn't very helpful:
In choosing an extent size there is a tradeoff between the amount of disk space used and the overhead of creating and deleting files. If the extent size is too small, the system will pay a performance penalty, creating and deleting files frequently. In addition, if the active part of the queue spans many files, all those files will need to be open at the same time, consuming system and process file resources.
Regards, Sebastian.
Comments
-
Hi Sebastian,
If you are not too worried about the disc space, you don't specify any extent size at all and the Queue will reside in a single file, without releasing any disk space.
You belive that a report of 5:1 will be good engough for those who want not to stress the system too much, by deleting/creating files to often? Or that a proportion should exist between the throughput and the extent size? And if yes, what's the logic behind this assumption?
I'm not sure that there is a universal prescription for extent size, because the extent size might depend on the database size, record size or even on the file system type.
Can you please provide those details regarding your environment, and what differences did you see by choosing different extent sizes? Maybe someone experimented and discovered the same approach.
This is why you think that the technical reference isn't very helpful, because there is no universal solution in this case... and also it's not easy to divide only in 2-3 subcases.
Regards,
Bogdan Coman
This discussion has been closed.