ORA-22280: no more buffers available for operation



ORA-22280: no more buffers available for operation..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

KUP-04000: error initializing IO state for file string in string

1 Answers  


ORA-39087: directory name string is invalid

2 Answers  


ORA-16777: unable to find the destination entry of a standby in V$ARCHIVE_DEST

1 Answers  


ORA-02814: Unable to get shared memory

1 Answers  


ORA-01685: max # extents (string) reached in index string.string partition string

1 Answers  


O2I-00102: Unable to connect to Oracle

1 Answers  


ORA-30184: argument type not compatible with a format code

1 Answers  


LSX-00008: feature "~s" is not implemented

1 Answers  


DRG-11125: invalid format of existing log file string

1 Answers  


ORA-01568: cannot set space quota on PUBLIC

1 Answers  


ORA-00131: network protocol does not support registration 'string'

1 Answers  


ORA-00238: operation would reuse a filename that is part of the database

1 Answers  


Categories