aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

OCI-22280: no more buffers available for operation

OCI-22280: no more buffers available for operation
Cause: There are two causes: (1) All buffers in the buffer pool have been used up by previous operations (2) Attempt to flush a LOB without any previous buffered update operations.
Action: For (1), flush the LOB(s) through the locator that is being used to update the LOB. For (2), write to the LOB through a locator enabled for buffering before attempting to flush buffers.

请先 登录 后评论

1 个回答

小智
OCI-22280:没有更多的缓冲区可用于操作,
.原因:有两个原因:(1)缓冲池中的所有缓冲区已被先前的操作用尽(2)尝试在没有任何先前的缓冲更新操作的情况下刷新LOB。,
.操作:对于(1),通过用于更新LOB的定位器刷新LOB。对于(2),在尝试刷新缓冲区之前,通过启用缓冲的定位器写入LOB。,
.
请先 登录 后评论