Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Laurits Sogaard Nielsen: "Oracle Maestro (and also MS SQL Maestro) are the perfect substitutes for TOAD and in some ways also much better products (they are much cheaper, and the support is fast and easy). I'm looking forward to getting much more experience with both products, that already now have proven themselves to be fantastic".
Qian Dong: "Although I evaluated Oracle Maestro for only a couple of days, I must say I like what I saw in this product. I am going to place an order for this product.

Thank you for the good work".

More

Add your opinion

Customers
Download Buy

Oracle Maestro online help

Prev Return to chapter overview Next

LOB properties

Tablespace

The only parameter of LOB parameters you can specify for a hash partition or hash subpartition. It allows you to define storage characteristics of the field.

 

Storage in row

Specify whether the LOB value is to be stored in the row (inline) or outside of the row (out of line). The LOB locator is always stored inline regardless of where the LOB value is stored. If checked the clause specifies that the LOB value is stored inline if its length is less than approximately 4000 bytes minus system control information. Otherwise, the LOB value is stored out of line regardless of the length of the LOB value.

 

Chunk size

Specify the number of bytes to be allocated for LOB manipulation. If integer is not a multiple of the database block size, then Oracle Database rounds up (in bytes) to the next multiple. For example, if the database block size is 2048 and integer is 2050, then the database allocates 4096 bytes (2 blocks).The maximum value is 32768 (32 K), which is the largest Oracle Database block size allowed. The default size is one Oracle Database block.

 

Use retention

Use this clause to indicate that Oracle Database should retain old versions of this LOB column.You can specify the retention parameter only if the database is running in automatic undo mode.

 

Old versions space

Specify the maximum percentage of overall LOB storage space used for maintaining old versions of the LOB. The default value is 10, meaning that older versions of the LOB data are not overwritten until they consume 10% of the overall LOB storage space.

 

Free pools

Specify the number of groups of free lists for the LOB segment. Normally integer will be the number of instances in a Real Application Clusters environment or 1 for a single-instance database. You can specify this parameter only if the database is running in automatic undo mode.

 

Cache

Use the CACHE clauses to indicate how Oracle Database should store blocks in the buffer cache.

 

Logging

The clause lets you specify whether creation of a database object will be logged in the redo log file or not.



Prev Return to chapter overview Next