Explain an ORA-01555

Answers were Sorted based on User's Feedback



Explain an ORA-01555..

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

Explain an ORA-01555..

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

Post New Answer

More Oracle AllOther Interview Questions

Why more redos are generated when the oracle database is in begin backup mode?

0 Answers  


What is store procedure?and how do u take the values from database and run in scripts?

2 Answers   Polaris,


Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

0 Answers  


What is mrc and what is its use? : oracle accounts receivable

0 Answers  


WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

0 Answers  






which one is currently in used software cmpanies.

0 Answers  


PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

0 Answers  


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.

0 Answers  


which gives Oracle R12 Financial training in delhi please give me answer its urgent?

0 Answers  


What are different types of transactions in ar? : oracle accounts receivable

0 Answers  


Difference between transaction type and transaction sources. : oracle accounts receivable

0 Answers  


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.

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)