orra 1555 what is this error,why it is occur?
Answer Posted / kittu
The ora-1555 is too old snapshot. In order to fix this e need to increase undo_retention & undo tablespace size
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Why would you use sql agent? : sql server DBA
what is the use of recording information about current session?
What are the commands you'd issue to show the explain plan for "select * from dual"?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
what is the diffrence between core dba and apps dba?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
What are the different ways you can create databases in sql server? : sql server DBA
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit