Explain different categories of failures that occur in Oracle database?
Categories of Failures - In Oracle database subsequent types of failures can occurred:
Statement Failure
• Bad data type
• Insufficient space
Insufficient Privileges (e.g., object privileges to a role)
User Process Failure
• User performed an abnormal disconnect
• User's session was abnormally terminated
• User's program raised an address exception
User Error
• User drops a table
• User damages data by modification
Instance Failure
Media Failure
• User drops a table
• User damages data by modification
Alert Logs
• Records informational and error messages
• All Instance startups and shutdowns are recorded in the log