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
How would you go about verifying the network name that the local_listener is currently using?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
how can you find out if a table can be redefined?
How can you control the amount of free space in your index pages? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What is the difference between dropping a database and taking a database offline? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What happens on checkpoint? : sql server DBA
which background process invoke at the time of upgradation tell me???
how can you generate profile of pl/sql applications to identify performance bottlenecks?
