Interested to Buy Any Domain ? << Click Here >> for more details...
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 do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How would you best determine why your MVIEW couldn't FAST REFRESH?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
What the different components in replication and what is their use? : sql server DBA
when does an alert gets signaled?
What are statistics, under what circumstances they go out of date, how do you update them?
what is a user-defined lock?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Where would you look for errors from the database engine?
how can you find out if a table can be redefined?
what are the performance views in an oracle rac environment?
Which autogrowth database setting is good? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
Explain materialized views and how they are used.
