0

Hi,

1- When i insert more than 30 datas (at once) into a table, does sequence cache size(20) effect anything because, i use sequence for auto increment in the table.
2-What happens if i increase the cache size from 20 to 50?

thanks

4
Contributors
4
Replies
5
Views
9 Years
Discussion Span
Last Post by Nige Ridd
0

The cache size is how many Oracle will cache in memory, so when you first select a next value it will read the sequence from disk (n), and write back a next value of n+20. Then as you keep getting a next value it will just give you the next value from cache until all 20 have been used, then repeat the process.
The down side is that if the server crashes or is restarted, those sequence numbers cached in memory will be lost so if you only used 10 values - there will be a gap of 10 in the sequence. This may not be a problem, but some systems require all values to be accounted for ( e.g. some invoice systems )

Nige

0

It depends on wether you are inserting images, Or just text...

Not sure what you mean by that? Wouldn't have thought the content would have affected it.

Nige

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.