⟩ Explain What is ORA-1555?
its called snap shot too old error.
it comes if a user is updates a table with loop option, in another session an user to see the info(select) then its shows ora-1555
error
its called snap shot too old error.
it comes if a user is updates a table with loop option, in another session an user to see the info(select) then its shows ora-1555
error
What is a Control file?
How will you monitor rollback segment status?
Why query fails sometimes?
How will you monitor the space allocation?
How the space utilization takes place within rollback segments?
How will you create multiple rollback segments in a database?
What is a rollback segment entry?
What is hit ratio?
What are disadvantages of having raw devices?
What is use of rollback segments in Oracle database?