What is the use of SET TRANSACTION USE ROLLBACK SEGMENT ?
Answer Posted / daid kumar
In The case of Very large transaction oracle gives the
Error:-ORA-01555 "snapshot too old"
in this case we have to increase the size of lback segment
and we can assign particular one segment for that
transaction.
before transaction we write
SET TRANSACTION USE ROLLBACK SEGMENT <seg name>
Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is 2nf in database?
What is the main purpose of database?
how to generate an auto incremental number in a ssis package?
Explain what are the two types of oltp?
Which database server is best?
How do we select distinct values from a table?
What is the main purpose of normalization?
What is the purpose of a field in a database?
What is the role of database management system?
What is the importance of database in an organization?
What is bcnf?
Is the internet a database?
Whats is an OLTP Database
what are parameter, we can check after creating a database in terms of QC and for each tables what should be the parameters for QC and QA?
What are the four components of a database system?