What is the use of SET TRANSACTION USE ROLLBACK SEGMENT ?
- 1 Answers
- 5683 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is the maximum line size that dbms_output can handle?
Which is the most used database?
Is google scholar a database?
What are queries in dbms?
What do you understand by functional dependency and transitive dependency in dbms?
What are the disadvantage in file processing system?
write a query to Find the Maximun second value in table?
What is e-r model in the dbms?
What is 3nf in the dbms?
List few ways to code transactions in an efficient manner?
What exactly is a database?
What is 2nf in dbms?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
