Database Administration (MOSC)

MOSC Banner

Few questions related to insert/update/delete

edited Jun 10, 2011 3:52AM in Database Administration (MOSC) 3 commentsAnswered
 Hi,              On May 6, 2011 around 10:18, there was a problem of access to storage causing partial unavailability of Oracle Database.During this period,application  made attempts to access the Database through commands SELECT, INSERT, UPDATE and DELETE.Apparently, the commands fired by the application did not receive feedback of success or failure of the Database.

Alert log entries during the time period reported like :
ORA-27091: unable to queue I/O
ORA-27072: File I/O error
Linux-x86_64 Error: 5: Input/output error

Our questions are:

1) During the period of problem , did oracle  was receiving requests for SELECT, INSERT, UPDATE and DELETE statements sent by the application?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center