Explain an ORA-01555
Answers were Sorted based on User's Feedback
Answer / guest
The most common reason is that the rollback segments are
too small
http://www.cryer.co.uk/brian/oracle/ORA01555.htm
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / bezalel
ORA-01555:
-----------
snapshot too old: rollback segment number string
with name "string" too small
Cause:
-------
rollback records needed by a reader for
consistent read are overwritten by other writers
Action:
-------
If in Automatic Undo Management mode, increase
undo_retention setting. Otherwise, use larger rollback segments
Is This Answer Correct ? | 0 Yes | 0 No |
Why more redos are generated when the oracle database is in begin backup mode?
What is store procedure?and how do u take the values from database and run in scripts?
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
What is mrc and what is its use? : oracle accounts receivable
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
which one is currently in used software cmpanies.
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
What are different types of transactions in ar? : oracle accounts receivable
Difference between transaction type and transaction sources. : oracle accounts receivable
hi all, i have installed oracle xe software in windows 7. iam unable to connect sqldeveloper tool. can you please tell me how to connect. provide completed procedure.