Interested to Buy Any Domain ? << Click Here >> for more details...
What is the use of SET TRANSACTION USE ROLLBACK SEGMENT ?
- 1 Answers
- 6058 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 are the two types of indexes and explain them in detail?
please explain Nomalization in dbms?
What are the different file extensions that are created by Oracle ?
Which database is best for storing large data?
Why is databases important in healthcare?
I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?
What is rdms?
What is field in database give an example?
How to schedule ssas database backup
Why is normalisation used?
What are different types of transaction isolation levels?
Who proposed the relational model?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
