Answer Posted / ashok
increase the size of undo tablespace
increase retention period
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
how can you implement fine-grained auditing?
What are the different ways you can create databases in sql server? : sql server DBA
What is transparent data encryption? : sql server DBA
What is the default fill factor value? : sql server DBA
Why would you use sql agent? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
What types of replication are supported in sql server? : sql server DBA
what is a crs resource?
how can you connect from 10g user to 11g user??
what is the use of ocr?
What the different components in replication and what is their use? : sql server DBA
Query processing is slow(eg select query)how will u solve that